How To Create a Report in ServiceNow

[@LuiIacobellis]

🤯Do you want bite sized ServiceNow tips and tricks delivered to your inbox?🤯 If so, check out my ServiceNow 🗞newsletter🗞No BS, just to the point actionable insights you can use to be more productivity. Check out previous editions and subscribe here: academy.luigiiacobellis.com/newsletters/servicenow-savvy CHECK OUT MY HOW TO USE SERVICENOW PLAYLIST: kzbin.info/aero/PLmE7KGV9-I4tHVS_L-AqnKBPDOJ64zfuL

[@vm9778]

15 minutes well spent. Clear steps and example. Your style of tutoring and presentation is spot on. I need to upskill some junior members of the team and your videos are perfect. Thank you Lui

[@rwashington455]

Man, I can give you a Big Hug all the way from DC just to say thank you for making this an easy, quick, understandable, not boring lesson. Thank you! Great Presenter you are, thanks again! (Smiles)

[@LuiIacobellis]

Comments like these are incredibly rewarding for me as a creator, so thank you so much for the kind words. I'm glad you found this video helpful and thank you for watching!

[@moslim3024]

If simplify was a person! This sooooo good. Your mode of tutoring is too good. Thank you and God bless.

[@LuiIacobellis]

@moslim3024 You're very welcome! Thanks for watching!

[@martinandwendydouglas3952]

Great video. I am a total novice and I was able to follow along. Super clear and concise.

[@LuiIacobellis]

Glad it was helpful!

[@Grand1Simon]

Hello sir. Just want to thank you for the step by step explanation. I'm from Québec, Canada, started a new job at the beginning of this month and clueless before ServiceNow. Your method is helping me a LOT!

[@LuiIacobellis]

You are very welcome! Congratulations on your new job. Thank you for watching!

[@simonhogg5910]

This compliments the dashboard tutorial very well. After faffing about with reports, one thing (of many) which was obvious now I know, 'ctrl+click' in the condition builder to select more than one. This is far better than RTFM'ing ;-)

[@LuiIacobellis]

I'm glad you found this one helpful also Simon! Yes, the "CTRL + CLICK" is a nice little shortcut! Thanks so much for the comment and for watching!

[@JorgeEscobarMX]

Thank you. You saved me for tomorrows stand up meeting.

[@LuiIacobellis]

You're very welcome! Glad I could help! Goodluck with your stand-up tomorrow.

[@blockishcrow8191]

Great video, so much good knowledge packed into 15 minutes. Thank you!

[@LuiIacobellis]

Thank you for the kind words! I'm glad you found this video helpful! Thanks for watching!

[@constancedansby3267]

Thank you. Great job.

[@LuiIacobellis]

You're very welcome and thanks for watching Constance!

[@dawnboden1230]

THANK YOU! Your videos are so helpful

[@LuiIacobellis]

Glad you like them!

[@CharmingBl4zer]

Great video, thank you !

[@LuiIacobellis]

You're very welcome and thanks for watching

[@playerone1194]

This video helped me at work! Amazing help.

[@LuiIacobellis]

I'm glad you found this helpful Player One! Thanks for watching!

[@geltjejorquin933]

Hi man!! Thank you so much for making this one easy and very understandable. ❤

[@LuiIacobellis]

You're very welcome! Glad you found it helpful! Thanks for watching!

[@karimlike1]

Thank you, superb!

[@LuiIacobellis]

Glad you liked it!

[@BhanaD1]

Great Video, you're a genius at explaining things in a way that is easy to understand. Do you have any further videos in the pipeline for ServiceNow ? For example, reports on creating SLA reports?

[@LuiIacobellis]

I will add these to my backlog! Thank you!

[@BhanaD1]

Great easy to understand video. Could you do a video using the "Configure Function Field" please.

[@LuiIacobellis]

Thank you! Can you provide additional information on your use-case for configuring a function field? This will help me in planning a video. Thank you kindly!

[@mauriciocatano7415]

Great video ! very helpful

[@LuiIacobellis]

Glad it was helpful!

[@dah7143]

