Filter timescale by day and month in one grid

  • 3 November 2022
  • 5 replies

Userlevel 1

Hi community! 

I need to filter grid in board by days and month. I have a boolean metric “Show days?” and when it is TRUE I want to see in grid only days, when its FALSE I want to see only months. 
How can I do it?


Best answer by Andrea 7 December 2022, 13:33

View original

5 replies

Hi Ivan, we are looking into this and should be able to provide an answer shortly. Thanks for your patience.

Userlevel 3
Badge +4

Hello Ivan!

Thanks for the suggestion. Currently we don’t have any native functionality allowing you to apply “metric based” filters on View Pivots (Months and Days). However we would like to know more about what you are trying to accomplish to better understand the underlying need. Why do you want to show more granular data in some occasions? and what’s the condition you are using to calculate “Show days?”? Thank you!

Userlevel 1

Hello @Andrea

End users work with the board in the following order:
1. Set up the period they want to see on tables and charts. For example, From September 2022 to December 2022. I understand how to set up this filter, but when you change from or to, these changes are applied to other users, which should not work like this and I did not find a solution to this problem.
2. Users need the ability to drill down to days to analyze data within a month. And also see the daily data passing from month to month, for example, from 15 November 2022 to 15 December 2022. To make the board look more compact, I need the "Show days?" filter. So that the end users can analyze the data within a single page.

Userlevel 3
Badge +4

Hello Ivan,

Sorry for the late reply.
When you change your Pages from/to (filters) this change doesn’t impact all users. It only impact all users when you change the from/to in Page options> Defaults items and Available items. 
I get your second point actually you need a more compact way to jump from month to day granularity. What about “expanding Month” so that you show Day and Month pivot at the same time in the grid. Is this the kind of behaviour you are looking for?
Kind regards,

Hi @Ivan Senkin did this answer your question? Anything else we can do to help?