Skip to Content

How can I use calculated variables as standalone items for charting?

Sep 28, 2017 at 02:38 PM


avatar image

I have some calculated values such as average sale, runningsum, and count of items in a table which you can see in the attached picture below.

I am trying to figure out a way to use those calculations to fill another table since I will have many of these tabs for different products.

So the idea is to take all of these calculated values and populate them into a separate summary table and then chart that information.

This may not be possible in Webi, however, I know that if it is, this community will help!

variable.png (10.5 kB)
10 |10000 characters needed characters left characters exceeded

Can you give an example of what your final table is going to look like? Maybe I’m oversimplifying this but if you just had a table with the Product dimension and the sum, count and average measures wouldn’t that give you what you are looking for?

* Please Login or Register to Answer, Follow or Comment.

2 Answers

Koen Hesters Sep 28, 2017 at 02:52 PM

you have to reflect that a calculation in a table is executed per line/row and so splitted out by the dimensions used in the table and at the other hand if you use a standalone calculation, it is possible it will not react/calculate the same way, so you will have to use in some cases other formulas

10 |10000 characters needed characters left characters exceeded
Travis Reynolds Sep 28, 2017 at 02:54 PM

Can you give an example of some of other formulas that might make this work?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

best way is to go case by case


Can we look at it on this case? I think I can work my way through the rest of them if I can get some help on the first one.