I am working on a Qlik sense saas application that has a table with time tracking data. Each row has a user id, a project id, the time (in quarters of an hour) spent on the project and other dimensions like the date, department, etc. I want to create a histogram that shows the distribution of the total time users have spent, but I don't know how to do that, because the total (the sum of the time spent) is not a dimension. I tried to use a bar chart but again the problem is that the time total is not a dimension, and also I don't know how to count how many times a total value is occurring. Example data: personID; projectID;timeSpent 1;1;1 1;1;2 1;1;3 2;2;1 2;4;1 2;3;1 3;2;6 3;1;1
A table with time totals would show: personID;totalTime 1;6 2;3 3;7
The histogram should show the distribution of totalTime
