Dashboard - Bar chart

Itay Goldshtein
Tera Contributor

Hello,

I created a widget on Dashboard that shows a bar chart, that displays the open calls by time. the problem that I don't see where i can present it 'week by week' at the last 8 week. like in the following example: 

ItayGoldshtein_0-1672208396261.png

I succeeded only to preset this figure: 

 

ItayGoldshtein_1-1672208522594.pngItayGoldshtein_2-1672208560320.png

In addition, i don't find how to add a horizontal 'goal line'.

can you please help me?

2 ACCEPTED SOLUTIONS

jaheerhattiwale
Mega Sage
Mega Sage

@Itay Goldshtein 

Go to "Reports > Administration > Report Ranges"

jaheerhattiwale_0-1672210063376.png

 

Create new "Report Range" for your table and Opened field

jaheerhattiwale_1-1672210191807.png

 

 

You need to created multiple report ranges

 

Please check below snow link as well:

https://docs.servicenow.com/en-US/bundle/tokyo-now-intelligence/page/use/reporting/concept/c_ReportR...

 

Please mark as correct answer if this solves your issue.

Please mark the answer as correct or helpful based on impact
ServiceNow Community Rising Star, Class of 2023

View solution in original post

@Itay Goldshtein Yes you need to insert upper value itself. Week 1 upper value will be min value for Week 2. Please check the global ranges created as shown in image beow

jaheerhattiwale_0-1672217823174.png

 

In the image above

"Same day" upper value duration is "23 Hours 59 Minutes"

"2 Days" upper value duration is "1 Day 23 Hours 59 Minutes"

 

It means "2 days" lower value duration is "23 Hours 59 Minutes" and upper value duration is "1 Day 23 Hours 59 Minutes"

 

Please mark as correct answer if this solves your issue.

Please mark the answer as correct or helpful based on impact
ServiceNow Community Rising Star, Class of 2023

View solution in original post

24 REPLIES 24

@Itay Goldshtein Week 1 is al left and week 8 is at right only. What's reversed?

Please mark the answer as correct or helpful based on impact
ServiceNow Community Rising Star, Class of 2023

"week 1" is the last 7 days, i.e. the most recent. That's why I want it to be at the right side

@Itay Goldshtein Ok. We have Order field on report ranges table. Change the order to how you want it. It should work.

jaheerhattiwale_0-1672221458575.png

 

Please mark all the answers on this question as correct answers

Please mark the answer as correct or helpful based on impact
ServiceNow Community Rising Star, Class of 2023

I performed it but unfortunately nothing changed.

ItayGoldshtein_0-1672222599733.png

 

@Itay Goldshtein For all you have added 100. You must add small number if it need to be at left and a big number if it needs to be at right. like below

jaheerhattiwale_0-1672222900775.png

 

"> 2 Months"  with order 80 will be at right

"Same day" with order 10 will be at left.

 

Please mark all the answers on this question as correct answers

Please mark the answer as correct or helpful based on impact
ServiceNow Community Rising Star, Class of 2023