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.
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
SELECT order_id, 'complete', completed_at'
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.