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]

Thank you very much for your patience Jaheerabbas, I await your reply

[Itay Goldshtein]

Thank you very much for your patience, I await your reply

[Itay Goldshtein]

Thank you very much for your patience, I will wait for your reply

[jaheerhattiwale]

@Itay Goldshtein I think there is no way to do this as its sorting based on "Upper value duration" field.

I think its OOTB behavior to keep the label with less "Upper value duration" to left.

You can raise a HI ticket to check this with servicenow as they have provided order field in report ranges but that is not working.

Can you please mark other answers on this question as correct answers. That will hep others to find solution regarding report ranges.

Thanks

[Itay Goldshtein]

Thank you very much, I will raise HI ticket and hopefully it will get me to the solution. I marked the replays as Helpful.