K20 - LAB 1141 - Advanced Reporting - Q&A

[anna_scheib]

This article is for questions and answers for LAB1141 - Advanced Reporting. This lab is being presented multiple times throughout the live K20 event May 5 - 7, 2020. During the live event, post your questions in the comments of this article, and one of our lab gurus will be happy to answer it.

[RJ Barmentloo]

Hello and welcome all!

Great to have you all here for Advanced Reporting concepts. We hope you like it and have a great learning experience. Happy exercising! 

[Jill9]

 What happens when the file you are importing expires?

[olgaredkina]

The data in the report will be not available any more, data will be deleted from the instance. 

[Alex Althaus]

Jill - 

Once that timespan has elapsed, the data source will be set as expired and the report will no longer function.

There are ways to edit the expiration and this data import as detailed in this HI article:  https://hi.service-now.com/kb_view.do?sysparm_article=KB0722490

Let me know if this helps!

[Jill9]

I'm assuming this is to manage "static data", so that decisions are not made based on expired data?

[olgaredkina]

Yes, exactly. 

[shaik_irfan]

Hi, 

I added Advanced Reporting agenda to my topic but i am little confused with the time zone can anyone please help me on what time zone this is going  to start 

For me it shows as 11.30 PM

[Jill9]

I don't see the link icon when I wasn't to schedule a report. Does this have something to do with the browser? I'm using Chrome.

[Lisa Shuman]

Are you referring to the link you get when you publish a report? If you want to schedule a report you would need to select the share option.

[brad_foohey]

The link is available when you Publish a report.  

[april_mcgehee]

@shaik.irfan It's displayed in your own timezone!

-April

[Lisa Shuman]

Once you publish you will get a link icon to the left of the i with the circle around it icon.

[Jill9]

With Orlando, will we still have to share each individual report before we can share a dashboard displaying those reports?

[Lisa Shuman]

Once you publish you will get a link icon to the left of the i with the circle around it icon.

[Alex Althaus]

Shaik, 

Can you give me more details on what day this was scheduled for?  We are running multiple sessions of this lab during Knowledge, and I want to be able to guide you appropriately!

Thank you!

[brad_foohey]

No, you will be able to share the Dashboard (no changes with Orlando).  

[brad_foohey]

Dashboard sharing hasn't changed in Orlando.

[shaik_irfan]

On my agenda tab it shows as May 6 at 11.30 PM to 1.10 am 

I am from india is it for my time zone right

[olgaredkina]

You still need to share reports in Orlando to make sure users can see it on a dashboard.

[Lisa Shuman]

Yes that would be correct, you should be seeing the session times in your time zone.

[Jill9]

Aaaaaah ok thanks guys, I missed that step.

[Jill9]

Thank you, and still no way of changing the permissions on multiple reports at one time?

[olgaredkina]

Not yet, but we really hope it will come soon. Working on it.

[Erin Dabbs]

Welcome to Advanced Reporting! We want to get to know you! Tell us your name, location and how long you have been using ServiceNow.

[T Pappu]

Will we cover how to create reports using maps or google maps?

[mortenkschoeler]

Hi

Morten here, from Denmark. We have been using ServiceNow for almost 4 years now, and try to benefit the reporting possibilities from our platform.

I'm very excited about this lab session.

[Erin Dabbs]

That's great, Morten! We are happy to have you in the session today!

[Lisa Shuman]

We do have an exercise where we create a report using a map.

[Suzanne Smith]

The lab titled Building a Powerful and Interactive Dashboard contains a neat section on using maps!

[padma13]

is there any way to archive a Dashabord or Reports?

[Aileen Wade]

What is the best way to determine the table a field is on when in a form? Sometimes I have had issues finding the table a field is on when trying to write a report.

[Suzanne Smith]

It's not exactly archiving, but you can export a responsive dashboard. For details see: https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/performance-...

[Adam Stout]

For dashboards, I would just set it to inactive.  You can unload it to an update set to keep a backup (like I was moving it to a new instance), but generally, we just leave them and remove sharing and mark it as not active.

[Ketan Shah]

What is the difference between Data Source & Table, when you're choosing on where to pull the data for the report?

[sarasanderson]

You've saved the conditions on which you want to filter the table.  If you choose a table, you will always have to re-set the filter conditions.

[Adam Stout]

Most often, you are only seeing the fields on the table you are viewing.  Are you asking about fields on dot-walked tables that are displayed on the form?

[jeffrey fasher]

also, you can develop the reports on a update set and then export them out as a XML file, this means you can import them into another instance at anytime

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/performance-...

[jeffrey fasher]

also, you can develop the reports on a update set and then export them out as a XML file, this means you can import them into another instance at anytime

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/performance-...

[Adam Stout]

With a data source, you can give the table and conditions a much more meaningful name which often results in better user experiences.  It also allows you to make changes to conditions in one place instead of in each report.  There is no performance difference.

[Jean-Pierre Per]

Doesn't seem like you will ne narrating your steps?

[jeffrey fasher]

dot walking will allow you to see fields in other related tables, you should also consider created database views, they will enable you to access fields from multiple tables (think of it as a large virtual table)

https://docs.servicenow.com/bundle/orlando-platform-administration/page/use/reporting/concept/c_Data...

[Erich Zirnhelt]

To augment Adam's point, it's a great way to centralize and share common and possibly complex conditions, especially when you have many self-serve report writers.

[jeffrey fasher]

also, you can develop the reports on a update set and then export them out as a XML file, this means you can import them into another instance at anytime

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/performance-...

[jeffrey fasher]

full lab instructions are here

https://developer.servicenow.com/connect.do#!/event/knowledge2020/LAB1141

there will be lab simulators after K20 you can use to practise on as well, that will work for this lab 

[Brenda Doonan]

will that show history of incidents assigned to different teams?

[Adam Stout]

A duration metric on assignment group will but if this is what you are looking for specifically, I recommend looking at SLA Breakdowns which shows the history and their contribution to SLAs.  https://docs.servicenow.com/bundle/orlando-it-service-management/page/product/service-level-manageme...

[sarasanderson]

Hi Brenda: it shows the history in so far as how long an incident remains assigned to a group

[sarasanderson]

Hi all: we got a question about ITSM metrics.  Here are a couple of links that you might find useful:

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/performance-...

https://docs.servicenow.com/bundle/orlando-it-service-management/page/product/incident-management/co...

[John Felini]

Hi - I would like to attend the the next session in 30 minutes, but I cannot register.  I have it favorited, but it says the session is full.  If there is space, could someone please send me the zoom link?  Thank you.

[Lisa Shuman]

Hi John, I see you were able to join the session.  Great to have you here.