Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed 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?

  • Get RSS Feed

2 Answers

  • 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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 28, 2017 at 02:54 PM

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

    Add comment
    10|10000 characters needed characters exceeded