As a business user I want my KPI chart to be updated in realtime. Currently our KPI summary look is built using a PDT. The reason is because we want to show the count of different events around the same time dimension. For example if I want to show the number of orders completed and number of orders shipped in the same look.
| order_id | ordered_at | shipped_at| |
|---|---|---|
| 1 | 2016-01-01 | 2016-01-02 |
| 2 | 2016-01-01 | 2016-01-01 |
Filter = 2016-01-01
| Orders Complete | Orders Shipped |
|---|---|
| 2 | 1 |
In order to create that look I have PDT (and corresponding explore) where I union. In addition I have an explore in the same model for the orders.
SELECT order_id, 'shipped', shipped_at
FROM orders
UNION ALL
SELECT order_id, 'complete', completed_at'
FROM orders
For performance reasons I persist this PDT for one day. This allows me to create those time dimension looks that I am putting on a dashboard. My feature request is the ability to certain looks to override the PDT, and execute the look in realtime instead of using the PDT. This could be configured per look on a dashboard. I know you can “Rebuild Derived Tables” but this is for dashboards.
Related to: