I have a Survey123 Connect, that will record activities while personal are on an INCIDENT, over several days and sometimes weeks. They might be on multiple incidents at the same time. I would like to create a COUNT, that calculates how many Incidents, both the cumulative Total and Currently active, and if possible how many days we have been active on an Incident. I think the Current can be achieved with a "Past 7 Days" filter? but will it count the same Incident multiple times?
Is there a way to count days? if the individual is making multiple entries each day? (without having to build a repeat).
Is there a way to count the Incidents that do not count duplicates? (the incidents will be coming from a drop down menu).
I think I am essentially asking the Dashboard to Pivot Table the information...
