Is it possible to use filters not for every column but for the ones we choose. For example; I want to get the total average amount of something and its monthly average amount; and I want to demonstrate those two columns side by side. Do you know any way to do that?
I'm not sure I understand what you mean. You talk about filters, but then about aggregations too, which are separate things.
It sounds like you would have to create two questions, which gets the different period granularity and then create another question where you join those two.
I would likely be easier to do this in SQL instead, but it's hard to tell without knowing the data.
Thanks for the reply. Yes, I wanted to get the same aggregation with different time filters (in separate columns) in one table. But it is not possible I guess, just wanted to be sure.