I have one dashboard for which the data source is Redshift and the dataset Query mode Is Direct Query
Data gets rendered but total and subtotal are not loading correctly and it says visual error as attached in the screenshot
@SeanBoon any help?
@khushalt5 I see you have adhoc filtering enabled on this dashboard. Try limiting the data by applying some additional filters and see if you are getting totals and sub-totals. Also worth checking if there are long running queries on RedShift . If you are not getting totals and sub-totals even on a constrained set of data, then I’d open a support case to dive deeper on the failure
we have one parametrized filter only we don’t require more filter as of now so is it not possible with Direct Query
Data is in few thousands only
You can have any number of filters. If the data that the queries are running against are large, then I was suggesting to try and limit the data to see if results come back faster. In that case we would know about the timeout. Is the DQ source RedShift? Were you able to see the query timings there?
The data source is Redshift, our data is loading properly but the problem is with the custom logic of Quicksight on top of It, where total and sub total is not getting calculated it seems just loading and after some time of interval it showing Visual Error