0

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

Sep 28, 2017 at 02:38 PM

27

Former Member

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)

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?

Koen Hesters Sep 28, 2017 at 02:52 PM
1

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

Share
Former Member Sep 28, 2017 at 02:54 PM
0

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

Show 2 Share

best way is to go case by case

Former Member

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.