I have a chart that has various values by month. and I have a table that outputs the sum of everything. So I want to use a Month filter that affects the table without losing the chart data.
here is my equation:
this field is the dimension on the chart that refers to the Month. This equation gives me an error. So this is what i am using right now:
I want this field to not change even with a filter for it.
Thanks in advance!
It didnt work.
The "only" function isn't what i want. I want to make the filter of this dimension not work on this chart. Like this:
Shows all months from 2018.
So i just need a function that will ignore this field filter.
Can you share your sample app please. Where are you using this expression i mean in calculated dimension or as an expression. Can you screenshot the selection you are doing and your expected output you want to see. A sample file with expected output will help us to help you better.