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 !
