Forum Discussion
Post ProdigyDisplaying multiple measures in bar chart
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).
Post ProdigyAllisonKennedy Thanks a lot. You are saviour. The second graph is what I am after. I didn't know that we could use the switch statement to allocate the bin. I think which I still could not understand is that you mentioned about bin 0,15 and -15 in switch statement and mentioned their range and left remaining to allocate according to minutes diff. For instance if minute difference is 78 then it allocates to the 78 bin. When we plot the information, it is still showing the bin with 15 min difference and counting accordingly. Is it happening because we made a group or is it because of histogram? Sorry if my question sounds stupid.
- AllisonKennedy
Community Champion
Dunner2020 Glad it's working - you are making sense, now let's see if I can make sense with my reply: I used the SWITCH just to do the minimum bin (ie making 0 only 0 and allocating the values around 0 to the other value), then I used the current value of Minute Diff for all other values, and used the New Group to create the same bins as in my first solution, but because we have replaced all Minute Diff between 0 - 15 min with a value of 15, this will move them to the 15 bin.