So reading through the AWS Quicksight docs, I have found the following information. Handling Date Time Zones: Amazon QuickSight uses UTC time for querying, filtering, and displaying date data. Whe...

I am getting below error when i am trying to create New Dataset in Quicksight from Athena. I tried for "Table" and "view". It gives below error : [Simba][AthenaJDBC](100071) An ...

My visual's x-axis is Date, aggregated by month, and the y-axis is total sales (sum of costs). For some months, I had no sales, but Quicksight ignores these and only shows me the months that do hav...

I know I can change the date field granularity to week in AWS Quicksight, and I can also display the date by week number. But as far as I understand, Quicksight defines the start of a week on Sunda...

Im trying out aws quicksight getting started tutorial: https://docs.aws.amazon.com/quicksight/latest/user/embedded-dashboards-with-iam-setup-step-3.html Im at a step to use aws quicksight register...

I'm grasping at straws at this point. I have a Database in LakeFormation and I've given the quicksight service role access to it as well as underlying tables (and their S3 buckets). I've also verif...

We have a lot of AWS quicksight reports in one account, which needs to be migrated to another account. Within the same account, we can use the 'save-as' feature of the dashboard to create a copy ...

What I currently have in my Quicksight account is a Data Source (Redshift), some datasets (some Redshift views) and an analysis (graphs and charts that use the datasets). I can view all of these on...

I am looking for an AWS-centric solution (avoiding 3rd party stuff if possible) for visualizing data that is in a very simple DynamoDB table. We use AWS Quicksight for many other reports and dashb...

Is there a way to export a Quicksight dashboard via API, (Via console it's Export > Download as pdf) ? I checked the boto3 docs and couldn't find it, so would appreciate any pointers.

I am looking to refresh a data set in quicksight, this is in Spice. The data set comes from a csv file that has been updated and now has more data than the original file I uploaded. I can't seem t...

Is it possible to create single AWS QuickSight dashboard containing analysis from different datasets? What I have seen that one can create an analysis on a single dataset, can add multiple charts f...

How Can I MAX a date but display it on the Analysis/Dashboard? I am aware I can use the following to max a date: extract('YYYY',OrderCreatedDate) * 365 + extract('MM',OrderCreatedDate) * 31 + ext...

I have a Spark batch job which is executed hourly. Each run generates and stores new data in S3 with the directory naming pattern DATA/YEAR=?/MONTH=?/DATE=?/datafile. After uploading the data to S3...

In Amazon Quicksight, I have a dataset with a bunch of data items which are imported into SPICE from JSON in S3. For simplicity, assume that data items look like this: {url: "/us/page1.html&qu...

I have localhost with https and now I want to add this domain into QuickSight Dashboard to use Embed feature, but I have this error: This Domain is not supported. QuickSight dashboards can only be ...

How can I make an accumulated sum graph with AWS QuickSight? For example, I have a dataset that contains the sales for each day. I want to make a line graph for each month that has the accumulated ...

What are the options available to schedule or automate refresh of a quicksight SPICE dataset? Are there any APIs available to automate spice datatset refresh? preferably using python.

I'll make a simplified example for this site, but basically I'm trying to write an Athena query (of data loaded by Glue crawler with intent to use in Quicksight) which will allow me to expand a str...

This must be a silly question. I know how to do a "save as" for a dashboard (don't really need that, but any way). But now I have a analysis with a lot of settings (parameters & filters) ...

I do not want a scheduled refresh which according the documentation is daily, weekly, monthly. I want to refresh whenever I want, but without going on Quicksight and manually pressing refresh...

We have a few MySQL RDS instances in West-1 (N. California) and wanted to create some reports using QuickSight. First issue was that QuickSight was only available in West-2 (Oregon) and did n...

In below dashboard, I want to set date control to default as today's date. So that whenever the page load the default filter gets applied for today's date. I am using this parameter in my fil...

I have a database in Athena, with an external table pointing to a directory in my S3 bucket. I can query the tables fine in Athena. When I go to create a new data set in QuickSight, and I se...

I am exploring Amazon Quicksight as a cloud-based BI tool. We have some nice to have requirements like Schedule Reports on a monthly basis on the same set of datasets. This needs to be deli...