Calculating Average Number of Missions Per Week, Per Month, and Per Quarter

Question

In an experience builder that I am making for the Drone Unit that I run, I am trying to figure out the following.

Using my Survey 123 form that I use to track my missions I want to show the average number of missions per:

Week

Month

Quarter

Would this be possible in experience builder or more of a dashboard thing?

ShengdiZhang · Answer

Hi @Zelong ,

An easy approach is to create multiple data views—for example, weekly, monthly, and quarterly—and apply the appropriate filters to each view. You can then connect a text widget to these different data views and use dynamic content to display statistics.

Alternatively, you can use a text widget with Arcade. With Arcade, you can write a single script that calculates and returns these values.

Regards,

Shengdi