7 Replies Latest reply: Mar 9, 2011 11:54 AM by Anne Duffy RSS

    No data to display

      Hi guys

      I have 3 pie charts that display based on Yes No answers in Excel spredsheets.

      However, on occasion when certain criteria is slected , they change to a horrid No Data to display icon ( or error message of sorts!) It is correct that they have no data to display on these specific selections, however, its looks awful popping up like that.

       

      I have tried using sets but as I want the charts to show based on some selections I'm not sure how to write a suitable set, I would like to be able to either'

      a) Minimize Chart when there is no valid data

      or

      b) Format the No data to display message to something prettier

       

      Does anyone know if either is possible and if so How ?

      Please help

       

      Thanks

        • No data to display
          Miguel Angel Baeyens de Arce

          Hello,

          Have you checked in the chart properties the button "Error messages"? You might create even a calculation condition so if some fields have soem selections, the chart will display -say- "Please select a Question".

          Hope that helps.

            • No data to display

              Hi Miguel

              I had a look in that Option, there is no toggles to turn off, Not too sure how to write something for it

              Have you written a calculation for that field ? Would you have a sample to start me off at all

               

              Thanks

                • No data to display
                  Miguel Angel Baeyens de Arce

                  Hi,

                  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.

                    • No data to display

                      Thanks Miguel

                       

                      Thats a great help I'll see if I can amend that to suit my data

                       

                      Anne

                      • No data to display

                        Hi Miguel,

                        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

                         

                         

                         

                         

                         



                         

                        GetSelectedCount

                         

                         

                        I tried a few different variations but I just cant get it , Can you please help ??

                        Thanks

                        ([Actioned within 48 hours ?])<1



                          • No data to display
                            Miguel Angel Baeyens de Arce

                             


                            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.