Working with histograms

[Anonymous]

Hi,

I need some help displaying datas with histograms; attatched you can find the .qvw file.

This is the dataset: each person (NAME) does different types of activities (TYPE) in a defined time (DATETIME); each person works 8 hours per day, so the sum of DATETIME displays what they have done. I would like to add in the histogram a dimension which displays the difference between 8 hours and DATETIME, so the time they have spent doing nothing.

In other words, next the red portion of graph i would like to have another color which displays the "free time".

Is it possibile to do this in frontend?

Thank you in advance.

[dmac1971 · Accepted solution]

Hi Andrea.  This should give you the output you are looking for.  I've added a variable to store the length of the working day, and added charts to show breakdown by time and %.  Hopefully this is what you were looking for.

[Anonymous]

This is exactly what i needed! Thank you