Pivot table by Report ranges for a date field

ayman_h
Kilo Sage
Kilo Sage

‎04-04-2019 05:18 AM

Hi,

Are you able to create a Pivot Table report by Report range for eg. the Updated field? Currently, if I add the Updated field as a column, it will show the complete date/time value.

I am aware the report ranges for a date field does work fine if you create a Bar chart and group it by the Updated field (see image below). I was wondering how can I apply the same behaviour for a Pivot table?

find_real_file.png

Labels:
Preview file
60 KB
0 Helpfuls
  • 1,251 Views
1 REPLY 1

Tim Deniston
Mega Sage
Mega Sage

‎04-04-2019 05:58 AM

ServiceNow's Product Docs site says that report ranges can only be used in bar and pie charts: https://docs.servicenow.com/bundle/madrid-performance-analytics-and-reporting/page/use/reporting/con...