Joined: 10 Feb 2012
Location: United States
Online Status: Offline
Posts: 2
Topic: Distinct Count help Posted: 10 Feb 2012 at 9:22am
I'm trying to chart a distinct count of records based on the change of a formula. My problem is that for one result of the formula all of the records meet the criteria.
For every group record there is a set of tasks in the details. Every group record has 'Task A'. Only a subset has 'Task B'. My formula labels the tasks, but when i try to summarize in a chart with a distinct count of the parent records, it sees the 'Task B' items but then also shows all of the 'Task A' items, thus skewing the total 'Task A' count by the amount of records with 'Task B'.
e.g. 100% of records meet criteria A only 42% meet criteria B therefore 58% do not meet criteria B.
How do I get my chart to differentiate that parent records with 'Task B' should NOT be included in the count of parent records with only 'Task A'?
Joined: 10 Feb 2012
Location: United States
Online Status: Offline
Posts: 2
Posted: 10 Feb 2012 at 9:42am
Is there a way to filter my record selection to only pull the last child record? This would work in every case, then I'd only have one result for the formula per parent.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum