2 Replies Latest reply on Mar 7, 2012 8:31 PM by Andrew Marritt

    Bullet graph - show all options of dimensions even if zero / null

    Andrew Marritt

      Sorry if I'm missing something basic here.

       

      As the title says, I'm trying to show progress against targets with a bullet graph.  My data has an 'achievement' measure and I've joined a table with targets, also as a measure.  There are 7 categories in a dimension field (think groups whose performance I want to show) which I'm using on the row shelf to create 7 different bullets.

       

      I would like to show each of the 7 categories even if the group hasn't achieved any 'sales'.  At the moment I can only get it to show a group if the achievement measure isn't null.  Of course the target still exists even before the first 'sale'.

       

      What am I doing wrong?