Hey, is it possible to filter KPI on date other th...
# gooddata-platform
m
Hey, is it possible to filter KPI on date other than the dashboard date? For example, I want to show last 12 month data on the dashboard, but for the KPI, I would only want to show last month data and MoM change.
m
Hi Matej, in Analytical Designer, you can use the date filter for time over time comparison to analyze your data without using complex MAQL syntax. More details can be found here: https://help.gooddata.com/pages/viewpage.action?pageId=86793502 You might also find the following Doc useful: https://help.gooddata.com/pages/viewpage.action?pageId=86793579
j
Like @Michael Ullock says, you can hardcode a date filter with a Headline insight in the Analyze tab. When you place such an insight on the Dashboard, you'll most likely want to exclude the Date filter from the Dashboard — see the below screenshot 👇
m
Awesome, thanks, headline insights fixes the problem, but raises another: you cannot set up alerts on change, as you can with the regular KPI.
j
That's right, alerts only work with KPIs, and not with Headlines. In this case I would suggest you hardcode the (relative) date filter directly into the metric using MAQL, use this metric to create the KPI, and then again exclude the KPI from being filtered by the dashboard date filter.
👌 1