The Count(distinct Total [Vehicle Plate Number]) only gives me the ability to count the total number of unique records in the Approved Vehicle List. (7)
Is it possible to dynamically count the total number of vehicles of a particular selection set (as defined by the user)?
So, if I were to connect a KPI (identifying % of Vehicles using Toll Roads) to a Filter pane,
The return value for Facilities Group would be:
1 (Number of Vehicles in Facilities Department Description / 2 (Total Number of Vehicles in Facilities Business Group) = 50%
And if I toggled to another group, Safety Group
2 (Number of Vehicles in Department Description / 3 (Total Number of Vehicles in Safety Business Group) = 66%
Apologies if there was any previous confusion.