Forum Discussion

akshaydz's avatar
akshaydz
Frequent Visitor
8 years ago
Solved

Showing percentage column chart from count?

Hi,  I have my data as displayed below, I have the second column populated using a Count(Distinct) of values. I want to generate the percentage column for each row using the first month as 100%. Can...
Need Help
  • jthomson's avatar
    jthomson
    8 years ago

    Then where I've put a lookupvalue to get the start value, try wrapping your distinct count measure in a calculate and filter for your starting month

akshaydz's avatar
akshaydz
Frequent Visitor
8 years ago

Hi jthomson,

Thanks for the reponse but the table which am showing above is not an actual table, its table from visualisation having count(distinct) for each month from the actual table.

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

Then where I've put a lookupvalue to get the start value, try wrapping your distinct count measure in a calculate and filter for your starting month