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
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
  • 324
  • 1
  • 4
  • 12
4
votes
0 answers

Find the length of an array / comma separated string values in Quicksight Calculated Field

I have a column of sent_to_emails in my Quicksight Dataset. I want to calculate the number of values in this comma separated string i.e. split the string based on a delimiter and then calculate the number of values returned in array.…
4
votes
1 answer

AWS Quicksight not able to see athena db

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 verified that the quicksight location (us-east-1 N.…
4
votes
0 answers

Amazon QuickSight - Adding Custom Visual Content Using boto3 or aws-cli

Is it possible to add a custom visual content to an existing analysis using either boto3 or aws-cli? If yes, how to do it?
Naga Vijayapuram
  • 845
  • 7
  • 11
4
votes
2 answers

Is there any way to get day from date in quicksight?

I am trying to get day from date field in quicksight. Following is date format in quicksight: 2020-09-29T00:00:00.000Z I want some function which will parse the date and give the day from this date. i.e., Tuesday
Rushabh Sudame
  • 414
  • 1
  • 6
  • 22
4
votes
1 answer

Large data line chart in aws quicksight

I am trying to visualize data in AWS quicksight by using a simple line chart. The chart display only the top 200 points and not the full data range which is connected to the analysis Is there anyway to display a full line chart of the data? Is there…
shahar zidon
  • 127
  • 2
  • 8
4
votes
0 answers

Audit Logging for AWS QuickSight

Newbie to AWS quicksight. Have a requirement to track Non-API Events for QuickSight . My requirement is to track events around the QuickSight Dashboards events and see which of the dashboards are having maximum hits…
4
votes
1 answer

QuickSight could not generate any output column after applying transformation Error

I am running a query that works perfectly on AWS Athena however when I use athena as a data source from quicksight and tries to run query it keeps on giving me QuickSight could not generate any output column after applying transformation error…
haneulkim
  • 4,406
  • 9
  • 38
  • 80
4
votes
0 answers

Testing Amazon Quicksight Implementation

My organisation are looking to move to Amazon Quicksight to replace our existing reporting solution. As part of the review before we move I have been asked to investigate the options for creating automated tests for the Quicksight implementation,…
Richard C
  • 513
  • 1
  • 7
  • 26
4
votes
1 answer

"'userArn' failed to satisfy constraint: Specified Resource is not reachable in this region" when requesting quicksight embed URL

I am attempting to embed a Quicksight dashboard in a web-app and have been using this amazon-quicksight-embedding-sample to get up and running. I followed all the instruction in the README and have the code running in my AWS lambda function. When I…
4
votes
2 answers

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
  • 4,136
  • 5
  • 30
  • 47
4
votes
3 answers

How to get/generate aws quicksight secure dashboard url

I want to embed Quicksight dashboard to an application. I have gone through the AWS quicksight documents, I did not get where I will find secure signed dashboard url.
user2486706
  • 167
  • 1
  • 2
  • 10
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
  • 3
3
votes
0 answers

Can you describe sheets and or visuals using the AWS Quicksight API?

After writing some code to extract information about Dashboards, Analyses, Datasets and Datasources from AWS Quicksight using the QuickSight API (Allowing for full text search on objects and queries in use, and allowing for change-detection), I…
Bart Jonk
  • 365
  • 3
  • 14
3
votes
2 answers

Year-over-Year Quicksight Line Chart

I am looking for a way to do a year-over-year line chart for comparing values at the same time frame (day/week/month) compared to the previous year. When looking for examples I am seeing a lot of line charts with an x-axis with values looking like…
1 2
3
51 52