Hello! I had a question on the report view of a board. I see card models breakdown when I click on this view, but is there a way to filter it by a certain timeframe? for example, to know the card models breakdown just of the month of July? Thank you!
Hi !
You can make a query regarding a status like the creation, update of the card to display the number of cards by type. The request cannot gives you the list of cards that simply had this type of card over a specific period (data not processed at the moment) without other criteria. For the moment, you must also mention each period that interests you in the query.
Here is an example of a possible configuration:
-Add a Custom query widget
-In query field, add this kind of request if you want to count card by timeframe :
query({created at}>« 2025-05-01 » AND {created at}<« 2025-06-01 »,count()) as « may »; query({created at}>« 2025-06-01 » AND {created at}<« 2025-07-01 »,count()) as « june »
-group by card type
If you need picture of the state of your cards, for example each mont I recommend that you schedule a monthly export to keep this information each month. You can manage it with an automation rule.
I hope you find this helpful.
Thank you! We will try this
1 « J'aime »