Help with Shift Slicer

[granthworth]

Hello,

I am setting up a dashboard/report for a manufacturing company I work for. Currently, I have slicers for Year, Quarter, Month, and Week which work great.

However, I am trying to gain the ability to see data matching all of these time periods by either 1st Shift, 2nd Shift, or a summed value of both. My source data for the shifts is organized into separate columns (i.e. "Downtime 1st Shift", "Downtime 2nd Shift", etc). The problem is I couldn't insert all 3 data fields into the visualization ("1st", "2nd", and "Summed") because I would effectively get 3 data points for each date. 

From my understanding, I would basically need 2 dashboards for this (one with shifts split and one for the summed totals) or I would need some sort of slicer/selector for the "Summed" values which would sum both individual shift data points and then display as a single data point when selected. 

Am I missing something as a new user or is this a feature that has not been implemented? Thanks for the help!!!

[itchyeyeballs · Accepted solution]

I probably wouldn't have a column for each shift, I'd have a single column for all shifts and then a second column to identify the shift_id

Would then just need a measure to sum and a slicer to filter down from overall total to which ever shift you wanted to show.

I would also then have a shifts lookup table which would be linked to shift_id to hold meta data about shift such as name etc. This approach would also future proof the system for when management decide to implement a third shift 😉

If you want to achieve this you can use the "unpivot" function (which is a brilliant feature for normalising datasets) to reduce multiple columns into 1.

[itchyeyeballs · Accepted solution]

I probably wouldn't have a column for each shift, I'd have a single column for all shifts and then a second column to identify the shift_id

Would then just need a measure to sum and a slicer to filter down from overall total to which ever shift you wanted to show.

I would also then have a shifts lookup table which would be linked to shift_id to hold meta data about shift such as name etc. This approach would also future proof the system for when management decide to implement a third shift 😉

If you want to achieve this you can use the "unpivot" function (which is a brilliant feature for normalising datasets) to reduce multiple columns into 1.

[tomdosfre]

Just as a side question, is it possible to keep slicers in dashboard or we can only use them in reports after clicking on Edit?

Thanks!

[cwayne758 · Accepted solution]

Only in reports