Excellent! Great content! Great delivery!

[@LuiIacobellis]

Thanks for the kind words and Thanks for watching!

[@sunmadeagboke9647]

I'm awed right now how effective and seamless you made this video!!! quick question how can I apply the same method for assignment groups that have been task starved on/over 12 months ? Thank you

[@LuiIacobellis]

Thank you for the kind words. I'd suggest that you post your question over on the ServiceNow Community. It is likely someone has asked this question and if not, someone will have suggestions on how to solution for it - www.servicenow.com/community/ - Hope this helps!

[@sriharshasurenahalli6455]

simply superb :)

[@LuiIacobellis]

Thank you for the comment and for watching!

[@music4sami]

Kiitos!

[@LuiIacobellis]

Olet erittäin tervetullut, ja suuret kiitokset anteliaisuudestasi.

[@vanillasugar4119]

This was very helpful I have created a report for closed tickets by month for the past year. But now I want to break it down further to show the tickets closed with 1 week , 2 weeks etc. How can I do this?

[@LuiIacobellis]

Hi there, sorry for the delay. I came across this post on the ServiceNow community which I believe addresses your question: www.servicenow.com/community/in-other-news/servicenow-reporting-use-report-ranges-for-advanced-grouping/ba-p/2276059 - Hope this helps and thanks for watching!

[@emmanuelemokpae9464]

How do I change the colour of a bar graph based on it's value in ServiceNow - Style.

[@vignesh004]

how to filter the ctask which is closed after the planned end date in servicenow (CTASK breach)

[@yaka2]

Tanks for this tutorial. Is it possible to have in the same report, the approval users name & date, and Ritm with variables ?

[@LuiIacobellis]

If you have permission to read Data in ServiceNow then you can generate a report against it! Hope this helps and thanks for watching

[@Hellokitty-le9gy]

Thanks! that is helpful, but can I ask how to create a report for specific user? for example, I want all request tickets for company ABC , what condition should I input pls? I tired filter company contains ' ABC' on report but the result is empty.

[@LuiIacobellis]

You would need to use the field in your ServiceNow instance that identifies the company. You would set that field to equals and select the company. If it is a free text field then you could use contains but you would need to ensure you capture all permutations of the company name.

[@darlaklimm546]

When would you use the data source for report source type?

[@LuiIacobellis]

Report sources in ServiceNow are pre-defined data sets for creating reports. They streamline the report creation process by allowing the reuse of conditions, ensuring consistency across reports within an organization. A report source comprises a table and specific conditions, offering a convenient way to implement consistent definitions.

[@andrewm2147]

Lui, the company I work for is looking at ServiceNow, the reporting you are showing in the video, is that the basic reporting that comes with ServiceNow or the Advanced reporting module? Thanks!

[@LuiIacobellis]

Hi Andrew, the reporting I demonstrate in this video is the out of the box standard reporting functionality. Hope this helps and thanks for watching

[@prasannapitchu8043]

Hi, I want to create service now report for tickets we have escalated from our queue particularly on yesterday. Is there way to pull report on escalated by days

[@LuiIacobellis]

Hi there, when you say escalated do you mean you want to see a report of incidents that were created most recently? If so, you can create an incident report and add a sort condition to sort by created date. If you want to see a report of only those incidents created yesterday or assigned to your queue yesterday then you can add a filter to show only those incidents where assigned to is your group and updated is yesterday. When you build filters on date fields you'll have the option to select yesterday from a list of conditions. Hope this helps and thanks for watching

[@Anita_Ananthula]

Hi folks, Can anyone help me on following query. I have created custom field name “time worked” , assigned to mentioned how much time he spend on incident to resolved. I need to create report to calculate total all time spent per month each person in assignment group is level 2 . Please can anyone help me, that would be appreciated.Thanks you in advance.

[@abbasgodhrawala]

Where are you creating this dashboard? I mean what is the name of the tool and how I can I get access to this tool for learning purpose?

[@LuiIacobellis]

This dashboard is created in ServiceNow directly. No additional tool!

[@shafiqashahirol9508]

