I am trying to create a way to Count [Incidents] based on entries that will be associated with a [Date]. Here is the ringer, there could be multiple people entering data, and multiple entries each day, but I only want to show activity for 1 day. I would like to display on a dashboard but Distinct does not show up as an option when I built the table. I can use a list but don't think that option is available.
My work around, can I create a separate table that will store this information and update accordingly? the table would collect Incidents and total number of days and entry was inputted from a survey123.
Any ideas?
