EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB31250: "There is insufficient data to display the requested chart subtype for this report. Try using another chart subtype" error message appears when choosing Total element in attribute selector for targeted graph in MicroStrategy Web 9.x


Community Admin

• Strategy


"There is insufficient data to display the requested chart subtype for this report. Try using another chart subtype" error message appears when choosing Total element in attribute selector for targeted graph in MicroStrategy Web 9.x

SYMPTOM:
In Report Services Document of Strategy Web 9.x, when choosing Total element in the attribute selector for targeted graph, the following error message appears:
 

ka04W000000OdnzQAC_0EM4400000028Fb.png

 


There is insufficient data to display the requested chart subtype for this report. Try using another chart subtype.

  
STEPS TO REPRODUCE:
Follow the steps below to reproduce this problem in the Strategy Tutorial project:

  1. Create a graph report with any graph type, place Year, Category on the row and Cost, Revenue on the column.
  2. Use the graph report created at step 1 to build a Report Services Document.
  3. Use Year as attribute selector and target the graph report, enable the option "show total" in the selector property editor.
  4. Run the Report Services Document in Interactive mode or Flash mode, choose the Total element for Year selector. The error message should be displayed: "There is insufficient data to display the requested chart subtype for this report. Try using another chart subtype."

CAUSE:
Graph does not show subtotals by default, they have to be enabled.
 
ACTION:
Follow the steps below to enable the option "Show subtotals" under the graph formatting editor:

  • In the interactive mode of Report Services Document, right mouse click on the graph and select "Format" to bring up the graph formatting editor, then go to advanced tab and check the option "Show subtotals", as shown below:
     
ka04W000000OdnzQAC_0EM4400000028Fn.png
  • Click "OK" to save the change, run the Report Services Document again and choose Total element in attribute selector. The targeted graph will display the correct result: as shown below:  
     
ka04W000000OdnzQAC_0EM4400000028Fo.png

 


Comment

0 comments

Details

Knowledge Article

Published:

June 15, 2017

Last Updated:

June 15, 2017