EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

Platform Analytics - splitting number of report executions into coming from report author and from all the other users.


Robert Prochowicz

Manager, Sales Engineering • MicroStrategy


Platform Analytics contains a set of dashboards presenting statistics data like number of report/dossier executions. Those dashboards (dossiers) can be further enhanced, for example by splitting number of report executions between report author and all the other users. If the author is heavily developing and testing his report the statistics can be inflated and deliver a wrong picture. In this example I will show how to improve those numbers.

Example result:

ka02R000000btTRQAY_0EM2R0000019dGj.jpeg

Open this dossier:
Platform Analytics > Shared Reports > 1. Dossiers > Object Telemetry
 
Modify metric ‘Executions’:
Metric options

ka02R000000btTRQAY_0EM2R0000019dHD.jpeg

 
Create metric ‘Executions (no-owner)’
Formula:
Count<Distinct=True, MetricID=[Execution Duration (ms)]>(Action@ID){~+}
Add a filter to metric definition (if IDs don't match used Names):

ka02R000000btTRQAY_0EM2R0000019dHc.jpeg

Add NullToZero() function to the formula
NullToZero(Count<Distinct=True, UseLookupForAttributes=False, MetricID=[Execution Duration (ms)]>(Action@ID){~+})
 
Change metric aggregation options

ka02R000000btTRQAY_0EM2R0000019dHh.jpeg

 
Create metric ‘Executions (owner)’:
Formula:
Executions-[Executions (no-owner)]

ka02R000000btTRQAY_0EM2R0000019dHr.jpeg

 


Comment

0 comments

Details

Example

Published:

April 21, 2020

Last Updated:

April 21, 2020