Browse through the questions and answers listed below or filter and sort to narrow down your results.
Gradient colors for points on map
I am making a Points on Map visual, and I have a scalar value associated with each point. I want the map to look like a heatmap, where the color of each point is defined by a gradient. Is there a way to do this? When I put the numerical field in the "Color" well, The order of the colors does not make any sense ![Colors without gradient](https://repost.aws/media/postImages/original/IMrL5nTVMYQ5y6NMrpfv0G4g) Is there a way to make the colors reflect a gradient, similar to this visual? ![Map with point colors on a gradient scale](https://repost.aws/media/postImages/original/IMPCviioR4SGecndnSKUpGkg)
Quicksight: Change KPI visualization's Value and Target Value display column name
Hi all, I am setting up several KPI visualizations on my dashboard. I would like to show current value as default value, difference with previous on the left, and previous value on the right. My issue is that I cannot assign generic display names to these values, instead I am forcing to use the column name values. Though, I cannot call all the columns "Previous". Is there maybe a hidden way to chose display names as you would do with a table?
QuickSight DataSource created using boto3 is not able to access LakeFormation data through Athena
I am having issues using boto3 to create Athena DataSources in Quicksight. If I create an Athena DataSource from the QuickSight console I'm able to use it in a DataSet and see my Athena tables (stored in Lake Formation). If create that same DataSource (exact same configuration) using a boto3 client and an assumed role with QuickSight permissions, it is not able to see the LakeFormation tables. What permissions are used by QuickSight to determine the data DataSources access? Do I need to add permissions to my assumed role? I've tried giving it LF tag access and full Athena permissions without any luck. What is needed to access Lake Formation data in QuickSight through DataSources created using boto3? Here are two screenshots to demonstrate what is happening. The DataSources have the exact same DataSourceParameters and Permissions. ![DataSource created in QuickSight can select tables](https://repost.aws/media/postImages/original/IMCAVe36zNSoqjcq2eDfVLhw) ![DataSource created by boto3 can't see any tables](https://repost.aws/media/postImages/original/IMn9qo9RAMT4abKBkwmv94pg)
Accessing via API data of type FILE in QuickSight
Hello, I would like to update a Row Level Security rule by adding a new username using the Quicksight API. All RLS rules were initially created using the console and by uploading a file. Is it possible to update that file using the API? The datasource is set as FILE and i'm wondering if I can access and update that file via API. IF i can't, can I linked a RLS rule to a S3 file which i can update using the S3 api. thank you! G.
Quicksight: Calculation Field - decimal places truncated
I am posting a question which is related to a dashboard development on Quicksight. It includes a calculation field which uses sumover's in a sumover. However, I encountered a problem that Quicksight can't produce accurate result when it take multiplication operations on two float number fields. I am sharing a simple example to describe the problem. As you see, there would be two steps in the calculation. I.e. 1.) sum(cost)/sum(cost2), and 2.) pre-result * 10,000. I suspect the float number is truncated in the first step so that the displayed result is not accurate. ![Enter image description here](https://repost.aws/media/postImages/original/IMeZtCDOpQSkKAgwK-1-Uk7Q) I tried some workaround solutions. E.g. re-write the calculation as sum(cost)*10000/sum(cost2). It seems to be using much a lot computation power; thus, this workaround results in overflow error in my real case. Note: the 10,000 in my real case is not constant.
Quicksight embedding SDK - get dashboard ID
Difficulty understanding QuickSight pricing
I have a public, static website where I want to display embedded QuickSight charts. My data are in s3. I estimate the site will display around a dozen or so charts sprinkled across a few pages. The site is initially a low traffic site, starting at around 50 unique views per day with it hopefully eventually ramping up to 1000 views plus per day. I am the only developer. I'm confused with the pricing model listed in the official [pricing page](https://aws.amazon.com/quicksight/pricing/). I have the following questions: 1. Do public embedded charts and/or dashboards require me to choose the enterprise edition? 2. Is QuickSight really built for public access? Does each unique visitor count as a "reader?" 3. If the answer to the second question on #2 is yes, does this mean each visitor initiates a session? 4. Is QuickSight even appropriate for my use case?
Connecting Users to AWS Athena and AWS Lake Formation via Tableau Desktop using the Simba Athena JDBC Driver and Okta as Identity Provider
Hello, due to the following Step by Step Guide provided by the official AWS Athena user-guide (Link at the End of the question), it should be possible to connect Tableau Desktop to Athena and Lake Formation via the Simba Athena JDBC Driver using Okta as Idp. The challenge that I am facing right now, is although i followed each step as documented in the Athena user-guide i can not make the connection work. The error message that i recieve whenever i try to connect Tableau Desktop states: > [Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. The security token included in the request is invalid. [Execution ID not available] Invalid Username or Password. My athena.properties file to configure the driver on the Tableau via connection string URL looks as follows (User Name and Password are masked): ``` jdbc:awsathena://AwsRegion=eu-central-1; S3OutputLocation=s3://athena-query-results; AwsCredentialsProviderClass=com.simba.athena.iamsupport.plugin.OktaCredentialsProvider; idp_host=1234.okta.com; Useremail@example.com; Password=******************; app_id=****************************; ssl_insecure=true; okta_mfa_type=oktaverifywithpush; LakeFormationEnabled=true; ``` The configuration settings used in here are from the official Simba Athena JDBC driver documentation (Version: 2.0.31). Furthermore i assigned the required permissions for my users and groups inside Lake Formation as stated in the Step by Step guide linked below. Right now I am not able to point out why I am not able to make the connection work. So I would be very greatful for any support / idea to find a solution on that topic. Best regards Link: https://docs.aws.amazon.com/athena/latest/ug/security-athena-lake-formation-jdbc-okta-tutorial.html#security-athena-lake-formation-jdbc-okta-tutorial-step-1-create-an-okta-account)
AWS Quicksight Access - via Amazon Active Directory AND IAM Roles
We are looking to expand services via AWS Quicksight, our use case would include Amazon subsidiary users who can be both in Amazon network and not. My question is it possible to setup new AWS accounts to allow BOTH Active Directory (for in network users) and unique IAM roles (for subsidiary/off-network users)? If not what are the options to allow this type of access using SSO where possible.
Copying a Cross-Source DataSet in QuickSight using the JS SDK