Field Formula

[ScottJones1]

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?

[DanielFox1]

Hi @ScottJones1 

You could try the following which means you don't need to create a table manually

1. Create a Feature Layer View from your Survey123 data.

2. Use Arcade expressions in the view or dashboard to:
• Filter by a specific date
• Count incidents per day
• Optionally group by user or other fields
Example Arcade Expression (for a dashboard indicator) - this can be changed to use DateDiff or FormatDate if needed;

var today = Date();
var filtered = Filter($layer, "DateField = @today");
return Count(filtered);

[ScottJones1]

Daniel, would I be building this arcade expression in a new field in the layer? so that the field would calculate how many times and entry was made but only count (1) per day no matter how many entries? I did not see where I could try to build an Arcade expression. 

INC 1 -- NOV 1, ops meeting, support crews

INC 1 -- NOV 1, update executive staff

INC 1 -- NOV 2, ops meeting

I am trying to get a list that would display, INC 1 - Days 2 , right now it would show INC 1 -- Days 3