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
5
votes
3 answers

Using aggregation within a calculated field in Amazon QuickSight

I'm using Amazon QuickSight and want to create a calculated field which in Tableau would be sum([Field1])/sum([Field2]). In QuickSight, I attempted sum({Field1})/sum({Field2}) but this did not work ("We encountered an error trying to save your…
Greg
  • 314
  • 4
  • 12
5
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
  • 1,633
  • 3
  • 16
  • 48
4
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
  • 950
  • 12
  • 26
4
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
  • 71
  • 5
4
votes
2 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
  • 103
  • 1
  • 1
  • 4
4
votes
1 answer

How QuickSight SPICE refresh the data

I have a Quick Sight dashboard pointed to Athena table. Now I want to schedule to refresh SPICE every hour. As per documentation, Refreshing imports the data into SPICE again, so the data includes any changes since the last import. If I have a 2TB…
lucy
  • 2,650
  • 4
  • 17
  • 36
4
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…
Nibroc A Rehpotsirhc
  • 324
  • 2
  • 13
4
votes
2 answers

Sumover in QuickSight

I am trying to use the Sumover table calc in QuickSight (link that this is possible: https://docs.aws.amazon.com/quicksight/latest/user/sumOver-function.html) in order to show a sum total for the week while still displaying the data at the daily…
Sam G
  • 41
  • 1
  • 2
3
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
  • 47
  • 4
3
votes
0 answers

Running a custom SQL in AWS Quicksight using PostgreSQL as a data source

I am trying to run a custom query to visualize in Quicksight. I have tested my query using JetBrain's DataGrip, but failed to return the result in Quicksight. I, then, realized that some SQL functions cause error in Quicksight. I have run these…
Cem
  • 51
  • 6
3
votes
1 answer

Quicksight refreshing Anomaly dashboards for real time data

Currently AWS QuickSight has an option to refresh the Dataset from S3 using scheduled refresh. Once the data is refreshed, normal dashboards (visuals chart) gets updated with new data. For Anomaly dashboards (insights chart), currently if the data…
Arvind Purohith
  • 31
  • 4
3
votes
1 answer

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 default…
Jon Guiriba
  • 31
  • 3
3
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
  • 453
  • 5
  • 14
3
votes
1 answer

Does AWS S3 Manifest File Support Parquet Format?

According to this AWS documentation it appears that AWS S3 does not support parquet format in the manifest file but I find this hard to believe because that's a very common file format that's used and for Athena/Redshift you are supposed to use…
Kyle Bridenstine
  • 4,285
  • 5
  • 42
  • 83
3
votes
1 answer

Using API to work with AWS Quicksight

I'm trying to figure out if there are any ways to integrate part of the AWS Quicksight service into our web application or site. Are there any support for embedding parts of the service in an web application or site? Or are there any support for…
Ole
  • 41
  • 8
1
2
3
…
30 31