Converting Pie Chart To Gauge Help

[smusayev]

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.

[danansell42 · Accepted solution]

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

[smusayev]

Thank you,