Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Hi
Something like this perhaps?
Max(aggr(count distinct Order_No, Year, Product)) > 3
Hope that helps
Jonathan
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.
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...
Hi
Something like this perhaps?
Max(aggr(count distinct Order_No, Year, Product)) > 3
Hope that helps
Jonathan
Or probably Min....
Jonathan