Question
Report Builder Pivot Table Option
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]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!
However, I noticed that when [i]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!