Stack Overflow
Stack Overflow

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/

458 questions
36
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…
YangZhao
  • 421
  • 1
  • 4
  • 10
22
votes
4 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
  • 4,461
  • 20
  • 33
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…
Bryn
  • 257
  • 3
  • 14
9
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
  • 1,759
  • 2
  • 18
  • 35
9
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,413
  • 1
  • 14
  • 24
9
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
  • 331
  • 2
  • 11
8
votes
4 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
  • 81
  • 1
  • 4
8
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
  • 81
  • 1
  • 5
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
  • 955
  • 1
  • 12
  • 35
7
votes
1 answer

Since QuickSight can directly query S3, when would we need to use Athena as data source for QuickSight?

May be I am missing something but I am not able to understand what benefit I will get if I connect Athena with QuickSight instead of connecting QuickSight directly with S3. Please help me to understand this.
Anand Shaw
  • 219
  • 4
  • 12
6
votes
0 answers

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…
Big Chungus
  • 145
  • 1
  • 9
5
votes
2 answers

AWS Quicksight - MAX Data calculation but display date

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 + extract('DD',OrderCreatedDate) But how I can put it back…
n34_panda
  • 2,257
  • 4
  • 20
  • 36
5
votes
0 answers

Quicksight reports from schema based multi tenancy on postgres

For a multi tenant SaaS product we want to be able to build canned reports for customers from a schema based tenancy model (not the row level security). Is it possible to do this on AWS Quicksight? It looks like you need to select a particular table…
Vishal
  • 371
  • 3
  • 10
5
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
  • 135
  • 1
  • 9
5
votes
1 answer

amazon quicksights compare time periods

Can line charts or bar charts compare two time periods? Example compare sales revenue between 2017 to 2016 by month, to see how Jan 2017 compares to Jan 2016, Feb 17 to Feb 16, etc. In the chart I'd like to see whether I'm up or down between the…
Gary W
  • 51
  • 1
  • 3
1
2 3
…
30 31