As an example, say that you don't want the chart to display data if there are not selected two years, at least.
In the chart properties, General tab, Calculation Condition write something like
GetSelectedCount(YearField) > 1
Then click on the "Error Messages" button, select the "Calculation Condition Unfulfilled" and write "You need to select at least two years to display data".
The chart will always appear, although it will be empty and will only show that sentence unles the user has selected two or more years, then the chart wil be calculated and rendered.
Use this example with your own conditions so if there are some selections to get some data, the user needs to know that he has to sleect some values to get the chart.
Hope that helps.
I'm sorry to be annoying you, I have tried your suggestions and I cant quite get it to work for me,
The chart works on a field called [Actioned in 48 Hours) , basically just counting Yes versus No.
There a 3 Teams in a list box , A,B,C that when I click on it gives the results for each team However, some of the Teams do Not have any results ( this would be correct) I am trying to avoid the message No data to display.
So in the General Tab I wish to write a condition that simply says if the results after team selection is Zero, use the message in the Error Message button.
The condition I wrote is
I tried a few different variations but I just cant get it , Can you please help ??([Actioned within 48 hours ?])<1
Blossomthe2nd wrote:There a 3 Teams in a list box , A,B,C that when I click on it gives the results for each team However, some of the Teams do Not have any results ( this would be correct) I am trying to avoid the message No data to display.
Ok. Then forget the calculation condition, and set the conditional in your expression, something like
If(NOT Count(Answer), 0, Count(Answer))
That will return 0 when there is no Answers to count for the team (dimension) selected.
Besiedes, check that in your graph properties, Presentation tab, "Suppress Zero Values" checkbox is unchecked. That will show the chart even when there is no data.
Hope that helps.