How to: Create a dynamic set of dates
Question: How to create a dynamic set of dates
During a recent discussion we got asked how to create a dynamic set of dates.
There are two approaches to the tasks, in this video Moshe Yossef takes you through both ways and explains how to achieve the task.
Solution:
Scenario 1:
Provide a list of the last 10 Days, whether they have data or not, assuming and the date column's last date today.
Scenario 2:
Provide a list of the last 10 Days, even if the date column has dates later than today.
And here is the video for you to review
How to create a dynamic set of dates
You can find the example in our Explore Pyramid Server for Review in the Public Content, Knowledge Base Folder.
If you have questions or suggestions, please leave them below the Article.
5 replies
-
Thanks , this is really helpful. Just further this method, can we change today or max date to any date, like the user can pick any date from date slicer, and provide the last 10 days data? or if the user pick the date range, i want to show all date like the following:
Referral volume
= count (distinct if (
FIRST_REFERRAL_DATE >= (minDate -365) and
FIRST_REFERRAL_DATE < maxDate,
REFERRAL_ID))
Content aside
- 5 Likes
- 1 mth agoLast active
- 5Replies
- 295Views
- 2 Following