Applying a date range on a Pivot table

AmberTemple
Tera Guru

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.

1 REPLY 1

VikMach
Mega Sage

@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

Explains the different types of indicators that you can create for Performance Analytics in the ServiceNow platform, and demonstrates the process for creating manual, automated, and formula indicators. This video covers: 00:00 Intro 00:40 What are indicators? 02:14 Types of indicators 06:02 ...