can we create a report to calculate time taken to resolve tickets in ServiceNow?

[@LuiIacobellis]

Yes, this is possible and if you have Service Level Agreements setup in your ServiceNow instance, you should be able to access pre-built reports to get this information. Hope this helps!

[@user-oy6el3pt4r]

Can we add incident aging in report from creation date to report date?

[@LuiIacobellis]

Hi there, you could create an incident aging report for sure. If you want to calculate the delta between two dates, you may need to create some custom fields and use scripts to handle the calculation. Hope this helps!

[@Zaites]

Hi, I still can't find a easy way instead of showing count of tickets, show only the %, is this available only in analytics?

[@LuiIacobellis]

Hi there, it sounds like you might to add a group by condition to your report in order to see the count of tickets. Hope this helps and thanks for watching

[@babayaga6264]

Hi, after creating a report of the type list I couldn't find a way to export that report into Excel file. Could you please help with this. PS. Got the solution, just right click on the column. Thanks anyway.

[@LuiIacobellis]

Sorry for the delay! I am glad you managed to figure it out. Thanks for watching!

[@nevatobe]

When you create a report, how can you extract to an excel sheet? There's no hamburger button or 3 lines to select on the report to extract.

[@LuiIacobellis]

Your export options are entirely dependent on the type of report. If the report is a list you should see the hamburger menu and will be able to export it to Spreadsheet format. If the report is a visualization such as a bar chart, line chart etc. You will not be abke to export it to excel but rather pdf or png. Hope this helps and thanks for watching

[@Teaotters]

How can we turn our report into one that we would be able to break it down into spreadsheet willing? I might have to just watch the video again without distraction 😅 Thank you!!

[@Teaotters]

Nvm found it! 😁

[@LuiIacobellis]

Sorry for the delay and glad you figured this out! Thanks for watching

[@adinarusu2562]

Any idea what am I doing wrong for not managing to have the table reflected afler selecting It în the data step?

[@LuiIacobellis]

Hi there sorry for the delay. If you're able to select the table and it's not displaying data then there may be access controls that restrict you form viewing the data. Hope this helps and thanks for watching

[@figarocalisthenics9516]

If I have a list where the first column is a combination of numbers and letters, like for instance CS12344 and other that start with SR12345 and maybe other types, is it possible to make graph in showing the different types of numbers sorted by the first two letters so that i can see how many I have of each?

[@LuiIacobellis]

Hi there, I believe this would be possible but might require the use of derived variables and/or formulas. I'd suggest posting the use case on the ServiceNow forums as it is likely someone has a solution handy. Hope this helps & thanks for watching!

[@subhrantapanda]

how to build a report, in One line (not a bar line )for all closed and another line for all open tickets from last 7 days/weeks

[@LuiIacobellis]

Hi Bitesof, I'm don't fully understand your requirements however, it would be good for you to post this question over on the ServiceNow community with additional detail. That can be accessed at: www.servicenow.com/community/ - Hope this helps!

[@subhrantapanda]

@@LuiIacobellis i got the answer and i have created the report.

[@velezgeovanny4189]

How can I remove the time from date on a pivot table

[@LuiIacobellis]

Hi there sorry for the delay. Unfortunately I have never done this before. I'd suggest posting it on the ServiceNow community. Hope this helps and thanks for watching

[@gangadharpavan]

how to do the same for release tasks ? RLS

[@LuiIacobellis]

Sorry for the delay. You would need to identify which table stores the task records and ensure you're querying that table.

[@gangadharpavan]

@@LuiIacobellis hey, not a problem.! was able to identify and create. thanks!

[@Kwintessential2]

Are HRC tickets also incidents?

[@LuiIacobellis]

To the best of my knowledge, no they are stored on a seperate table (sn_hr_core_case).

[@Kwintessential2]

@@LuiIacobellis thank you

[@LuiIacobellis]

​@@Kwintessential2you are welcome

[@dennisverduz6289]

☝☝👌👌

[@LuiIacobellis]

@dennisverduz6289 You're very welcome! Thanks for watching!