Time filter not working properly
Hi everyone,
I have a grid where i show Products in rows, time/multiple line items in columns (Sales, Py Sales, %growth etc..).
I want to control the time dimension based on selector provided to user (Attaching Screenshot).
There is a final time filter line item and it is at month level and works fine if i use it when single line item is published or when line items is used as pages.
This final time filter is not working when multiple line items published on columns
(Expected Output)
(Currently it is showing blank)
V.Sai Bharadwaj
Comments
-
I am not sure what logic you are using for your final filter but here is mine which works even when there are multiple line items published as column. Make sure the summary for Final filter is formula. Please refer attach screenshots for better understanding.
Thanks
0 -
Hi,
Thanks for the reply. I have the same filter with same formula. It's working in backend but on new ux it is not working
V.Sai Bharadwaj
0 -
Hi,
I have tried publishing it as custom view and saved view both and it still works on New UX. Few things you can check -
Allow editing option is enabled for both grids
Apply filter after pivoting your grid on the Board.
Thanks
0 -
Okay thanks, still unresolved though. reason being i have 3-4 dimensions in my module
V.Sai Bharadwaj
0 -
Also don't forget that if you've applied a filter and then repivoted the filter always breaks so needs to be reapplied.
0