CODEWITHSUNDEEP
pivotpivot-tablelooker
Mike - SMT
Mike - SMT

Reputation: 15226

Looker date pivot is not working as expected

I am having an issue with pivots by date. When I try to add a pivot by date it ends up stacking month over month.

All the percentages are correct for each month showing and they line up with the correct names but for some reason its stacking.

I did try to remove the date from the table and then add it as a pivot but for some reason I get this odd stacking behavior.

enter image description here

I suspect it might be due to the way the custom measures work since I have not seen this happen with a normal measure before.

enter image description here

See example:

enter image description here

Upvotes: 0

Views: 1226

Answers (1)

Mike - SMT
Mike - SMT

Reputation: 15226

Turns out the solution was to change the data in the view from a dimension to a measure and to change the type from a number to a sum.

After doing this to both fields I am using for creating the percentage it corrected the way the pivot was displayed.

enter image description here

Results:

enter image description here

Upvotes: 0

Related Questions