Forum Discussion
Performing Counts
I am trying to get counts for a visualization. I have audit data in the AuditTable and observation data in the ObservationTable and I am trying to get a count of Critical, Major and Minor observatio...
Try this measure:
Observation Count = COUNTROWS( ObservationTable )
and slice by your attributes (Critical, Major, Minor) in a matrix.
Best
D
Observation Count = COUNTROWS( ObservationTable )
and slice by your attributes (Critical, Major, Minor) in a matrix.
Best
D
Thank you az38 and Anonymous for your advice. I realized I was missing something so I created a new field to help with the calculation.
In the AuditTable the important fields are TRN_ID, and ChildObs
In the ObservationTable the important fields are PARENT_ID, CLASSSIFICATION_OF_OBSERVATION
Ideally what I need is three calcualted columns for Critical, Major and Minor.
The logic for the calculation is:
If ChildObs = False = 0
If ChildObs = True and OBSERVATION_CLASSIFICATION = Critical, Count
If Not 0