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

Quicksight Input column types other than STRING invalid on dataset creation

When trying to automate dataset creation in Quicksight through importing a CSV from an S3 bucket, I get an error when trying to create a data set by calling the createDataSet() method from the Java…
Nick
  • 31
  • 1
3
votes
2 answers

QuickSight not showing DataSource created with API

I've recently started looking into creating dashboards and analysis with the Quicksight API. I tried creating a datasource using the AWS SDK, the response was successful and I was also able to double-check this by calling a describe on the…
Derrick Feehi
  • 63
  • 1
  • 5
3
votes
0 answers

Quicksight joins in datasets duplicating records

I'm new to Quicksight (having used PowerBI for years) and am struggling to understand why relationships in datasets are always treated as JOINs and not related tables. It makes calculations very difficult. For instance, if I have two tables in a 1:M…
dmarx
  • 43
  • 1
  • 4
3
votes
1 answer

Amazon QuickSight embedded dashboard - how to cache user session in my webapp (billing and timing concern)

I have embedded Amazon QuickSight dashboard in my web application by using amazon-quicksight-embedding-sdk (followed https://learnquicksight.workshop.aws/en/dashboard-embedding.html). The user session seems to last many hours as mentioned in…
Mako
  • 123
  • 9
3
votes
2 answers

How to connect to REST API as datasource in AWS QuickSight for creating Reports?

Just wanted to know how to connect to REST API as datasource in AWS QuickSight for creating Reports and Dashboards? If not in case of any alternative approach or related links to that would be more helpful! Thanks in Advance! - Vicky!
Vicky
  • 115
  • 1
  • 10
3
votes
1 answer

Sort stacked graphs in the y axis

I'm using a stacked graph in AWS quicksight and I need to be able to sort by Cost vertically. The only option I see is to sort by Cost horizontally making the dates appear out of order. By default it's sorted A-Z vertically. How can I get the larger…
mRyan
  • 332
  • 4
  • 18
3
votes
1 answer

My Amazon Quicksight dashboard does not load. The dashboard is using a SPICE dataset

I have dashboards in AWS QuickSight that use Spice datasets. Occasionally the dashboards do not load data (they seem to refresh forever and never load the data). Refreshing/closing the browser doesn't seem to help. Eventually the dashboard will load…
sgn
  • 125
  • 2
  • 10
3
votes
1 answer

AWS QuickSight Embedding Dashboard Throws Errors/Warnings in Chrome and Firefox

I have successfully generated a QuickSight Dashboard url but when I try to use quicksight-embedding-sdk to embed my dashboard in my Amplify app the div containing the embedded dashboard will not display the dashboard but instead an error. In Chrome…
av0000
  • 1,917
  • 6
  • 31
  • 51
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
  • 436
  • 4
  • 9
3
votes
1 answer

Copy AWS quicksight data sets and dashboards over multiple data sources

We have multiple data sources with the exact same data model (one instance for each customer). We are using AWS Quicksight to create dashboards to view the data. We want to be able to clone or copy one dashboard created on one data source to a new…
Jorjani
  • 827
  • 1
  • 16
  • 31
3
votes
1 answer

QuickSight sync colors across multiple visuals

I am trying to sync the colors for visuals and am running into some challenges. I have for example a vertical stack bar chart with group by source (so the bar displays multiple client revenue with the aggregate being total revenue). I have a second…
user13907376
  • 31
  • 1
3
votes
2 answers

Show daily count and the total count up to that day in Quicksight

I want to create a table analysis in AWS Quicksight that shows the number of new user per day and also the total number of user that has registered up until that day for the specified month. The following sample table is what I want to achieve in…
Wisnu Shin
  • 81
  • 3
  • 6
3
votes
1 answer

how to use runningSum in AWS QuickSight

I am encountering the following error when running clearting a calculated field: runningSum(sum(user_count),[date_created ASC],[]) to get the running total of created I have tried to add the '{}' on the fields, and no luck. How can I get this…
trackstarz408
  • 73
  • 1
  • 7
3
votes
2 answers

Convert timestamp field to Date String in Amazon QuickSight

I am trying to do customer behavior analysis in AWS Quick Sight. One of the data fields is a timestamp e.g. 20200219215336. I want to cast this field to a date-time string e.g. 2020-02-19 21:53:36.0 UTC (+00:00). I tried to change the data type to…
Vikas Roy
  • 854
  • 2
  • 10
  • 25
3
votes
1 answer

AWS Quicksight - MySQL UNION from multiple databases

I'm using AWS Quicksight for an Analytics dashboard and I have multiple databases that have the same tables. I then set a Data Source for each database. Now, I've been trying to create a Data Set for a table, let's say "products" table, which should…
xtan
  • 41
  • 1
  • 3
1 2 3
…
51 52