Questions tagged with Amazon QuickSight
Content language: English
Sort by most recent
I'm evaluating different BI solutions and I have a specific requirement.
Our setup has *multiple DS with the same schema*, e.g. Customer1DB, Customer2DB, etc.
**Can multiple DBs ingested all in the same dataset?**
Hello,
When creating scheduled email reports on Quicksight there used to be an option to optimise the email report for viewing on a mobile device. Since the update I cannot seem to find that option. I found this page: https://docs.aws.amazon.com/quicksight/latest/user/subscribing-to-reports.html which says click the reports icon when viewing a dashboard to find the option, however I cannot seem to find this icon. would anyone be able to point me in the right direction?
Thank you,
Harry
For each record, I would like to calculate the time difference between that record date and the most recent previous record for that user. The goal is to calculate the number of days between user logins.
I was able to identify the last action date using the lag function:
```
Date of Previous Action (Tenant) = lag({action date [master]}, [{action date [master]} ASC], 1,[{tenant [master]}])
```
I think calculated the number of days between the current action and the previous one:
```
dateDiff({Date of Previous Action (Tenant)},max({action date [master]}),"DD")
```
I then obtained the following results:
I am looking for a way to assign the number of days between actions for that user to each record, but I cannot figure out a way to do this. Does anyone have any suggestions?
Thank you so much in advance!!
Quicksight has a nice menu driven function to join two tables on multiple keys, and to exclude fields and filter the data. **But the saved datasets in SPICE cannot be downloaded. Can this feature be added by AWS?** You can create a table visualization for download but the problem is that you have to manually add each field from the dataset to the table visualization one at a time - and the displayed order is alphabetical instead of the original dataset order. (This ordering could be another fix that would resolve the problem). Or is it possible to use a Quicksight API to fetch the data from SPICE? Other options?
Hi
I am trying to remove AWS RDS Cloudformation Stack but Quickight subnet and security group are causing the delete to fail. Does this mean I should remove the subnet and the security group? If I do would Quicksight data and configuration not be affected?
Hi,
i have a table in Athena which has 'testcase' and 'tags' fields. here is the sample records of the table:
* testcase1 has tags 'tag1,tag2,tag3'
* testcase2 has tags 'tag2,tag4'
* testcase3 has tags 'tag2'
* testcase4 does not has tags
I want to get all the tags from this table in QuickSight
* tag1
* tag2
* tag3
* tag4
i've tried with adding new dataset from Athena and choose Use Custom SQL option, using STRING_SPLIT function, but cannot make it work.
Can you please help me with the sql query?
Many Thanks,
Yj Liu
Hello,
since a couple days all of my datasets in Quicksights with a connection to Salesforce won’t refresh anymore.
The error message states that the OAUTH token is not valid anymore but so far I haven’t found a solution to refresh it.
In Quicksights useremanual it says that you can’t edit a Saleforce connection.
In one of my attempts to fix this problem I recreated the data source and loged in to Saledforce again. That worked for a couple days until the OAUTH token expired again.
I also set the following settings in Salesforce OAUTH settings:
- Permitted Users: All users may self-authorize
- IP Relation: Relex IP restrictions
- Refresh Token Policy: Refreshtoken is valid until revoked
Hello,
We are trying to deploy the Data transfer dashboard with the docs from https://wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/cost-usage-report-dashboards/dashboards/3_additional_dashboards/
But we are hitting an error:
```
"Errors": [
{
"Type": "COLUMN_GEOGRAPHIC_ROLE_MISMATCH",
"Message": "Required geographic role for column 'region' in data set 'arn:aws:quicksight:us-east-1:XXXXXXXX:dataset/dc5e5dd9-1235-4bd8-ab7e-b12e18997798' is 'null'"
}
],
```
We have requested access to the template via the URL in the docs.
The rest of dashboards are deployed via the CF in the last 24H and are according to the advanced pattern with multiple AWS Accounts. Also, the other dashboards are running properly and working.
Any suggestions on where to look for info or how to resolve this?
I've been following the steps given in the [cloud intelligence dashboard](https://wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/ ) & [cost optimization data collection lab](https://wellarchitectedlabs.com/cost/300_labs/300_optimization_data_collection/) to deploy dashboards. I've enabled the Trust advisor at the payer account [master/linked account]. After the deployment, Trust Advisor Organizational view is not working or shows no data, I've checked the tao Glue crawlers, and it did not update/create any tables on Athena after its running. Also no datasets was created on the Quicksight too. CloudWatch logs also dont have much information  I see the same issue for Compute Optimizer too.
Please let me know, what I am missing to make it work as it given in the well architected labs.
How do I change the date of the current billing summary, cost summary and compute summary to reflect current month and time within the quicksight cost intelligence dashboard?
Thank you
Since a couple of weeks, the QuickSight graphs are not automatically showing all data in my analysis and in my dashboards:
When I open the analysis or dashboard, only data till September 2022 is shown. While all data is available until December 2022.
See graphs. In the title of the graphs, you can find the selected date range.
When I click on drill-up and then on drill-down, all data become visible. See the graph below.
The (Leadership Competency Trainings Quicksight) is no longer accessible: https://us-east-1.quicksight.aws.amazon.com/sn/dashboards/446b45dc-55d5-4ba4-b128-80b995c0df33
The message I'm receiving states this Dashboard cannot be open - Will this be page no longer be available for future viewing or will this data be completely removed?