Pie chart showing the share of null value and non-null value (in %)

[Black_Hole]

Hello all,

Please could you help me to represent in a pie chart the share of null value and non-null value (in %) from a specific field.

Thank you in advance for your help.

[arpitkharkia]

Create a flag in the back end like

if(Isnull(YOurDimension),0,1) as flag

Use the flag as a dimension in the pie chart.

I hope this helps!

Regards,

Arpit 

[Black_Hole]

Hi @arpitkharkia ,

Thank you for your help.

Please could you explain when you say "create a flag in the back end"? 

Is it in the script editor or in expression part of the graph ?

Thank you in advance for your help.

[arpitkharkia]

This is in the script, it would not put load on the front end graph, and it will load faster.

I hope this makes sense! 🙂 

[Black_Hole]

I think that I don't take it in the good way. Indeed, when I try it, I have an error message.

Below my code in the script editor:

LOAD
IF (Isnull(name),0,1) as flag
FROM customer_table;

Please could you tell me what is false in the code above.

Sorry, for my low level in Qliview...

Thank you in advance for your help.

[arpitkharkia]

What is the error? If you can share some sample data it will be great!