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

How to connect Hive/Presto via JDBC to Amazon QuickSight (SPICE)

I would like to connect a Hive/Preso query engine within AWS to Amazon QuickSight (SPICE) to query the data. Usually I would use JDBC (https://prestodb.io/docs/current/installation/jdbc.html) for this. Is this already possible? Or is there another…
vanderGoes
  • 3
  • 4
0
votes
2 answers

Aggregation calculations on aws quicksight

I am exploring Quicksight as BI UI. There are some required calculations that I am after and I couldnt find how can they be done. How would you implement "count distinct" ? How would you present an amount as percentage of total or of previous item…
N.N.
  • 3,094
  • 21
  • 41
-1
votes
1 answer

How to calculate sum distinct in quicksight

Partner UserID Marks Group A 1 4 AM A 2 7 AM A 1 4 AM B 3 5 CM C 4 6 TM B 3 5 CM I want to calculate sum of 'Marks' for each partner excluding double rows. I've tried (sum(maxOver(Marks, [UserID, Partner], PRE_AGG))). But it's…
Shan
  • 1
-1
votes
1 answer

AWS - DynamoDB table visualization

Please what is the best or recommended way how to visualize data from the DynamoDB table ? We need to create some simple dashboard with graphs connected to data table on the AWS account. We prefer to use one of the services from AWS to keep…
Lukáš Imrišík
  • 23
  • 2
-1
votes
1 answer

Is it possible to create a field well with the numbers 1-100 in?

I am currently creating a pivot table in Quicksight which I am looking to create a Field Well with a series of numbers from 1 to 100. They should be static and not effect the data in the table though. I have managed to do this in PowerBI before…
user2136437
  • 1
  • 1
  • 4
-1
votes
1 answer

AWS Quicksight monthly summarize in percentage from different csv files

1. I have a Lambda function that is running monthly, it is running Athena query, and export the results in a CSV file to my S3 bucket. 2. Now i have a Quicksight dashboard which is using this CSV file in Dataset and visual all the rows from the…
hightest
  • 395
  • 5
  • 15
-1
votes
1 answer

How can we Migrate tableau analysis to Quick Sight

I imported one csv file inside the tableau desktop and added the calculated fields and analyze the same data with different visual types, now my requirement is how can i migrate tableau analysis inside the Quick sight with out any changes.
Abhilash Narayan
  • 1
  • 1
-1
votes
1 answer

Synthetic timestamp pandas

I need to add a timestamp to a dataframe with the following settings: from datetime import datetime date_rng = pd.date_range(start='1/1/2020', end='1/21/2020', periods=len(df)) I would like to know how to discard the miliseconds terms since I need…
Itzy Death
  • 15
  • 2
  • 6
-1
votes
1 answer

How to use RLS with compund field

In Redshift we have a table (let's call it entity) which among other columns it has two important ones: hierarchy_id & entity_timestampt, the hierarchy_id is a combination of the ids of three hierarchical dimensions (A, B, C; each one having a…
Luis Miguel Mejía Suárez
  • 21,686
  • 3
  • 28
  • 45
-1
votes
1 answer

How to create visualization using ratio of fields

I have a data set similar to the table below (simplified for brevity) I need to calculate the total spend per conversion per team for every month, with ability to plot this as time based line chart being an additional nicety. The total spend is…
Harish
  • 1,433
  • 9
  • 21
-2
votes
3 answers

How can update a resource made outside of terraform via terraform?

AWS Quicksight has a built in default role aws-quicksight-service-role-v0 which does not have any policy attached to it. Knowing its ARN, I want to attach policies to the role via terraform. How can I achieve this? In other words, how can I import a…
DragonKnight
  • 1,740
  • 2
  • 22
  • 35
-3
votes
1 answer

How to embed quicksight dashboard into React application

enter image description hereHow to integrate amazon quick sight in to react application 1.how to import aws-sdk 2.where to get the dashboard ID
karthikeyan raman
  • 1
  • 1
  • 3
-3
votes
1 answer

Can I create AWS Quicksight dashboard programmatically?

I want to create the dashboard dynamically using dynamic MySQL query. Is it possible?
Chirag Patel
  • 3
  • 5
-4
votes
0 answers

Can an SQLite database be stored in AWS S3 and the data visualized by AWS Quicksight?

I am working on a project which generates an SQLite database. I plan to build some cloud infrastructure, and store and visualise the data in AWS. The database consists of a single table of <10 columns, and a few thousand rows. The most popular…
vile_goat
  • 13
  • 6
1 2 3
…
51
52