Histogram visual - data aggregation

[EmaVasileva]

Hi team,

I’m trying to use a histogram visualization, with Value (work) from one table and Frequency (Shift) from another table.
Here is the raw data:

The issue I have is that when I'm using the Shift in any of the two fields, there are no results (I think this is happening because the shift is a 'text' not a number), or they are aggregated to the smallest unit. I need my histogram to show the work aggregated by shift. Also I will need the histogram to be able to be filtered by extra slicers, such as date, type (another field from the table). 

Have you met the same issue or do you now how this can be fixed?

Thank you.

[David-Ganor · Accepted solution]

Hi @EmaVasileva ,

Histogram is used to present a distribution - which requires 2 numerical values - for example class grades: value = grade, frequency= how many students gottjis grade.

In your case you'd like to show sum of work (probably hours or days) group by shift.

You can use the bar chart for that. In the value- make sure that the work is "sum of work" (aggregation).

Also you can sort it by shift name, or by the sum of work.

Hope it helps.