Hello,
I have a dashboard connected live to a Postgresql database. It's pulling in 1 dashboard view with 41K records. In my tableau workbook, i applied a data source filter to show only 7 day's worth of data which is around 1500 records. I have a few LODs, couple count distincts, and 5 date fields created to convert UTC to EST.
I have no problem rendering the dashboard on the Server (takes 4-6 seconds). However, when I perform a dashboard filter action to filter on a specific Region with 18 records, it takes around 2 mins to complete. I'm not sure why this is happening given it's only 1500 records with the data source filter. Unless the filter action takes the entire dashboard view of 41k to do the filter?
I did a performance recording doing the filter action and saw around 5 "executing query" bars that take around 15-20 seconds.
sample query:
Appreciate any help! thanks!
Hi Anky,
If you create an extract does it perform faster ? My initial thoughts is it might be creating an unnecessary delay when converting the timestamp into a data point by polling for a server response rather than calculating it on the fly through Tableau Desktop.
By creating an extract will hardcode the timestamp and force TD to do the conversion.
HTH
Peter
