Forum Discussion
Solved
Stacked area chart question
Hello, I would like to use the stacked area chart which shows % of documents per category per month. I use the following fields x-axis: month y-axis: count of docNR legend: channel (email, l...
Hi Aleksis
For this you need to create a metric that does the calculation for those specifi group try something similar to:
Metrics % = DIVIDE ( COUNT(Table[DocNR]), CALCULATE(COUNT(Table[DocNR]), ALL(Table[Channel]))If you want to have the chart based on the selected channels replace the formula to:
Metrics % = DIVIDE ( COUNT(Table[DocNR]), CALCULATE(COUNT(Table[DocNR]), ALLSELECTED(Table[Channel]))
Hi Aleksis
For this you need to create a metric that does the calculation for those specifi group try something similar to:
Metrics % = DIVIDE ( COUNT(Table[DocNR]), CALCULATE(COUNT(Table[DocNR]), ALL(Table[Channel]))
If you want to have the chart based on the selected channels replace the formula to:
Metrics % = DIVIDE ( COUNT(Table[DocNR]), CALCULATE(COUNT(Table[DocNR]), ALLSELECTED(Table[Channel]))