Questions tagged with Amazon QuickSight

I have Iceberg tables in AWS data catalog which I want to use to create dashboards in AWS QuickSight. The idea is to set a date paremter in QuickSight and then to be able to use it with Iceberg time travel feature. I.e. I'd like QuickSight to filter the data as of specific date using Iceberg capability to execute queries "as of timestamp" (e.g. select * from table FOR TIMESTAMP AS OF (timestamp '2022-12-01 22:00:00'). My questions are: Does Quicksight support Iceberg tables as a data source? Is it possible to use the time travel feature of Iceberg tables in Quicksight when writing custom sql queries for the data source? Is it possible to use Quicksight parameter with Iceberg time travel? If this is possible, it would be extremely powerful combination Iceberge timetravel + Quicksight dashboards. If it is not possible what is the best alternatives, assuming that my data are in Iceberg tables. It seems that Quicksight can work with Icerberg tables as a data source, but I can't figure out if quciksight paramters somehow can be used im time travel for Iceberg tables.lg...

Hi, I'd like to count if a field (string) has a certain text included. Already tried: * countIf({ID}, {Ticket type} contains 'Wochenend') * distinct_countIf({ID}, {Ticket type} like '%Wochenend%') * distinct_countif({ID}, locate(toLower({Ticket type}), 'Wochenend') <> 0) ...but nothing worked. Would appreciate help from the community! Many thanks, Axellg...

Hi, I have a field ("Start") in the following format: [6/17/23 9:00], currently a string. I would like to transform this into a date so that I can calculate weeks, etc., however it doesn't allow me making this a date format. I tried with edit date (see screenshot) - it doesn't seem to detect a date. Then I also tried a calculated field with parseDate function (e.g. parseDate({Start}, MM/dd/yy HH:MM), but i couldn't get it right. My data source is a csv file that I will regularly upload. Any chance someone can help me here? Thanks, Axellg...

I want to change the 'WEEK' period to Mon - Sun , how do I change it? Or is there any formula to calculate WoW growth?lg...

Hi, I'm working on a ticket sales dashboard in QuickSight (using a csv file that I will regularly upload). Once a year we host an event for which we are selling tickets. To better understand how we are doing in terms of ticket sales, we would like to compare ticketsales for the upcoming event to ticketsales from previous events. However, while in 2021 the event happened in September, in 2022 it took place end of June and in 2023 it will take place mid of June. So instead of tickets sales by respective month YoY, we would like to have something like -20 weeks to event, - 19 weeks to event, etc. on the x-axis, and compare all events within one chart. So always working backwards from the respective day of the event. Is that actually possible? :/ Many thanks, Axellg...

Hi Team, I'm implementing pagination using AWS dynamoDB I have in my UI 4 buttons - first - next - previous - last I'm getting data by segments of 25 rows to avoid to do full table scan. when the user click the last button to go directly to the last page, do I need to do a full table scan for that? or is there a way to get the 25 last rows instead of doing full table scan when we click on the "last" button?lg...

Hi All, I have a question regarding Amazon SES. Is there any way to send Bulk emails using Amazon SES from Microsoft PowerApps application?lg...

My customer would like to deploy CUDOS dashboard and would like to know the exact associated cost for CUDOS dashboard. When i checked this document https://www.wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/cost-usage-report-dashboards/, and looked in to the cost section. It states that cost would comprise of (QuickSight Enterprise license starts at $18 per month + Incremental costs associated with AWS Glue, Amazon Athena, and Amazon S3). Is there an estimate amount of cost that will be charged to the customer?lg...

i have a quicksight account with multiple timestream data sources. when adding a new one, it fails with a strange error started doing this a few days ago.   the quicksight permissions are allowed to hit timestream, and i cant think of a permissions change or quicksight account change that has been implemented in our account.lg...

Hello, We have Amazon Connect CTRs streaming into Athena, and in Quicksight we refresh this Athena SQL view/SPICE every 30 minutes. We have a client request to email the report every 30 minutes (48 times per day); however, Quicksight only allows the report to be emailed daily. In addition, we would like the ability to FTP the data out of Athena/Qucksight every 30 minutes, similar to what we can do with Filezilla and S3. I don't see where Athena query results or Quicksight Analysis/Dashboards are stored for access. How can we get this data emailed/FTPed every 30 minutes? Is there a way to copy an Athena query or Quicksight Analysis/Dashboards to S3 or similar for email/FTP access? Thank you. Johnlg...

I encounter the error when I try to create a new Athena dataset on QuickSight (click on [Validate connection] button); * Error Code: ACCESS_DENIED_TO_RESULT_STAGING_AREA * Error Message: [Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. Access denied when writing to location: s3://<Athena-query-result-bucket-name>/xxxx [Execution ID: xxxxx] Environment: - there're 2 s3 buckets; one is "s3://<Source-data-bucket-name>" for query target, and another one is "s3://<Athena-query-result-bucket-name>" for Athena query workgroup. - Using Lake Formation, and both buckets are registered as datalake location. - After create QuickSight account, I allow access to 2 s3 buckets and Athena via QuickSight account management - On Lake Formation console, I did grant; - QuickSight execution role (aws-quicksight-service-role-v0) access to 2 s3 buckets - QuickSight Group ARN (arn:aws:quicksight:region:accountId:group/default/groupName) access to the raw data access bucket What else should I do to make enable to create Athena data set on QuickSight console? Thank you for your help.lg...

Is there a way to create quadrant (kind of Gartner's magic quadrant) using QuickSight?lg...