cancel
Showing results for 
Search instead for 
Did you mean: 

SAC Analytics Cloud - aggregation

former_member789457
Discoverer

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; https://www.linkedin.com/pulse/4-ways-calculate-accumulative-sum-sap-analytics-cloud-t%C4%83lmaciu/).

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)?

lenastodal
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: https://developers.sap.com/tutorials/community-qa.html, 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: https://www.youtube.com/watch?v=46bt1juWUUM
Many thanks!

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

madhi_2308
Explorer
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

MS

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member789457
Discoverer
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