Counting by the Day of the Week in a Pivot Table
Hello:
I am attempting to count incidents by the day of the week across a month. I am hoping for:
MON TUE WED THU FRI SAT SUN
Shift A 3 6 2 5 11 8 7
Shift B 2 8 x x x x x
Shift C and so forth.
Here is what I have so far, but I can't figure out how to tell SiSense to count only by one of the 7 days of the week and not duplicate the day of the week as pictured here:
Any help is greatly appreciated!
Darin Inda
Hi dinda156,
Did you mean that the data model is a live model, or that you do not have access to the model? Do you have access to the Data tab (like shown below) at all?
The solution to your question requires changes to the data model (regardless of the model type, elasticube or live), so to achieve this, you'll need edit access to the model. Otherwise, you'll need to ask the data designer of the model to make the changes on your behalf.