Help

How to create a Interface diplaying data "within" a time period

635 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Clement_Lapierr
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello everyone,

I am currently building a Dashboard to summarize a database with multiple revenue sources. Each of these revenue sources have a Start date and an End date, along with associated revenue calculations.

I would like my Dashboard to summarize this and to allow me to place myself "within" a certain time frame.

E.g I would like to see all the revenue that will be collected between January 1st, 2023, and January 31st, 2023.

The problem is, some of the revenue sources are starting in December 2022 and ending mid-January,  whereas others are starting on January 28 and ending in March, etc...

Is it possible for me to "scope" my Field Summaries element so that they only match a certain time range ?

Thank you in advance !

1 Reply 1
Matthew_Carrano
6 - Interface Innovator
6 - Interface Innovator

Yes. Use a filter element and connect it to the elements you want 'scoped' and then create date range filters.