Questions tagged [amazon-quicksight]

Amazon QuickSight is a product offering from Amazon that provides a "business analytics" service in order to visualize your data, perform ad hoc data analysis, and also derive useful business insights from the supplied data. Use this tag for programming questions related to Amazon QuickSight. Questions related to the usage of the product itself are not on topic for Stack Overflow.

Documentation: https://aws.amazon.com/documentation/quicksight/

783 questions
46
votes
3 answers

How to make MSCK REPAIR TABLE execute automatically in AWS Athena

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, I want to investigate it using Athena. Also, I…
31
votes
5 answers

Visualize DynamoDB data in AWS Quicksight

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 dashboards for our clients so that is goal to have…
JD D
  • 7,398
  • 2
  • 34
  • 53
13
votes
3 answers

Copy AWS QuickSight analysis to another account

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 of the report, but is there any way to export the…
yottabrain
  • 2,387
  • 5
  • 23
  • 37
12
votes
1 answer

How to select today's date as default date in QuickSight Controls?

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 filters.
conetfun
  • 1,605
  • 4
  • 17
  • 38
12
votes
2 answers

Making an accumulated sum graph with QuickSight

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 sells day by day. So if the dataset is: Day1 = 10…
tanaka
  • 401
  • 1
  • 4
  • 13
11
votes
2 answers

Quicksight Athena - [Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client

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 error has been thrown from the AWS Athena…
Bokambo
  • 4,204
  • 27
  • 79
  • 130
10
votes
5 answers

Display Date as Local Timzone, not UTC in AWS Quicksight

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. When date data doesn't specify a time zone, Amazon…
apollocr
  • 215
  • 1
  • 2
  • 13
10
votes
2 answers

Refresh AWS Quicksight automatically

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. Wondering if it's possible to automatically refresh…
9
votes
5 answers

Is there a way to create Quicksight analysis purely through code (boto3)?

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 the AWS Quicksight Console. But when I use boto3 to…
ashirhs
  • 91
  • 1
  • 4
9
votes
1 answer

How to make a copy of a QuickSight analysis?

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) and want to reuse my work in a new analyses. But how do I make…
Nils B
  • 91
  • 1
  • 5
8
votes
1 answer

AWS QuickSight can't see Athena DB

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 select Athena as my source, I don't see my database. I have…
8
votes
1 answer

Scheduling reports & data driven alerts in Amazon Quicksight

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 delivered to the intended audience every month on a specific…
Tatha
  • 1,253
  • 2
  • 24
  • 42
7
votes
1 answer

Is there a function to download Quicksight dashboards as pdf?

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.
YetAnother
  • 1,045
  • 1
  • 9
  • 27
7
votes
1 answer

AWS QuickSight dashboard with multiple datasets

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 for the same one and it gets published as a…
Amit Teli
  • 875
  • 11
  • 25
7
votes
1 answer

Quicksight not showing months with no data (null?)

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 have data in them, even though I want the exact number…
1
2 3
51 52