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

How can I display a simple table in a report in Amazon Quicksight?

I've been evaluating amazon quicksight recently, and it doesn't look like there is a way to create a report that contains a simple table of data. While I expect I'll mostly be using it to create visualizations, I do also want some simple tables in…
adavea
  • 1,535
  • 1
  • 19
  • 25
2
votes
0 answers

Quicksight calculated filed displayed total wrong

i am using a pivot table in quicksight. I have three value columns - count, col a, [col a/ count]. third column is a calculated field with formula col a / count. The total shown at the bottom of the table is wrong as it shows division of all [col a]…
Ashish Kumar
  • 59
  • 3
2
votes
1 answer

How to apply filter in quicksight so that it scans only applied filter?

I am using Athena as data source in quicksight. How to apply filter on a column so that it scans only those ? I have created a table in Athena as table1. And I have used partition projection on (event_date date) . The partition projection is…
Chaurasiya
  • 138
  • 7
2
votes
1 answer

Connecting RDS to quicksight throws `GENERIC_SQL_EXCEPTION`

I have a RDS PSQL14 database on eu-central-1 and would like to connect this to Quicksight as a new data source. However, I always get the following error: sourceErrorCode: GENERIC_SQL_EXCEPTION sourceErrorMessage: The authentication type 10 is…
Peter Toth
  • 678
  • 6
  • 23
2
votes
2 answers

Password rotation strategy for snowflake when using multi-tenant tables

We are using snowflake database and we have created multi-tenant tables. We have created user-name and password for each tenant. These user-name and password are used in applications that use AWS quicksight and microsoft power bi tool. These…
user3822232
  • 141
  • 1
  • 8
2
votes
0 answers

AWS Quicksight - Display the username in the report

I would like to know if in AWS Quicksight there is a way to display the username that is logged in within the report. I was able to put dates or some other filters, but still no username. Something like this (This is Tableau):
Hello World
  • 207
  • 1
  • 12
2
votes
0 answers

How to add a comparison against last time period in Quicksight

I'm trying to create a dashboard where I want to showcase a KPI value for a month along with a comparison with the previous month. I have used the KPI visual for this. I have also added a date filter where users can select a time period. However,…
Shreyas Nayak
  • 21
  • 1
2
votes
0 answers

RDS Data Source Validation timeout Amazon QuickSight

I am trying to connect an RDS database with postgreSQL engine to Amazon Quicksight in AWS. I have followed the documentation below: https://docs.aws.amazon.com/quicksight/latest/user/rds-vpc-access.html this link is for Manually enabling access to…
Sri Harsha
  • 21
  • 1
2
votes
3 answers

Renaming value names in AWS Quicksight

Is it possible to rename value names in AWS Quicksight without renaming the field in the source dataset? For example below I would like to rename the 'Amount' value to 'Sales' for this visual only.
Adam
  • 21
  • 1
  • 2
2
votes
0 answers

Is there an api available to configure/trigger or create new scheduled incremental refreshes for AWS Quicksight datasets?

I have a requirement where I need to refresh my dataset programmatically every x minutes. Now this value of x could change based on some other parameters like how frequently new data is coming or based on user activity on dashboards, decided by…
Akhil Raj
  • 21
  • 2
2
votes
2 answers

QuickSight count new invoiced users per month

My dataset is a list of user invoices. I can easily show how many invoices I have per month (aggregate the invoice date per month). Now how can I show per month how many new users are invoiced? Let's say I have the following…
D0m3
  • 1,471
  • 2
  • 13
  • 19
2
votes
2 answers

Amazon QuickSight - Display number

I am trying Amazon Quicksight but I don't understand if this is possible. I should display a number that is calculated: [(a-b) / c] a - is chosen from a list of data in the column A b - is the mean of the column B c - is the mean of the column…
user1149727
  • 61
  • 3
2
votes
0 answers

How to use sum or sumif in an "ifelse" aggregation

I am using Amazon QuickSight and having troubles calculating a field in a table. I need to use an "ifelse" aggregation where the "if" and "else" are sums of other fields in the table. I keep getting the following error and don't understand how to…
GB_J
  • 21
  • 2
2
votes
1 answer

Is there a way to add the date time stamp for the data refresh in AWS QuickSight dashboard?

Is there a field or formula I can add to a narrative in QuickSight that will allow me to show the date/time the backing data was most recently refreshed automatically?
Awsdater2
  • 21
  • 2
2
votes
1 answer

AWS Quicksight calculated field average

Hi I am having trouble with this calculated field. I am trying to get the sum of money_val for each customerkey. Then I want to have a KPI visual to show the average money_val. I found that PRE_AGG and PRE_FILTER gave wrong values so I want to use…
Scott
  • 121
  • 1
  • 2
  • 9
1 2 3
…
51 52