I have created a calculated field and a parameter in looker studio, to filter my data based on options 12 months, 24 months, all. I ma using the parameter as my control field and my calculated field in filters. But when I am selecting the options to filter the data, the data in the 12th month or 24th month is showing 0, when I am editing my calculated field for dates greater than 13 months then I am getting data in 12th month but not in 13th month. I tried hardcoding the dates in the condition also used date trunc to consider the first day of the month, but still the issue persists.
LinkedIn
Twitter
