Forum Discussion

awitt's avatar
awitt
Helper III
6 years ago

Seasonal Date Issue

Hello all,

 

I have a date table and an orders table that are related and my date table has the standard date table things along with a column for season (Spirng, Summer, Fall, and Winter), a SeasonValue column (1 , 2 , 3 , 4) and another for "Term" which is a combined Season + Year. This Term column is what the end user is selecting. 

 

My question is, I'd like to have a line chart that shows the results of of the only the relative seasons when the user selects a specific Term. So if the selection is "Summer 2020" from a filter, the results on the line chart would be the orders data from Summer 2017, 2018, 2019, and then 2020 with the other three seasons not included. 

 

Thoughts?

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi awitt 

     

    I would create a filter on only season column and not on season year.

    • awitt's avatar
      awitt
      Helper III
      6 years ago

      Anonymous That's not what the user wants. If I didn't have to have the Term selected then I wouldn't have the issue...

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi awitt ,

     

    "I have a date table and an orders table that are related and my date table has the standard date table things along with a column for season (Spirng, Summer, Fall, and Winter), a SeasonValue column (1 , 2 , 3 , 4) and another for "Term" which is a combined Season + Year. This Term column is what the end user is selecting. "

    Please give sample data for these two tables.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.