Skip to Content

SAP Analytics Cloud - How to use MAX aggregation in context of a single dimension

Hello all,

In an SAC Story I am calculating the date offset between "current date" and "work week date" for a Project dimension and Work Week - so far so good. I then want to display the MAX offset for that Project. I have defined the calculation for my MAX aggregation as follows:

However, as you will see from the below Table, the MAX does not calculate correctly. Even though I have not selected Work Week as an Aggregation Dimension, it still includes it:

I should be seeing "-7" as the Max Offset on all 4 lines. So, how is this achieved? Am I misunderstanding the workings of the Aggregation Dimensions?

Many thanks.

max1.png (23.4 kB)
max2.png (27.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 18 at 03:12 PM

    It seems it's defect.Even i have tried and i got the similar result.Max/Min is not working.I would suggest to raise a sap ticket.

    I found below sap note but it is more related with workaround in chart and which is i found not useful in chart also.

    2594760 - MIN and MAX aggregation calculations does not work correctly in SAP Analytics Cloud

    Add comment
    10|10000 characters needed characters exceeded