Report Builder Pivot Table Option

  • 1
  • Question
  • Updated 7 months ago
I am trying to create a pivot table on a report I have built in the Report Builder. The pivot is needed to display the data in a form that is actionable for our CSMs. Basically, just showing the clients usage behavior on each metric we measure and the date of the last time a user utilized that feature in our platform.

However, I noticed that when I apply the pivot on either the User's name or the Usage Event, the date field converts from a Date to a String. So, if the original value was "3/26/17", after the pivot, this is marked as "2,017". So, it drops the day and month, and to me it looks like it's a string field due to the comma. 

Just wanted to post this to see if this was expected behavior or if there was a workaround this issue? Thanks!
Photo of Manmeet Dosanjh

Manmeet Dosanjh, Champion

  • 3,932 Points 3k badge 2x thumb

Posted 7 months ago

  • 1
Photo of Dan Ahrens

Dan Ahrens, Official Rep

  • 24,896 Points 20k badge 2x thumb
Hi Manmeet, are you using Excel or Google Sheets (or something else) to do your pivot? Is the export file in CSV or XLS format?
Photo of Manmeet Dosanjh

Manmeet Dosanjh, Champion

  • 3,932 Points 3k badge 2x thumb
Hi Dan,

I was just using the "Apply Pivot" option in the Report Builder. Screenshot below:




I haven't used this option before on Pivot tables, so I was just seeing if this was something that would work for my use case.