Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Data segmentation

Hi! I have here two data segmentation visual that refers to a date. But one refers to 2022/23 and the other 2023/24. I want to make so, that when i filter on one of them, the other one filters the equivalent month automatically. For example, if i filter september 2023, i want the other data segmentation to filter september 2022 automatically, am i able to do this? i tried creating a column that equals the dates, like september 2023 = september 2022, and then relate those columns, but it just doesn't work.

My visuals looks like this

 

Need Help

1 Reply

  • Anand24's avatar
    Anand24
    Super User
    2 years ago

    Anonymous ,
    Join both tables on Month. If not already present, create a calculated column for month anf then join on it.

    Although one data is from 22/23 while other is from 23/24, the join will still happen since month name will be same in both(April = April, May = May, etc).

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn