Maximum Number of Data Items

On the “Data” tab you may set the maximum number of items which can be displayed in the chart. Let us create the following example: put all the cities of the hierarchy “Geography”:

On the columns we will display years, the measure “Reseller Sales Amount” will be displayed in the table. Switch on the chart:

As you may see, there are 1163 elements on the chart. This is a big amount – bigger than the allowed number in the settings. In order to change the settings, press the button “Settings” and change the setting onto 1200:

After pressing «OK» you will see the following:

Pay attention to the fact that the chart can be painted for a long time in the case if there is a huge number of elements on the chart. In order to avoid waiting you can set up maximum amount of elements, so that the chart will be painted only when the number of elements is less than the maximum amount.

As you may see, when «Too much data» message is displayed, there are two available options: “Draw Chart” and “Change chart settings”:

If you press the link “Draw chart”, the chart will be drawn but the settings will not change. The chart will be visible until you change the structure of the report.

The link “Change chart settings” does the same as the button “Settings” in the bottom left corner of the page – it will open the form for changing the chart settings.