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.

[lauro_garcia]

What's the maximum rows for an excel external data source?

[Suzanne Smith]

You can import up to 50,000 rows, but only the first 10,000 will be in the data set. For details, check out this page:  https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/reporting/ta...

[Marco Jansen]

Can you build a report with more than two datasets as input?

[Suzanne Smith]

Yes, just be sure to select a report type that supports multiple datasets. For details, check out https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/reporting/ta...

[Marc Cerli]

Hi Marco. 

Yes you can, please follow the instruction here:

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

[John Felini]

What is the difference between Interactive Filters and Dashboard Properties -> Breakdown Source?

[John Felini]

Could you use Report Ranges for the question regarding the metric axis?  Use the ranges to bin so you are not getting the axis with Hr, Min and Sec?

[anna_scheib]

John, Interactive Filters work on reports by default and not on PA widgets. 
The Breakdown Sources are specifically designed to work on PA widgets. They can also be configured to behave as Interactive Filters and filter reports.

[anna_scheib]

So the Ranges will not affect the unit shown on the Axis. You'll just be grouping the data for a cleaner look. 

[Adam Stout]

If you need more than that, use a standard import set.  This process is intended to help load data quickly and get something up and running but it does not replace the full integration process which allows you to set normal ACLs, removes these data limits, and allows you to use references.

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/import-sets/refer...

[Suzanne Smith]

Welcome to all joining the Friday, May 8th Advanced Reporting Lab. Glad to have you here!

Here are important links for the class:

• Student Instance Registration link: https://clabs.link/lab1141-581
• Student Instance Name/Password: admin/lab1141-886#K20
• Lab Guide: https://tinyurl.com/k20-lab1141-guide

[Phil Hunt]

is there a way to show the latest comments on top?

[Suzanne Smith]

No, unfortunately we can't show the latest comments at the top 😞

[Lener Pacania1]

Hi Phil, as Suzanne mentioned there isn't.  However, the silver lining is that you can see some of the other questions asked in previous classes.

[Adam Stout]

But they should be getting automatically added at the bottom with real-time updates.

[Lener Pacania1]

PDFs of exercises 1 & 2

[Lener Pacania1]

Direct links to each section of the lab

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


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


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


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



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



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


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

[debsatka]

Is there a way to display the Duration in an abbreviated form? I.e., instead of 1 hour 45 minutes 20 seconds...show 1hr 45min 20sec...or 1:45:20

If it's not possible...do you think it will be possible with future releases?

It may seem like an insignificant ask...but management in my company keeps requesting I change it...to the point that they would like me to use Excel or PowerBI so I can modify the labels/axis titles.

[gavinsn]

Exercises 3 and 4 

[Adam Stout]

You cannot control this today, but please add that request into the Idea Portal to ensure it makes it back to our Product Managers.

[gavinsn]

Here is the Excel file needed for the external import

[debsatka]

How do I get to the Idea Portal? Do you have the link? Thanks!

[Phil Hunt]

How long will on demand labs be available with instances? Do we need to make sure and do them this week or during the 5 weeks of knowledge or?

I'd like to have some of my teammates do this lab on demand.

[Adam Stout]

They will be available until K21.  There are also additional labs that will be available with instances to work on as well.  The instances themselves will expire, but you can always request a new one.

[Erik Johnson]

Labs will expire approximately 30 minutes after the lab concludes.  The lab guide will continue to be available and the lab should be able to be run on a PDI.

[Erik Johnson]

Your current lab instance will expire approximately 30 minutes after the conclusion of the lab.

[Josh Bright]

How do we get the deck from the lab?

[David A_ Haught]

need some reference info around tables, metrics, data sets, data source, table, ...  (Shared from Kevin on chat) - but I wanted to second his request.

[David A_ Haught]

Agreed - My management is always asking about the weird numbers......I tell them they are 1 million second increments.....  Please allow the user to change......

[Suzanne Smith]

Hi Josh, the deck should be posted in the ServiceNow Community in a week or so.

[Suzanne Smith]

Hi David,

Complete reference materials are available on the ServiceNow product documentation site at https://docs.servicenow.com/. When you visit the site, be sure to filter the information for the release you have, say, New York or Orlando, to ensure you get the best results.

Also, check out all the available resources here in the Community. There are lots of conversations about Reporting and Performance Analytics. Do visit the Reporting and Analytics Forum as well:

https://community.servicenow.com/community?id=community_forum&sys_id=b5291a2ddbd897c068c1fb651f9619e...

I hope that helps!

Thank you for attending the lab today.

Suzanne

[santoshkomerave]

@anna.scheib : Kindly help on this.

Hello Team,

I would like to access the content which I have done for the lab LAB1141. I have attended this LAB on 05/08 from Knowledge 2020. I was building reports and suddenly access got revoked. Can I get the access back for some time so that I would like to recommend to my business for PA. I was in the middle of some work in this instance and suddenly I have lost access. It would be much appreciated.

I have registered with the same email which i am posting this comment from, you can retrieve my email and provide me access for the time being. I would like to access the data which I was trying to build and do some recommendations. Kindly help on this.

It was really a great session.

Thanks,

Santosh