Forum Discussion

jdanney's avatar
jdanney
Frequent Visitor
3 years ago

Build a bar chart using unpivot data.

Hello all, 

I have made a visual bar chart that is displaying faults found. I have had to unpivot a table to get the columns to populate along the bottom, as the data direct from ecxel wasnt displaying in seperate columns. I'd like to put a slicer in to filter by year and Quarter, however I only have value and attribute in the fields to drag in. is there a way to do this?

 

I have included the data in the table below but that is from the pivoted table (I do not undertsand how i can get the data below to display as in the picture with out unpivot OR add a date slicer to an unpivoted table)

 

your help is very much apprichiated 

 

 

IDStart timeend timeemailWhich checks are you completing?are there any open documents?Checking 3 personnel in work today, are all of their Mandatory competencies in date?Checking 5 personnel, in total, across shift and support, have they had their appraisal completed?documentation to be checked for accuracy. Are both compliant?Have duty crews been assigned for this week and the following week?Has the Mandatory Training board been updated during the previous month? Is the notice boards in the T-Bar up to date?Is the Social notice board in the T-Bar up to date?
4716/11/2022 07:2716/11/2022 07:27anonymousPersonnel weeklyNoYesYesNoYesYesYesYes
4717/11/2022 20:0617/11/2022 20:06anonymousPersonnel weeklyNoYesYesNoNoN/ANoNo
4823/11/2022 12:0423/11/2022 12:04anonymousPersonnel weeklyNoYesYesyesYesN/AYesYes
4901/12/2022 21:3501/12/2022 21:35anonymousPersonnel weeklyNoNoYesNoNoN/ANoNo
5006/12/2022 07:5806/12/2022 07:58anonymousPersonnel weeklyNoNoYesYesYesNoYesYes
5112/12/2022 15:0012/12/2022 15:00anonymousPersonnel weeklyNoYesYesYesYesN/AYesYes
211/01/2023 13:3611/01/2023 13:36anonymousPersonnel weeklynoNoYesyesYesYesYesYes
318/01/2023 10:4018/01/2023 10:40anonymousPersonnel weeklyNoYesYesYesYesN/AYesYes
No RepliesBe the first to reply