Override PDT On Specific Looks in Dashboard

  • 22 January 2016
  • 0 replies

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
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:

0 replies

Be the first to reply!