Forum Discussion

IF's avatar
IF
Post Prodigy
5 years ago
Solved

chart with grouped data

Hi, I have the following data. I am using Name and Date columns at slicers. (the table looks stange, but should work with copy-paste).   NameStatusStatusKeyHoursDate X On time 2 1 12/2/202...
Need Help
IF's avatar
IF
Post Prodigy
5 years ago

Hi, Thanks for the reply. However, I want to group the data in some bars. -2 days, -1day, 1day, 2days and 3 days bars have two different type of data. For example; Name X: -2 days/hours is 3 in total. However, 2 of 3 is for early and 1 is for on time. Similarly, 3 days/hours is in total 4. However, 3 of 4 is on time and 1 of 4 is late. Early should be yellow, ontime is green and late is red. As you see at the post, these bars have two different colours. I want to do it in this way. If I change as you mentioned, it changes the whole bar.

All the best

  • gpiero's avatar
    gpiero
    Skilled Sharer
    5 years ago

    IF

     

    Something like this, right?

    And for each bar you would like to displaly X + Y, right? (now you can see only X)