YTD Selection Question
Matthew Sobon
Customer
Hello,
I am wondering if there is a way to have a specific month be selected whenever a year is selected. For example, if 2021 was selected the month would then select December 2021. This might be an obvious thing that I am missing.
Thank you,
------------------------------
Matthew Sobon
Data Analyst
M.T. Maritime Management (usa) LLC
United States
------------------------------
I am wondering if there is a way to have a specific month be selected whenever a year is selected. For example, if 2021 was selected the month would then select December 2021. This might be an obvious thing that I am missing.
Thank you,
------------------------------
Matthew Sobon
Data Analyst
M.T. Maritime Management (usa) LLC
United States
------------------------------
0
Answers
-
Hi Matthew,
you might solve this using "custom time entities".
In that specific case you could create another year entity above Month which then is only linked to december (and rest to "_").
https://www.boardmanual.com/2021/summer/data-modeling/2_Database_design_functions/7_Time_Range/the-time-range-section.htm?rhsearch=time entities
If it is just relevant in screens you might also work with pagers on month and selection on year.In that case you could define the "period" of the pager with "last period":
------------------------------
Kind regards,
Bettina
Bettina Clausen
Team Leader Professional Services
Board Deutschland GmbH
Germany
------------------------------
-------------------------------------------0 -
This works, thank you!
------------------------------
Matthew Sobon
Data Analyst
M.T. Maritime Management (usa) LLC
United States
------------------------------
-------------------------------------------0