Dashboard - Bar chart

[Itay Goldshtein]

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: 

I succeeded only to preset this figure: 

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

can you please help me?

[jaheerhattiwale · Accepted solution]

@Itay Goldshtein 

Go to "Reports > Administration > Report Ranges"

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

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.

[Itay Goldshtein]

I did that, but nothing happened.

[jaheerhattiwale]

@Itay Goldshtein As "week 1" have 10 its visible at left. Make order of "Week 1" 80. and "Week 8" 10.

Basically reverse the orders.

Less order will be at left and higher order will be at right.

Please mark all the answers on this question as correct answers

[Itay Goldshtein]

Here I did:  "week 1"=order 80..."week 8"=order 10... and still nothing chaneged

[Itay Goldshtein]

Here I did:  "week 1"=order 80..."week 8"=order 10... and still nothing changed

[jaheerhattiwale]

@Itay Goldshtein Let me check and come back here.