Sort my data from September to august

Question & Answer
,
1

Hello everyone i’m new in the Quicksight World :smile: and here’s my problem :
I would like to sort my data by exercices (so from 1st September 20XX to 31 august 20XX + 1)
I can do that with a filter but i want the user to choose the years that he want (u can see it below on the pic that i uploaded). I was thinking that i have to use a calculated field but i didnt succed, that’s why im creating this post.
Any ideas how can i do that ?

image

2

Hi @CowBow

so “1st September 2022 to 31 august 2023” will be 2022-23 right?

One option would be to create a calculated field.

Ifelse(data>= 1st September 2022 AND data <=31 august 2023,2022-23,data>= 1st September 2022 AND data <=31 august 2023,2023-24,...)

And use the new field as a filter.
BR

3

Hi @CowBow
could you solve your issue?
BR