Year filter on YOY comparison
I have card that I need filtered by chosen years. I have a 5 year data (2017-2021) and need be able for users to compare 2 chosen years using a filter. I tried the min/max function but does not seem to return the right result. I used the below BM:
To show recent year: case when `Year`= MAX(`Year`) then sum(`Gross Revenue`) end
To show older year: case when `Year`= MIN(`Year`) then sum(`Gross Revenue`) end
I am new to Domo and do hope someone can help. Thank you in advance.