YTD Selection Question

Matthew Sobon
Matthew Sobon Customer
Second Anniversary 10 Comments Level 100: Foundations of Building in Board 5 Up Votes
edited January 2023 in Platform
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
------------------------------

Answers

  • Bettina Clausen
    Bettina Clausen Employee
    Fourth Anniversary 25 Up Votes 25 Likes 5 Answers
    edited January 2023

    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":
    image

    Kind regards,
    Bettina

    ------------------------------
    Bettina Clausen
    Team Leader Professional Services
    Board Deutschland GmbH
    Germany
    ------------------------------
    -------------------------------------------
  • Matthew Sobon
    Matthew Sobon Customer
    Second Anniversary 10 Comments Level 100: Foundations of Building in Board 5 Up Votes
    edited January 2023
    This works, thank you!


    ------------------------------
    Matthew Sobon
    Data Analyst
    M.T. Maritime Management (usa) LLC
    United States
    ------------------------------
    -------------------------------------------