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/

783 questions
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
  • 229
  • 5
  • 13
7
votes
3 answers

AWS: Unable to connect Amazon QuickSight to RDS

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 not show our RDS, so I created a read-replica database into…
Shahid Thaika
  • 2,133
  • 5
  • 23
  • 59
6
votes
1 answer

Amazon Quicksight - How do I show two different filters of the same data on the same line graph?

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", errors: 6, Responsetime: "2021-03-21T10:00:01"} There are…
sil
  • 1,769
  • 1
  • 18
  • 34
6
votes
1 answer

QuickSight Embed add Domain with https://localhost

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 embedded in valid https domains. What is the best…
Avinash Kumar
  • 85
  • 1
  • 6
6
votes
3 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,577
  • 5
  • 24
  • 40
6
votes
3 answers

How do i refresh csv data set in quicksight and not replace the data set as this loses my calcs

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 to find a way to simply repoint to the same file with…
JoeD
  • 223
  • 1
  • 3
  • 5
6
votes
3 answers

How to fix: " AccessDeniedException: You are in ap-southeast-1, but your directory region is us-east-1. Please use us-east-1 as region."

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-user --aws-account-id XXXXXXXXX --namespace …
Jon Guiriba
  • 61
  • 4
6
votes
1 answer

Querying struct fields from AWS Athena/Presto

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 struct inside of a select statement. In my example,…
Larry Anderson
  • 563
  • 6
  • 15
6
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
  • 61
  • 1
  • 3
5
votes
1 answer

Changing a Dataset for a visual in AWS Quick Sight

I am new to Quicksight and trying to change the dataset for a cloned visual. I have created one analysis in AWS Quicksight which contains 6 different datasets from the same Datasource. See below: There are two tabs (report 1 / report 2) in the…
M.Zubair Akram
  • 131
  • 1
  • 6
5
votes
0 answers

How to make a scatter plot not show all values instead of the top values only?

I have a scatter plot with a timestamp (aggregated by minute) for the X axis and a numerical measure for the Y axis. The plot that I get shows only some of the values, with the text below the visual name saying "showing top 50 in [X] and top 43 in…
Bliblurti
  • 51
  • 1
5
votes
1 answer

Quicksight Dashboard Embed url showing us-east-1 not eu-west-1

Problem: I want to programmatically fetch a quicksight dashboard URL through the SDK, (dashboard in region: eu-west-1) however whenever I use the following regions I get the following errors when I use the following regions: eu-west-1: Error:…
dangarfield
  • 2,210
  • 1
  • 13
  • 18
5
votes
1 answer

How to schedule or automate dataset refresh in aws quicksight

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.
MikA
  • 5,184
  • 5
  • 33
  • 42
5
votes
4 answers

Start week on monday in AWS Quicksight

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 Sunday, and I need it to be Monday. Is there any way to…
Duckslayer
  • 119
  • 1
  • 7
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
  • 381
  • 3
  • 10
1
2
3
…
51 52