Hiding a chart based on a condition

[#1]

Hi,

Chart needs to be hided when there is no data to display.

Chart contains Year and Product as a dimension and count(distinct Order_No) as a expression.

This chart should be displayed when count(distinct Order_No)>3...

I have attached the sample file...

[markmccoid]

Just go to the charts Properties, then to the Layout tab.

On the Layout tab you will find "Show" section that let's you enter a conditional statement to determine whether or not to show the chart.

Just put your statement  "count(distinct Order_No)>3" and that will do it.

[#3]

Hi,

If we give  'count(distinct Order_No)>3' it wont consider the dimensions...it will check this condition globally...

If none of the Year&Prod_Id has count(distinct Order_No)>3 then only we need to hide the sheet.

Please see the attachment...

[jonathandienst · Accepted solution]

Hi

Something like this perhaps?

Max(aggr(count distinct Order_No, Year, Product)) > 3

Hope that helps

Jonathan

[jonathandienst]

Or probably Min....

Jonathan