Skip to Content

How to aggregate calculated measures

Hello Gurus,

Here is my requirement: I have total shipments for each month for each customer. Some shipments are late (actual ship date-plan ship date). I need to categorize these late shipments into category like 1 day late, 2-3 days late etc (please see below table format that I am trying to get to). In the below table all I have from the model are Customer, dates and if a shipment is late or not or the month

So I create calculated measure for each category using days late obtained from actual ship date-plan ship date assigned value 1.

ex: for 1 day late below is the formula I created and all other categories are created this way. The yellow highlighted columns in Pic 1 are the measures I created.

IF([(actual ship date-plan ship date)<0 AND (actual ship date-plan ship date)>=1,1 ,0)

Then I pulled these calculated measures under measures in the chart (stacked bar chart) but the values are not aggregating . pic 2 is the table i need to achieve

Pic2:

Appreciate any guidance

pic-1.jpg (63.4 kB)
pic-1.jpg (63.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 30, 2020 at 11:30 AM

    Have you tried creating a measure based dimension using the delay period. Say 0-1 is less 1-10 is medium and 10 and above is high.

    And use that dimension in stacked chart.

    -Ashutosh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.