Jim Posted May 31, 2024 Posted May 31, 2024 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
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now