Avg over a specific time frame based on the filter selection

Q&A
, , , ,
2

In Quick Sight, you can create calculated fields using the calculated field editor. Here’s how you can create the calculation for average sessions per day:

  1. First, create a calculated field for the number of distinct sessions:
distinct_count({Session ID})
  1. Then, create a calculated field for the number of days in the selected time frame:
dateDiff({Date Created}, min({Date Created}), max({Date Created}), 'DAY') + 1
  1. Finally, create the calculated field for the average sessions per day:
distinct_count({Session ID}) / (dateDiff({Date Created}, min({Date Created}), max({Date Created}), 'DAY') + 1)

To use this in your analysis:

  1. Add your date filter to the analysis.
  2. Add this calculated field to your visual.

The calculation will update based on the date range selected in your filter.