I want to build a bar chart where on the x-axis I have a dimension which is not in time format and on y a key figure which is summed up.
How is this possible in SAC?
@Lukas Gaertner, In Stories, currently cumulative measures are possible only across the time dimension.
I have version 2020.1.4
Hi @Lukas Gaertner,
In designer pannel, select the column chart option. This will satisfy your requirement.
Thanks and Regards,
but this way it does not cumulate.
By default, for all the keyfigures/measures the aggregation defined in your model will get applied.
would you be able to share more details, potentially a sample set of data to outline what you are looking for ?
Ingo Hilgefort, SAP
@Ingo Hilgefort I have a dimension ("Structure") and a measure ("Costs") and want to visualize the "Cumulated Costs" over the structure. Like in this example I built in Excel.
Hi @Lukas Gaertner ,
Interesting, curious to see if there's a solution here.
Just double checking, your requirement is for Analytics Designer apps and not Stories, correct?
@harikrishnans Thank you for your answer. I hope this very basic feature will be added soon.
Not sure if your requirement is fixed to column chart but if not, a table in SAC (stories) is able to do a running sum without the dimension time. In the example below, I just demonstrated how to do it technically since it doesn't make sense to add chargeability in this case:
Right-click on desired column (in your case, Costs) and add calculation accumulative sum: