Good evening! Could you help me? There's a table ...
# gd-beginners
t
Good evening! Could you help me? There's a table called tf_operação. It contains production orders and the date columns: closing_date, opening_date, and issue_date. I'm trying to create a report. For example, when I filter the month of August, it returns all operations with the August opening date, August closing date, and issue date. And this should work through filters. If the user wants to filter another period, the reports will follow the filters.
j
Hi Tomas, I'm afraid that what you've describing is not possible. However, I'm not sure if I understand the use-case correctly here. Just to clarify — are you expecting to have one single date filter on the dashboard (for example August) that would at the same time filter the opening date, closing date, and issue date? Meaning that if any of those dates fall in the selected period, the operation should be included?
t
That's exactly
j
Hi Tomas, What you are describing is currently only possible in Dashboards. You can use the primary date filter, which acts as a global filter across all widgets. Each widget can be mapped to a different date dataset (e.g., opening date, closing date, issue date), so when you select a period like August, it will apply everywhere. Documentation here: https://www.gooddata.com/docs/cloud/create-dashboards/filters/date-filters-on-dashboards/#additional-date-filters However, if we are talking about reports/vizualisations, there is no such out of the box option. In similar case, I can only recommend to use all date filters at once e.g:
I understand that on the vizualisation level this is not exactly what you are looking for, as it requires setting each date filter individually. We’ll be happy to pass this along to our Product team as feedback, since a true global date filter inside Insights could make this scenario much easier.