Toggle between fiscal year and calendar year on charts

[cherylt]

I have a financial report that requires both fiscal year and calendar year view of financial metrics within the same dashboard. Instead of duplicating all my tiles for FY and calendar year charts, is there a way for me to have a filter than can toggle between the 2?

At the moment, when I try to have both (sale year and sale fiscal year) in the query, the output shows 2 bar charts for each fiscal year instead of summing them into one bar chart per fiscal year. Conversely, when I toggle to calendar year, it will give me only one of the 2 sales values for each year instead of summing it up.

[ArkadyZagdan]

@cherylt
It is posiblle.
But requires specific table schema for this.
After schema is solid you just use two radio buttons with parameters and boolean type of data.
You will also need a formula with CASE statetement.
Something like:

when 'param' = true then 'FY'
else 'CY'
end

Something similar to what I did here on this example where you can use buttons to show data for different dimensions on tables and charts.

https://lookerstudio.google.com/reporting/0eb9fcbd-b0c8-4bfe-8e9a-19ec57bbe482/page/p_zaae0rweid

Regards
Arkady Zagdan
Bigglo.pl, LinkedIN

[cherylt]

Thank you. I ended up just creating tiles for both CY and FY side by side since the stakeholder wanted them both at the same time. Will consider your suggestion above on implementing a parameter as a filter function in Looker for other dashboards in the future.