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

KB40738: Pie Graph does not show values ‘0’ when using Use ‘Smart’ Label Placement in MicroStrategy 9.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


Pie Graph does not show values ‘0’ when using Use ‘Smart’ Label Placement in MicroStrategy 9.x

 
SYMPTOM:
 
When using the graph options Use ‘Smart’ Label Placement on Pie Graph, the series returning “0” are not displayed.
 
 
STEPS TO REPRODUCE:
 
Follow the steps below to reproduce this issue using the Strategy Tutorial Project:
 
             1)     Create a new metric using the expression - 5] where is a fact.
     2)     Create a new report adding the Item attribute to rows and the newly created metric to columns.
     3)     Add the first local filter of type Attribute Qualification, Qualify on Elements and the In list operator based on the Item attribute, so select the elements Panasonic 4-Head Hi-fi VCR, Panasonic Home Theater Stereo VCR, Panasonic Multiformat DVD Player, Panasonic HI-FI Stereo VCR and Panasonic 27" TV/DVD Player Combo.
     4)     Add the second local filter of type Attribute Qualification, Qualify on Elements and the In list operator based on the Year attribute, so select the element 2008.
     5)     Add the third local filter of type Attribute Qualification, Qualify on Elements and the In list operator based on the Call Center attribute, so select the element Atlanta. The report local filter area should be similar to the example below:
  
         

ka02R000000kXS3QAM_0EM440000002DAJ.png

 
 
 
     6)     Run the report in grid mode to obtain the result below:
  
         

ka02R000000kXS3QAM_0EM440000002DA7.png

 
 
     7)     Switch to graph view mode and select the Pie Graph type.
     8)     Go to menu Graph and select Graph Options, under the Properties Categories, click on Series and check the options:
          a.     Use 'Smart' Label Placement
          b.     Show Values > Values outside Slices
          c.     Show Labels > Labels outside Slices
          d.     Show Leader Lines
    
     The Pie Graph Series configuration should be equal to the example that follows:
   
                          

ka02R000000kXS3QAM_0EM440000002DA6.png

 
 
 
     9)    Notice that the 0 metric value for Panasonic 4-Head Hi-fi VCR does not appear on the graph.
 
 
         

ka02R000000kXS3QAM_0EM440000002DAL.png

 
 
 
      10)    Disable the Use 'Smart' Label Placement to see Panasonic 4-Head Hi-fi VCR on the graph.
 
  
                        

ka02R000000kXS3QAM_0EM440000002DA4.png

 
  
 
CAUSE:
 
This is a known issue in Strategy 9.x.
 
 
ACTION:
 
Please contact the Strategy Technical Support for an update on this issue.
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 15, 2017

Last Updated:

June 15, 2017