Dynamic Time Selections

Mallory Lindsey

What is the most efficient way to make a selection based on a custom time range? For example, I want to see data from the last 90 days, or the last 6 periods. 

Thanks!

------------------------------
Mallory Lindsey
Business Reporting Analyst
Pepsi Bottling Ventures
United States
------------------------------

Helmut Heimann

Hi @Mallory Lindsey,

please have a look at our "Tips & Tricks Tuesdays" where this was covered in a webinar:

Kind Regards,
Helmut

------------------------------
Helmut Heimann
Senior Consultant
Board Community
Germany
------------------------------
-------------------------------------------

Mallory Lindsey

Hi @Helmut Heimann,

Unfortunately, this is not what I'm looking for.
The example I provided was for a user to have the ability to select "Last 60 days" or "Last 45 days" based on either the current date or a manually selected date. To clarify, selecting November 1st, 2020- last 45 days would display data between Sept. 18th, 2020 thru Nov. 1st, 2020.

It is not feasible to suggest to members of our field sales team to modify layouts, select different time parameter settings, etc.
This function should exist as a part of the screen selection.

Thanks.

------------------------------
Mallory Lindsey
Business Reporting Analyst
Pepsi Bottling Ventures
United States
------------------------------
-------------------------------------------

Helmut Heimann

Hi @Mallory Lindsey,

ok, understood. If you copy&paste "how-to-select-the-last-10-days" in the search box, you'll get a link to this post from my colleague @Felix Csanady

This will help you start. The additions made by @Daniele Di Lorenzo might help to get deeper into the subject.
If you still face any challenges, I'm happy to help out.

Regards,
Helmut

------------------------------
Helmut Heimann
Senior Consultant
Board Community
Germany
------------------------------
-------------------------------------------