Forum Discussion

MagnusSthlm's avatar
MagnusSthlm
Icon for Helper I rankHelper I
8 years ago
Solved

Creating dynamic quarters

Hi!   My customer has four charts, one for each quarter. They want to select Year and Quarter from a dropdown for example 2018-Q4 as start quarter. The second chart should then show show data from ...
Need Help
  • MagnusSthlm's avatar
    MagnusSthlm
    8 years ago

    Hi! 

     

    Thanks for your reply. I actually solved it yesterday.

     

    In my date table I created a Year - Quarter column. Then I manually created a new table, called it Year Quarter Selector. It had four columns, first column is the year - quarter the user selects. Then the next column is the following year - quarter. So first could be 2018-Q4 and the second would be 2019-Q1 and so on. 

     

    Then I created  four measures that used SELECTEDVALUE from my selector. I used them as filters in the chart. 

     

    I can clarify with some code if someone is interested.

     

    /Magnus

     

  • MagnusSthlm's avatar
    MagnusSthlm
    Icon for Helper I rankHelper I
    8 years ago

    Hi! 

     

    Thanks for your reply. I actually solved it yesterday.

     

    In my date table I created a Year - Quarter column. Then I manually created a new table, called it Year Quarter Selector. It had four columns, first column is the year - quarter the user selects. Then the next column is the following year - quarter. So first could be 2018-Q4 and the second would be 2019-Q1 and so on. 

     

    Then I created  four measures that used SELECTEDVALUE from my selector. I used them as filters in the chart. 

     

    I can clarify with some code if someone is interested.

     

    /Magnus