🤯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
@rwashington4552 жыл бұрын
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)
@LuiIacobellis2 жыл бұрын
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.
@LuiIacobellis17 күн бұрын
@moslim3024 You're very welcome! Thanks for watching!
@martinandwendydouglas39525 ай бұрын
Great video. I am a total novice and I was able to follow along. Super clear and concise.
@LuiIacobellis5 ай бұрын
Glad it was helpful!
@Grand1Simon9 ай бұрын
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!
@LuiIacobellis8 ай бұрын
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!
@JorgeEscobarMX2 жыл бұрын
Thank you. You saved me for tomorrows stand up meeting.
@LuiIacobellis2 жыл бұрын
You're very welcome! Glad I could help! Goodluck with your stand-up tomorrow.
@blockishcrow81912 жыл бұрын
Great video, so much good knowledge packed into 15 minutes. Thank you!
@LuiIacobellis2 жыл бұрын
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!
@dawnboden12308 ай бұрын
THANK YOU! Your videos are so helpful
@LuiIacobellis7 ай бұрын
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!
@karimlike19 ай бұрын
Thank you, superb!
@LuiIacobellis9 ай бұрын
Glad you liked it!
@BhanaD17 ай бұрын
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?
@LuiIacobellis7 ай бұрын
I will add these to my backlog! Thank you!
@BhanaD19 ай бұрын
Great easy to understand video. Could you do a video using the "Configure Function Field" please.
@LuiIacobellis9 ай бұрын
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!
@mauriciocatano74159 ай бұрын
Great video ! very helpful
@LuiIacobellis9 ай бұрын
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!
@music4sami8 ай бұрын
Kiitos!
@LuiIacobellis8 ай бұрын
Olet erittäin tervetullut, ja suuret kiitokset anteliaisuudestasi.
@vanillasugar41192 жыл бұрын
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!
@emmanuelemokpae94643 ай бұрын
How do I change the colour of a bar graph based on it's value in ServiceNow - Style.
@vignesh0046 ай бұрын
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-le9gy10 ай бұрын
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.
@LuiIacobellis10 ай бұрын
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.
@darlaklimm5467 ай бұрын
When would you use the data source for report source type?
@LuiIacobellis7 ай бұрын
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_Ananthula7 ай бұрын
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.
@abbasgodhrawala7 ай бұрын
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?
@LuiIacobellis7 ай бұрын
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!
@nevatobe2 жыл бұрын
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
@figarocalisthenics95162 жыл бұрын
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?
@LuiIacobellis2 жыл бұрын
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
@LuiIacobellis10 ай бұрын
Sorry for the delay. You would need to identify which table stores the task records and ensure you're querying that table.
@gangadharpavan10 ай бұрын
@@LuiIacobellis hey, not a problem.! was able to identify and create. thanks!
@Kwintessential210 ай бұрын
Are HRC tickets also incidents?
@LuiIacobellis10 ай бұрын
To the best of my knowledge, no they are stored on a seperate table (sn_hr_core_case).
@Kwintessential210 ай бұрын
@@LuiIacobellis thank you
@LuiIacobellis10 ай бұрын
@@Kwintessential2you are welcome
@dennisverduz62898 ай бұрын
☝☝👌👌
@LuiIacobellis8 ай бұрын
@dennisverduz6289 You're very welcome! Thanks for watching!