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

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

Thank you,

The problem is that I only have "upper value duration" and it missing the min value' for "week 2...+...week 8"

ItayGoldshtein_0-1672216933796.png

 

@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

Thank you very much,
It helped me a lot, but there is still a problem, it presented me the timeline in the opposite way: from right to left instead of left to right.

ItayGoldshtein_0-1672220468871.png