Questions tagged with Amazon QuickSight
Content language: English
Sort by most recent
Weekly Data metrics
Hi All, I have access to the dataset of around 2 years of Data. I am trying to truncate the information only specific to the weekly data from it.I have tried truncate date to take only the data specific to the last week but its not working .Let me know the calculated fields to be used in the quicksight to update the automatically each week. The data will be changing automatically in the back end
How to create Quicksight Analysis & Template in CDK
I would like to create new Quicksight Analysis & Template in CDK (python): I'm trying to do it with [CfnAnalysis ](https://docs.aws.amazon.com/cdk/api/v1/python/aws_cdk.aws_quicksight/CfnAnalysis.html)class & [CfnTemplate](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-quicksight-template.html) the problem is with SourceEntity parameter in both classes. Both of them required to provide arn of each other, but during CREATE_IN_PROGRESS only one of them is ready, so I get an error "Resource of type 'AWS::QuickSight::Analysis' with identifier 'CfnAnalysisId' was not found." I can skip in CfnTemplate parameter SourceAnalysis and give instead SourceTemplate with arn of existing template but then when I try to use this template to create a Dashboard I receive another error: "Given placeholders [placeholder] are not part of template". This is correct but placeholder parameter is part of "SourceAnalysis" parameter so back to the original problem. In conclusion, I would like to use CDK to create a new template and a new analysis, both objects need each other, so how can this be done?
fips-us-east-2.quicksight.aws.amazon.com refused to connect.
Hi All, I use Quicksight Embed for my customers. Everything has been working perfectly, but all customers are down as of this morning and receiving this error message "fips-us-east-2.quicksight.aws.amazon.com refused to connect." Is there a way for me to test to see if the issue with with the API?
Why does import fail with Jira data to QuickSight?
I've generated an API token for our Jira board on our Atlassian account. After going on [New Dataset] -> [Jira] in QuickSight, the connection is validated after entering the API token. But this message appears even though I am an admin: "The SaaS isn’t available. The URL might not be accessible, or the instance might not be available. You can check the service and try again. Contact your data source administrator for assistance."
Outliers in boxplots (QuickSight)
I am using boxplots in AWS QuickSight. When I tick "Show outliers" under "Format visual", not only the outliers are shown, but also the shape of the boxplots change. 1. Are the calculations of the boxplots different when selecting "Show outliers"? 2. How is an outlier defined by QuickSight? And can I change this outlier definition?
Displaying flight routes on Maps in Quicksight
Given specific geospatial points for a route (e.g. a flight route), can we show the route on a map through Quicksight? (similar to what can be done in plotly: https://medium.com/technology-hits/working-with-maps-in-python-with-mapbox-and-plotly-6f454522ccdd)
Row is not a valid JSON Object - JSONException: Expected a ',' or '}'
[Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. Row is not a valid JSON Object - JSONException: Expected a ',' or '}' at 149 [character 150 line 1] [Execution ID: fd5f862a-7558-4329-93df-08ba753e7ee1]
while importing s3 data into quicksight from glue database getting the following error
HIVE_PARTITION_SCHEMA_MISMATCH: There is a mismatch between the table and partition schemas. The types are incompatible and cannot be coerced. The column 'attributes' in table 'clickstream-ctr-database.care_events_dev1' is declared as type 'struct<aid:string,kvstriggerlambdaresult:string,sak:string,savecallrecording:string,sst:string,startstreamingaudiostatus:string,transcribecall:string,getlang:string,getaeroplanno:string,getemergency:string,getholiday:string,getlanguage:string,getlanguageselected:string,getpin:string,getpriority:string,language:string,userlanguage:string>', but partition 'partition_0=ctr/partition_1=2022/partition_2=04/partition_3=04/partition_4=12' declared column 'attributes' as type 'struct<getaeroplanno:string,getemergency:string,getholiday:string,getlanguage:string,getlanguageselected:string,getpin:string,getpriority:string>'.
Connecting OpenSearch to QuickSight
I'm trying to connect AWS OpenSearch to QuickSight and export data to SPICE, but I get ELASTICSEARCH_CURSOR_NOT_ENABLED exception. I was not able to find how to enable cursor for opensearch distro 1.1 - region:eu-west-1 - timestamp:1649003264494 - requestId:95b8a137-9839-453c-affc-f50c0e32ae4e - sourceErrorCode:ELASTICSEARCH_CURSOR_NOT_ENABLED - sourceErrorMessage:The domain monei-prod has not enabled cursor.
A way to backup personal Quicksight dashboards/assets
I would like to park my personal Quicksight account (enterprise billing) so that I am not billed while it is inactive. Is there a way to backup Quicksight dashboards/assets, import formulas, visualizations, other metadata, etc? Or is the only way to reduce the billing is to discard and lose all experiments?