Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi Experts,
I am trying to show 80 20 report for my customers.For that i have done one chart had customers as dimension and using expression as
if( (Rangesum(above(count(bookings),1,rowno())) / count(total<bookings>bookings)) <=0.8,
count(bookings) ).
This gives values as 20% customers who are all giving 80% business. but my problem is the chart shows null values to other customers who are all not in the 20% customer.
can anyone give solution how remove this null values?
please see the image attached.
thanks in advance
Instead you can use Dimension Limits to show 20% or 80% customers. Thanks
Try checking 'Suppress When Null' on the presentation tab of the chart properties
thanks for your reply,
i have tried but it won't work.
Instead you can use Dimension Limits to show 20% or 80% customers. Thanks
Would you be able to share a sample?
thanks satayadev it works.