Change date format for charts

michaeldaughety
Kilo Contributor

‎02-08-2016 06:29 AM

I would like to change the date format from <Day of Week>/Year to MM/DD/YYYY.   Where do I go to do this?   I have looked through the forums but the search terms are too common.   Any help would be appreciated.   Below is a stacked bar chart where I highlighted the format that I want to change in red.

The problem i have is the day order appears to be set so the Sunday at the beginning may actually belong at the end.

find_real_file.png

Thanks,

Michael

Labels:
Preview file
9 KB
0 Helpfuls
  • 1,968 Views
1 REPLY 1

benedetto
ServiceNow Employee
ServiceNow Employee

‎02-09-2016 01:35 AM

Hi Michael,



the screenshot in your message is displaying a Trend per Day report. That configuration is meant to compare data between day of week across a year, not across months. Data is aggregated per Day of Week, per Year.


If you change the report configuration to Trend per Date you will then get aggregation per date that seems to be what you are looking for.



Best Regards,


Benedetto


0 Helpfuls