I would like to make a pie chart where i have resolution times, but due to too many different values i need to group them. this pie chart display ticket open times this mean i will need groups like following :
1st group : 1 min to 15 min
2nd group: 16 min to 30 min
3rd group: 30 min to 1 h
4th group: 1 h to 2 h
5th group: 3h to 4h
a solution where i group by half hours is less suited , but can also help.
Sometimes some ticket don't have a time at all , then the value is 00:00
do you have any clue how to achieve that ? thank you in advance.
I tried again, if i display it on a table i have the correct anser , but if i select the differents groups it break the link with the rest of the displayded infromations, also i have to show it on a pie chart , so i need a count, per example 120 call closed under 15 min, 83 under 30, etc.
Do you have an idea how to add a count to the conditions and make so that if i select a group it filter also the information on the display ??
Thank you one more time for this helpfull first part