Lyes Benacer
05/14/2025, 12:19 PMMichael Ullock
05/14/2025, 2:00 PMMichael Ullock
05/14/2025, 3:57 PMSELECT COUNT (User) WHERE Month/Year (StartDate) = THIS-11
Mertic Name: Year (EndDate) = This
SELECT COUNT (User) WHERE Month/Year (EndDate) = THIS-11
You would then combine these 2 metrics / 2 Date Dimensions - this 3rd metric you will use to calculate the data:
Metric Name: StartDate - EndDate
SELECT Month/Year (StartDate) - Month/Year (EndDate)
You would still need to use StartDate or EndDate in the “View By” configuration in your insight (depending on how you want to visualise the data), and the primary dashboard filter would then filter the insight accordingly. As I mentioned previously, we do not support multiple date filters on the KPI dashboards.
Insight 2 - With the above logic in mind: If you were to create an Insight which uses the EndDate inside it - The date dashboard filter would filter the insight, while your other insight(s) could be filtered by StartDate
Hope this helps!Lyes Benacer
05/15/2025, 8:39 AMStartDate < Data < EndDate
(This is the default expected behavior in GoodData — when applying a dashboard filter, it should apply to all insights.)
• Insight 2: Should be filtered only by the EndDate, i.e. Data < EndDate
(Meaning the StartDate part of the filter should not apply to this insight, even though it is set on the dashboard filter. And if the user changes the dashboard filter to a new range, e.g. StartDate2 - EndDate2
, then Insight 2 should be filtered by Data < EndDate2
)
In other words, I want to know if it’s possible to have selective filtering on the same dashboard, where one insight respects both start and end dates, and another respects only one boundary of the date range filter.
Thanks for your help and clarification!Moises Morales
05/15/2025, 11:23 AM