Count the total days worked per agent using pivot
I already have a pivot widget where in rows there is the name of the agent and in columns is the month in a year (Jan-Dec). I want to show in the values side the total number of worked days in each agent but I can't do it with (SUM(Count(Days in timestamp)). Is there other way to have this result?
-
Hi,
Perhaps what you wanna do is multi-pass aggregation. In that case, the formula should follow this pattern:
SecondAggregation(Dimension, FirstAggregation(Measure))
So in your example, it should look like this:
SUM(Month, COUNT(Days in timestamp))
-
Hi Master Yoda,
Shouldn't a simple COUNT(Days in timestamp) work?
I just read your question again and looks like there isn't any need for multi-pass aggregation.
When you add count of days as the value, each cell should show the count of days for each employee in each month.
Let me know if I'm understanding correctly.
Please sign in to leave a comment.
Comments
4 comments