We have several clients who would like to see two KPI/s on a single dashboard: the first shows a statistic for the last 12 months, the second shows the same statistic for the last month. I know that we can build a single KPI and show it on two dashboards (each with its own timeline), and I know how to build KPIs that include/exclude parent filters. But I have been unable to figure out how to have a KPI rely on a parent filter in one case while another KPI on the same dashboard ignores the parent filter while simultaneously substituting an independent timeframe.
We have a system attribute called Timeline and our development team has defined two system metrics, _Timeline_Start and _Timeline_End. These metrics were created from Timeline (Min(Date(Timeline) and Max(Date(Timeline), respectively). To me, the latter would be seem to be of particular importance to this inquiry, presuming that the time line for the common dashboard is selected as the 12-month window.
Here is an example of the type of dashboard desired, developed in one of our other products (an operational tool, not an analytical tool like GoodData).
Any help/guidance would be greatly appreciated, even if the answer is it can’t be done.
I think our license is GoodData Enterprise.
Best answer by Joseph HeunView original