Jump to content

Recommended Posts

Posted

Are measures limited on how much data they can bring back from captured data fields? 

 

Why do I ask? 

 

I am querying our first time fix percentage in a measure, based on the following criteria 

h_fk_serviceid in ('1','27')
and h_requesttype = 'Incident'
AND h_status IN ('status.closed', 'status.resolved')

SUBQUERY h_firsttimefix!='NULL'

The percentage is accurate, the Measure row count is accurate at 1387, the count for the sub query is 665, When I run a report based on the measure entity it only returns 479 results. So I have had to build a report separate to the measure querying the exact same thing to be able to see the values for the measure

 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...