Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filter Data for other Quarters Automatically based on current quarter selection

Hi, So i have 4 Matrix Visuals (filtered by 4 to 5 visual dropdowns). One of the dropdowns is an FYQ dropdown itself The matrix visuals are basically Fiscal Year and Quarter. For example FY23Q1(Curr...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , You have create a column, as of now, to default values

 

Switch( True() ,

format(today(), "YYYY\QQ") = format([Date], "YYYY\QQ"), "This Qtr",

[Qtr Year]

)

 

and save this on "This Qtr"

 

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks amitchandak. Unfortunately this is a set of Quarter Values that are filled by folks manually and stored on an SQL server. I dont see any  dates in there.  Do you think the date/time functions would help in this case? These FYQ values are merely categorical in nature with no time relationship