How can you show all Dates for bar chart?

Nilan1
Mega Expert

I want to show the hours worked for the last x days.  Instead I get this in Servicenow:

find_real_file.png

 

I want to show the data for each day:

find_real_file.png

How can I do that?

I am using Group by, 'Created' in the bar chart.

1 ACCEPTED SOLUTION

Kushagra Mehrot
Kilo Guru

find_real_file.png

 

 

try this too !

View solution in original post

5 REPLIES 5

Kushagra Mehrot
Kilo Guru

Did you tried using report type  as Pivot table instead of bar chart ?

Select row and column to business duration and created.

Kushagra Mehrot
Kilo Guru

find_real_file.png

 

 

try this too !

I wasn't sure if you were suggesting 'trend' report.  I used that and it provided me what I was looking for.  

Thanks.

Nilan1
Mega Expert

I used the report type as 'trend' and then chose 'Trend by' Created.

I used a filter for the last 7 days.

Very important to use per Date (not Day)