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.
amazon-quicksight
759
questions
0
votes
0
answers
7
views
Creating a Comparative Performance Analysis Table with Filters in AWS QuickSight
I am a beginner in using Amazon QuickSight, and I have a dataset containing information about tasks performed by groups, including a performance score for each task. My goal is to create a table that ...
0
votes
1
answer
30
views
Error while fetching data from mongo to QuickSight using Athena (COLUMN_NOT_FOUND Error)
We use Amazon QuickSight to analyze data from MongoDB.
The custom query in our dataset works perfect:
SELECT _id, label, structure, createdAt, deleted
FROM docdb.label_db.labels
We have added a ...
-2
votes
0
answers
12
views
How to get YTD numbers in quicksight dashboard
This is my data using which I want to achieve YTD sum by selecting single date in the filter.
e.g. Add date parameter on Month1 when I choose 1-May-2024. it should give sum as (Current YTD (1-Apr-24 ...
0
votes
0
answers
33
views
How to deal with tenant architecture within Redshift and AWS?
I am trying to design and build Data Reporting Platform.
Data sources
7 PostgreSql databases with different schemes and data.
Mixpanel, accessed via API
We are trying to migrate all data to Redshift,...
1
vote
0
answers
35
views
Amazon QuickSight - Input Manifest does not contain any valid URIs
I am creating a new data source from an S3 bucket for a QuickSight analysis, which is in another account. When I upload a manifest.json that contains URIPrefixes, I get the following error:
We can’t ...
0
votes
1
answer
9
views
How to calculate calculated field and the non-calculated field in Quicksight
I’m hitting problem that can not calculate calculated field and non-calculated field.
I want to calculate cpa of advertisement.
So i made the below formula.
{advertisement_budget} / countIf({id[...
0
votes
0
answers
19
views
Fixed Start Date with Dynamic End Date Filtering in Table Visual in QuickSight
The task is to create a calculated field in Quicksight where,
A fixed start date that remains constant, regardless of the date filter selection. This could be the company's inception date or any ...
0
votes
0
answers
24
views
AWS: Glue Crawler + QuickSight
I have a batch application that creates a csv file everyday with the "transformed-dd-mm-yyyy.csv" format file name. Every file has name, price and some other fields but that's what I am ...
0
votes
1
answer
35
views
How to disable an AWS Quicksight dataset or analysis?
Is it possible to disable the nightly refresh of a QuickSight dataset and/or its corresponding analysis? It would be unfortunate if the only way to do this is to delete the whole thing from the app.
0
votes
0
answers
27
views
Extract AWS Batch and CloudWatch data for Amazon QuickSight?
I am trying to make a dashboard using data from CloudWatch logs. On AWS Batch, I have a job queue (I'll call this A). On this queue A, I have some jobs that succeeded and some jobs failed. When I ...
0
votes
0
answers
26
views
AWS Quicksight - How to Dynamically update the data based on the filters
New to quicksight. I have a filter in my table called Start Date and a calculated field called Total Hours.
How can I update either of these fields/filters for the Total Hours in my table to be ...
0
votes
0
answers
31
views
How to get rid of the expansion/collapse buttons from all columns starting from the second column in pivot tables(i just need it in the first column)
image
please check the image above. i want to get rid of the (-) buttons from col 2, col 3 and starttime. is that possible?
I know it is possible if we have decimal or integer based columns, we can ...
0
votes
1
answer
49
views
Looking solution to handle big query for reporting data from AWS Aurora Postgresql
I am having a AWS Aurora Postgresql Cluster with an Severless instance as Primary instance and a Provisioned Instance as Replica instance. Primary instance will serve query from Application only and ...
0
votes
0
answers
73
views
Overriding the default Athena schema with AWS Quicksight start-asset-bundle-import-job API via CLI
I have two aws accounts with an AWS QuickSight dashboard in my source environment and am trying to copy that dashboard to my target environment on the other account. I have identical Athena databases/...
1
vote
0
answers
67
views
Can't add multiple sheets when creating aws_quicksight_analysis using terraform
Need to create more sheets in quicksight.
When I create a aws-quicksight-analysis using terraform, this shows up in the quicksight console:
I do not have the option to add more sheets. When I create ...