Forum Discussion
Helper IIIHow to filter the date
Helper IIIAs you can see in the picture, there is a range of 2019 - 2022 data. If I choose to filter the date using the filter, I can filter it by Months, year. But that means I will have the same months, and I don`t need the same months every year, just half year 2021 and then full year next one. (or I don`t know how to set it otherwise). I want a graph to show data starting from June 2021 onwards, not June 2021, June 2022, etc
On top, I put a DATEBETWEEN formula, but the graph still shows 2019, 2020 years.
Helper IIII managed to filter it by year, 2021 and 2022 in the first graph.
I have tried to sort the data to calculate a specific period, so I added the formula with DATEBETWEEN, and periods required. Unfortunately, it still shoes all the date range from 2019, even if I selected June 2021 to today's date. I don't know how to get rid of 2019 - 2020, half of 2021 data 🙂 (see second graph).