Showing results for 
Search instead for 
Did you mean: 

SAC Analytics Cloud - aggregation


I need to graph an average of cumulative data, based on a transformed date dimension* with a live connection.

*We modified the date to a number to allow comparison between the Nth workday of the month, eliminating differences in holidays and different starting days in the month.

So the above should be this (of which i need to display the last column in a line graph with the number as the x-axis):

I have already seen several articles/resources offering different possibilities, but none of these solutions have worked for us (among others;

Since i can't change the datasource I thought I could simulate solution 4 of the article by adding a seperate excel file to transform the number to a cumulative, and link the dimension.

so this:

But i can't seem to get this to work either.

Does anyone how I have to do this (or if it is possible at all)?

Product and Topic Expert
Product and Topic Expert
0 Kudos

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with our Q&A Tutorial:, as it provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond:
Many thanks!

Keep in mind, when you receive an answer that was helpful to you, accept it as best answer.

0 Kudos

Hello Nick,

I am also facing the same issue. Need to aggregatin on months, I have used ResultLookup function. But that doesnt work in scenario when 2021-2022. The cumulative graph drops off in last month of the year.

Could please help me to resolve this issue.

Thanks in advance


Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hello M S,

We have since concluded that it is simply not possible (yet) in any other way than to calculate it directly in the datasource.

Kind regards