Help in report

[Shpilmaa]

Hi!

can i visualize a report in bars for how many work order opened in a day? 

for 1 week? for example:

Sunday - 5

Monday - 10

ETC'

thanks 

[Dr Atul G- LNG]

Hi @Shpilmaa 

Try Stack by if that work . I wil give a try for this in morning.

[Dr Atul G- LNG]

Hi @Shpilmaa 

I tried this with Bars, but stack by did not accept the date field , either you can do additional group by, but that will not give you the expected output you need. 

Check this OOTB report

https://INSTANCENAME.service-now.com/now/nav/ui/classic/params/target/sys_report_template.do%3Fjvar_report_id%3D66fa9561df23210068c37a0d3df26367

[AndersBGS]

Hi @Shpilmaa ,

Off course, please follow below guide:

1. Create the report based on the work order (wm_order) table:

2. Chose time series column:

3. Trend by "created" and chose per day

The output will be:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders