If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dashboard % of total (11.1.7)

Started by greatmaze, 26 Apr 2021 08:01:07 AM

Previous topic - Next topic

greatmaze

Hello all,
I have a table with 3 columns

Valid   Test   #
  1        A      2
  1        B      4
  1        C      6
  0        D      9

In my dashboard I can make the 3 desired measures, with a filter on Valid=1 and filter Test=A for first measure Test=B in second and Test=C in last one.
Now I want a percentage of the total next to the measure. For A=2/12  B=4/12  and C=6/12

The filters Valid and Test are only on these 3 measures and not on the whole dashboard.
How do I calculate this in a new %measure?
I don't know how to use a measure with filter together with a measure that has a different filter.

Thx in advance

bus_pass_man

 percentage ( {your measure} for report   )  might be what you are looking for.

adam_mc

I think you need to do something like:

percentage([Your Measure] for [Valid])

Then, as that will give you percentages for Valid = 0 (which by your description, you don't want/need), you can use some sort of conditional formatting to hide that total row.

Hope that helps,
Adam.