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
2
votes
1 answer

Amazon Quicksight adding new field to dataset

Hi I have been looking for some time to an answer to this but I really can not find one. I have a dataset that is build from an S3 file. this s3 file gets updated everynight and the dataset is refreshed soon after. All the above works as you would…
Alistair Prestidge
  • 673
  • 3
  • 9
  • 19
2
votes
0 answers

Is there a way in Quicksight to set dynamic titles on the visuals?

I have a requirement to translate our Quicksight dashboard. We are currently configured a "language" parameter which contains the language user desired to see the dashboard in. We are using this parameter to filter the data in our data set which has…
barnesm999
  • 421
  • 3
  • 13
2
votes
0 answers

Amazon Quicksight - how to calculate Percentage of Total UNIQUE values?

How to calculate percent of count of UNIQUE values? E.g. I have a dataset with people who can pick multiple symptoms (i.e each person can have 0 to 10 values). person 1 - symptom A, B person 2 - symptom B, C, D person 3 - no symptoms person 4 -…
MDXdoesmyheadin
  • 21
  • 2
2
votes
1 answer

InvalidParameterValueException when trying to register a new QuickSight user

I'm trying to register a new QuickSight user with the following command: aws quicksight register-user --identity-type IAM --email email@email.com --aws-account-id ${AWS_ACCOUNT_ID} --user-role READER --namespace default But I'm getting the…
Bonifacio2
  • 3,405
  • 6
  • 34
  • 54
2
votes
5 answers

Cloudformation for quicksight

I'm trying to build cloudformation template for Quicksight but there are no good examples to refer.Anyone with experience in creating cloudformation for Quicksight can you please let me know how can I start with CFT for quicksight
Abhishek Hc
  • 31
  • 1
  • 2
2
votes
1 answer

Extracting CSV from Quicksight dashboard using Python

I can manually access some Quicksight dashboards and hit "export to CSV", but I want to automate that task (as it is the first of many steps to updating some reports). Can this be done automatically using Python? Note: I did not create the…
disjunctive
  • 41
  • 5
2
votes
1 answer

Running distinct count in quicksight

I want to implement a running distinct count with Amazon Quicksight. Here's an example of what that would look like: Date ID Amount Running Distinct…
rwpurvis
  • 23
  • 5
2
votes
0 answers

Visualize KPI with Trend in Quicksight

I want to create a KPI Metric in Quicksight that takes the sum of "Views generated" over a custom period of time. The period is entered within parameters and passed to a filter (e.g. Parameter DateFrom: 2021-03-06; Parameter DateTo: 2021-03-10).…
daniel
  • 1,002
  • 13
  • 22
2
votes
2 answers

Percent Calculation in Quicksight

I want to calculate percent based on count of events. Basically, I want to calculate successful login attempts on a website. Something like below count(successful_attempts)/count(total_attempts) successful_attempts and total_attempts are recorded as…
Trinkets
  • 21
  • 1
  • 2
2
votes
1 answer

Need input on calculated field formula with if else condition in AWS Quicksight

So, I have a use case where I need to calculate the monthly costs of my clients Quicksight usage. If the user has an 'Author' role the cost is fixed to 18$ per month. If the user has 'Reader' access, it costs 0.30cents for 30 minutes for the first…
Harish J
  • 146
  • 1
  • 3
  • 12
2
votes
1 answer

QuickSight cannot see cross-account Athena DB

I have QuickSight set up in account_a in eu-west-1. I am attempting to query from Athena which is in account_b. I have two databases [one is "default" and another one with another name] in Athena, both under the same AWS Glue catalog. The catalog…
ahmetyv
  • 51
  • 6
2
votes
1 answer

SQL SELECT avg of columns from multiple tables

I have a SQL query now that produces a table that looks like this: Demographic Month Week Usability Session 2 10 5 7 9 This is the query: SELECT avg(cast(d.duration as bigint)) as "Demographic", avg(cast(m.duration as bigint))…
Cami
  • 97
  • 7
2
votes
1 answer

Amazon QuickSight - How to "Show relevant values only" with input parameter not in a control

I want to filter the content of a control to relevant values based on a filter applied to the dashboard. The filter is based on a parameter passed in via the JS SDK. If I have a control (Control X) setting a parameter used by a filter then it…
JosephQuail
  • 23
  • 3
2
votes
3 answers

Can not access Glue table from Quicksight

No tables are found when creating data source. If Custom sql is selected I get error - Insufficient permissions to execute the query. Insufficient Lake Formation permission. My quicksight service role has all permissions. My user console role has…
noobCoder
  • 292
  • 2
  • 17
2
votes
3 answers

Import data (arrays) to Quicksight

How can I import arrays data into Quicksight from Postgresql? For example {1,2,3,4,5}. I tried to import all data into Quicksight but it doesn't recognize the arrays. However, if I download as csv from Postgresql and then import local csv file to…
Leo
  • 29
  • 2
1 2 3
…
51 52