Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a pie chart that I would like to convert to gauge and wanted to know if its possible.
I have the following Columns
Column Name: Medication
Row (can have any of the following): A, B, C, etc..
Column Name: Confirm Status - Patient Level
Row (can have any of the following): Yes, No, Partial
Column Name: Confirm Status - Account Level
Row (can have any of the following): 1, 0
Accounr # | Meds | Confirm Patient Level | Confirm Account Level |
---|---|---|---|
m1 | a | Yes | 1 |
m1 | b | Yes | |
m1 | c | Yes | |
m22 | a | Yes | 1 |
m22 | b | No | |
v55 | a | No | 1 |
v55 | b | No |
An account can have multiple medications. The logic is that per account, a medication can have a confirm status of Yes, No, or Partial, (which is under Confirm Status - Patient Level column).
To group all of the account and their confirm status, we assigned a 1 for all account with the same number.
My Pie Chart has the following Dimension and Measures
Dimension: =[Confirm Status - Patient Level]
Measure = Sum([Confirm Status - Account Level])/Sum(Total [Confirm Status - Account Level])
I would like to convert into a gauge in order to see rate of only "Yes" percentage rate.
Please help.
Hi Salamon
Use the same dimension and for the measure use the following:
Sum({<[Confirm Status - Patient Level]={'Yes'}>} [Confirm Status - Account Level])/Sum(Total [Confirm Status - Account Level])
Format the number to a % and make sure you change the Range limits Min and Max to 0 and 1
Thanks
Dan
Hi Salamon
Use the same dimension and for the measure use the following:
Sum({<[Confirm Status - Patient Level]={'Yes'}>} [Confirm Status - Account Level])/Sum(Total [Confirm Status - Account Level])
Format the number to a % and make sure you change the Range limits Min and Max to 0 and 1
Thanks
Dan
Thank you,