Applying a date range on a Pivot table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi! Is it possible to apply a date range filter on a pivot table data visualization?
I have a client that wants to be able to see weekly scores for one of their indicators on a pivot table, and then be able to use the date filter to see scores for whichever week of their choosing based on past scores. From all the research I have done, I have not found this to be possible since the pivot table is not a time series visualization, but I just wanted to confirm or find out if there is a way to.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
@AmberTemple, for this you will have to explore "Indicators", "Indicator Sources" and "Formula" etc in Performance Analytics. It could be possible since ServiceNow has added so many options to customize manual formula, it appears to be possible.
Here's a short video by ServiceNow which could give you some high level over view that might help you achieve what your client is looking for.
I would say give it a try before saying no. (You know the drill!!!)
https://www.youtube.com/watch?v=xpwLWlpv6AA
Regards,
Vikas K