YTD Selection Question

Options
Matthew Sobon
Matthew Sobon Customer
Level 100: Foundations of Building in Board First Anniversary 5 Up Votes Photogenic
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
    First Anniversary Level 100: Foundations of Building in Board Level 200: Leveraging Board for Business Insights 5 Up Votes
    edited January 2023
    Options

    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
    Level 100: Foundations of Building in Board First Anniversary 5 Up Votes Photogenic
    edited January 2023
    Options
    This works, thank you!


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