Issue with Pie Chart

[ramanarayan]

HI QV Experts,

stalwar1‌- Would you please help on this issue. Appreciate it

I have a pie chart. The strange thing that i notice is that the red portion of the pie does not react when i click on it. The other portions of the pie works just fine except the red portion which has 21%.

I have a calculated dimension which is as follows.

=if(FRCA_Totaldays > 90 , 'Low (>90days)',

if(FRCA_Totaldays > 30 and FRCA_Totaldays <=90 , 'Medium (30 to 90 days)',

if(FRCA_Totaldays <= 30 , 'High (<30days)','Never Loggedin')))

what is not working is the last condition 'Never Loggedin'. Even when i put a condition to calculate never logged in, no luck.

The expression that i have for it is as follows.

=count(FRCA_Activity)/count(total FRCA_Activity)

But there is another pie with similar condition and it works just fine.

Attached is the pie chart.

Thanks for your help

[ramanarayan]

Hi Sunny,

Attached is the trimmed version of the qvw file. The chart on the left seems to be the trouble maker. The yellow portion (21%) is not working. The chart on the right uses similar calculated dimension and it is working just fine.

Thanks for your help

[sunny_talwar]

I think what you are trying to select it null value in FRCA_Totaldays

May be create a new field in the script like this

If(Len(Trim(FRCA_Totaldays)) = 0, 'Null', FRCA_Totaldays) as NewField

and then try this

=if(NewField> 90 , 'Low (>90days)',

if(NewField> 30 and NewField<=90 , 'Medium (30 to 90 days)',

if(NewField<= 30 , 'High (<30days)','Never Loggedin')))

and see if this works for you

[ramanarayan]

Hi Sunny,

Thanks for your inputs.

I made a minor change in the script formula which you gave.

If(Len(Trim(Totaldays)) = 0, '0', Totaldays) as FRCA_ActualDays

Instead of using 'Null' i made it '0', because the expression formula does not recognize Null as 0.

But still the never logged in bucket goes missing. This is what i see now