Forum Discussion

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Displaying multiple measures in bar chart

Hi there,   I have data about the time taken to complete activities. I have created a measure that calculates whether the job has done before the estimated time or after the estimated time. Measure...
Need Help
Show and Tell
Tips and Tricks
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    Dunner2020  Please see attached file (below signature). You need to create the calculation as COLUMN, not Measures. Then right click the new column and choose "New Group" (select edit group to see the grouping I chose).

     

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
5 years ago

AllisonKennedy , Thanks for the solution. The only problem with the binning/grouping is that: Bin 0 also counts the Minutes Diff that has non zero values. Is it possible that we define bin in such a way that bin 0 only counts zero values??

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Dunner2020  You can try to cheat the histogram distribution, but this moves the values to the 15 category so that 15 category includes values greater than 0 and less than 30. That makes this category twice as big as all the others, so not really a fair distribution, but I can see why you would want to do this. 

     

    Another option is to highlight on the distribution which values are exactly equal to 0. See what you think of the file below signature. Colours need updated, and you probably want to filter out the blanks, but the concept is there.