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 parameterise the data connection in Tableau in AWS (cloudformation or otherwise)?

I have a simple web app UI (which stores certain dataset parameters (for simplicity, assuming they are all data tables in a single Redshift database, but the schema/table name can vary, and the Redshift is in AWS). Tableau is installed on an EC2…
charlesperry
  • 105
  • 1
  • 2
  • 7
0
votes
1 answer

QuickSight dashboard in not rendering in iframe

We are trying to render the Amazon QuickSight dashboard in the iframe. We have created the embedded URL and rendered them in the iframe. The dashboard is being rendered in all browser except IE. I am using using IE 11. Is there any way to fix this…
Vamsi
  • 423
  • 1
  • 5
  • 19
0
votes
1 answer

How do I monitor AWS IOT connected devices history and group by shadow state/attribute

Given I have xK Devices, Each of them connect to AWS IoT and each of them have attributes/shadow states to group them device shadow example: { "factory": "factoryA", "pipeInstalledVersion: "1.5.6" } What's the easiest way to monitor these devices…
user3034
  • 115
  • 5
0
votes
1 answer

Can I directly pass string parameter to Quicksight function as argument?

I made a parameter with a custom list of options 'MM', 'YYYY', and 'Q'. When a user selects one, I planned my calculated field to use it as an argument for the extract() function, like this: extract(${period}, date) I tried to omit the quotes,…
Big Chungus
  • 185
  • 1
  • 3
  • 13
0
votes
0 answers

Can I filter a field from the same row as another in Quicksight?

When a user selects the parameter from the control I added to my dashboard, I want to get a specific field from that exact item and filter my data by that. I tried setting up a parameter for one field, and the filter it's connected to for another…
Big Chungus
  • 185
  • 1
  • 3
  • 13
0
votes
1 answer

Integrate Quicksight with Cognito for access via Google login

I have my enterprise Quicksight in place and with users using our company email to register an account (like john.doe@mycompany.com). We're using Gmail for business. On the other hand we have developed another application backed by AWS Cognito user…
Petar Mitrovic
  • 121
  • 6
0
votes
1 answer

Quicksight - How to use log() in a calculated field?

I'm trying to move my BI dashboards from Google Data Studio to Quicksight. In Data Studio, I use a log() function in a calculated fields. My formula is "20 * LOG(SUM(event_count))". How could I do that same calculation on the go with QuickSight…
David Martins
  • 63
  • 1
  • 4
0
votes
2 answers

Calculated field Sub total in pivot table is not displaying correct value

I am working on QuickSight in AWS. I am trying to achieve weighted average value in a Pivot table. I am using SPICE data to create this analysis. I have created a calculate field (WAM) in analysis with formula…
Raju Rudru
  • 1,102
  • 12
  • 19
0
votes
1 answer

We can't parse the SQL syntax message appears in AWS QuickSight after applying Row-level security

Certain reports in AWS QuickSight don't show up anymore after applying Row-level security. Instead of the visualisation a message appears: We can't parse this SQL syntax. If you are using custom SQL, verify the syntax and try again. Otherwise,…
Erik Oosterwaal
  • 4,272
  • 3
  • 44
  • 64
0
votes
2 answers

QuickSight: How can I use ifelse() or any other alternative for multiple conditions according to input provided in the added parameter?

I get the option of ifelse() in the Functions list when I am trying to add a calculated field while editing the data, but do not get it from the 'Add' option where I get the option to Add title, Add description, Add calculated field, Add parameter.…
Shristi Sinha
  • 1
  • 1
  • 2
0
votes
2 answers

Is it possible to duplicate a visual in Amazon Quicksight?

I would like to duplicate visuals in Amazon Quicksight. I have multiple charts that I need that all have very similar formatting but different data driving them. I would like to be able to duplicate a visual inside of an analysis with all of its…
Stephen
  • 3
  • 4
0
votes
1 answer

Can't connect QuickSight to SQL Server - "Your database generated a SQL exception" error

Someone having the same error while trying to connect to Quicksight from SQL Server? Any thought of what might be wrong? Obs: I Have view only user with remote access.
ADrex
  • 105
  • 3
  • 16
0
votes
1 answer

embed quicksight dashboard : (AccessDeniedException) when calling the RegisterUser operation

I am trying CLI based command to embed QuickSight Dashboard as per this link quicksightembed and this AWS Video AWSQuickSight . CLI Command : aws configure aws sts assume-role --role-arn "arn:aws:iam::842034702001:role/QuickSightEmbed"…
string
  • 787
  • 10
  • 39
0
votes
1 answer

How to add parameter to QuickSight dataset

I'm very new to QuickSight. trying to move SSRS reports to Quicksight.the reports contains parameter which I'm creating SQLServer function and call it in quickSight with a sample parameter. (Or use Custom SQL with the parameter value). but anytime…
Sara N
  • 1,079
  • 5
  • 17
  • 45
0
votes
1 answer

Sumif in AWS QuickSight?

What is the alternative for sumif (Excel formala) in AWS' QuickSight? I need a column, that will horizontally scan the first column and show sum for the identical categories. Please see example:
Oksi
  • 101
  • 3
1 2 3
…
51 52