SAC Analytics Cloud - aggregation

[former_member789457]

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]

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]

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

[former_member789457]

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