cancel
Showing results for 
Search instead for 
Did you mean: 

IBP Cumulative chart

2005025176
Explorer
0 Kudos

Hello,

is there an option in IBP Analytics App to build a cumulative chart, that would cumulate values for consecutive arguments? I'm thinking about something similar to pareto chart. So far I only built column chart in descending order (snip below); but is there any option to cumulate values?

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Hello Piotr,

Thanks. If that's the case, I'm afraid there is no option to do that inside IBP.

Sittinut R.

0 Kudos

Hi Piotr,

Got it. Is it always from product A to B and to C or you would sort the values first and accumulate from lowest to highest values.

Sittinut R.

2005025176
Explorer
0 Kudos

Hi Sittinut,

I'd need to sort them first every time.

Thanks,

Piotr

0 Kudos

Hello Piotr,

Unfortunately, I don't think we have the cumulative chart in IBP Analytics App.

But what you can do is to create another calculated key figure with the function IBP_CAGGR of Cleansed Sales History. And then use this key figure to display in Analytics App in descending order.

Hope this helps,

Sittinut

2005025176
Explorer
0 Kudos

Hello Sittinut,

Thanks for your comment; however as I understand IBP_CAGGR, it will cumulate key figure value on attribute level over time buckets, while I'm looking for a solution to cumulate values across consecutive attributes.

For example:

1st chart point: Value of Cleansed Sales for product A

2nd chart point: Sum of Cleansed Sales for A+B

3rd: A+B+C etc.

Maybe you have any idea how to work this out.