Hi all,
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
TIA, Mark.
