Questions tagged with Amazon QuickSight
Content language: English
Sort by most recent
I have a string type for date and in that column, it has the word 'None'
My query for casting the date is below - *getting only the Month and Year on it*,
date_format(cast(c.enddate as date), '%M') as "Month",
date_format(cast(c.enddate as date), '%Y') as "Year"
ERROR prompted
INVALID_CAST_ARGUMENT: Value cannot be cast to date: None-
Can somebody help me with this problem, so that I can still get the Month and Year only?
Thank you in advance!
We are currently writing a number of queries in QuickSight using SPICE for storing the results. This is fine for one-off QuickSight reports, but we'd need to write new queries and store in new SPICE when we change parameters, such as date range (i.e. changing from 1-week to 1-month reporting periods). What is best practice for what to store in SPICE: querying and storing data from single queries, or all joining data from tables and storing all data in SPICE (so that we may change query parameters in the future)?
We are using Redshift + QuickSight
Hello!
How do you change the filters from your controls to reflect specific data outputs in your email?
For example, I am trying to send out PDF snap shots of current quarterly data from my controls via email.
Thanks
Greetings,
I have some analyses made on Quicksight and for personal reasons my plan is to unsubscribe now and return 3 months later to work on the same assets that I now have.
My question is: When you delete a Quicksight account, ¿orphaned resources have the same recovery time as standard deleted assets from an active Quicksight subscription? Thanks
In the following blog post:
https://aws.amazon.com/blogs/big-data/add-comparative-and-cumulative-date-time-calculations-in-amazon-quicksight/
under Advanced use case 3: Partial period comparisons for partialQoQQTDSales comparisons if this formula is used in conjunction with RunningSum to measure partial year this year to date vs last year to date and if **one of the year** is a leap year, the calculations will take into account one more or less day (depending if the leap year is a prior year or this year).
Using the blogpost example, to replicate this issue, one can try this:
PartialYoYYTDSales=periodOverPeriodPercentDifference(runningSum(sumIf(Sales, {Order Date} <= addDateTime(dateDiff(truncDate("YYYY",now()), now(), "HH"), "HH", truncDate("YYYY", {Order Date}))),[truncDate("HH",{Order Date}) ASC],[truncDate("YYYY",{Order Date})]),{Order Date}, YEAR, 1)
if now() is a date in a leap year ,the prior year invoked will have 1 more day being added into the running sum calculation for last year.
i.e. if now() is Mar 6 2020, prior year running sum calculation will include Mar 7 2019 as an extra day (from Feb 29 2020) is added into the periodOverPeriodPercentDifference calculation.
This also affects all periodOverPeriod series of functions.
Please advise if this could be fixed or looked into. Thank you.
We set up a flow syncing Google Analytics 4 metrics Metric:active1DayUsers, Metric:active7DayUsers, Metric:active28DayUsers by dimension Dimension:country.
We have no filters.
This flow succeeds on demand, but fails on schedule with this message:
```
The request failed because the service Source Google Analytics 4 returned the following error: Details: The field that you specified as a filter, active1DayUsers, is not supported by the data object that you assigned to this flow. Specify a valid field and try again., ErrorCode: InvalidArgument.
```
Any idea how I can fix this?
Hi,
we configured SSO for QuickSight and followed the instructions in this blog:
https://aws.amazon.com/de/blogs/big-data/enable-federation-to-amazon-quicksight-with-automatic-provisioning-of-users-between-aws-iam-identity-center-and-microsoft-azure-ad/
However, in this article every user will be an admin, because https://aws.amazon.com/SAML/Attributes/Role will always be mapped to arn:aws:iam:: <YourAWSAccount ID>:role/QuickSight-Admin-Role - the role does not depend on the user group.
As described in the article, we created 3 IAM roles and Azure AD groups (Admin, Author, Reader). How can we assign IAM roles to the AD group? We already tried using claims in Azure AD, as described here: https://aws.amazon.com/de/blogs/big-data/enabling-amazon-quicksight-federation-with-azure-ad/
Hi,
I'm creating a dashboard for operators to download the athena query results.
The ID column values contain hyphens `-` and
For example, if table contains the following data
| id | name |
| --- | --- |
| `-xyz` | `First example` |
| `a-b-c` | `Second example` |
The generated csv contains a extra single quote in the id column at the first row
```csv
"id","name"
"'-xyz","First example"
"a-b-c","Second example"
```
Is there any way to avoid it?
I have a KPI visual that displays the count of records I have from a dataset. Is it possible for me to make that KPI show me all the records that were included in this count?
In Amazon Quicksight, I get a "system error, size limit exceeded" error when trying to duplicate or delete a visual.
What may be the cause?
I am building an analysis where I would like to highlight entire rows based off values in different fields. I have successfully been able to highlight an entire row based off one field, but if I try to highlight a row a different color based off another field, I don't seem to be able to do that. Is this possible?
Hi,
I am using AWS Quicksight Q to analyze a dataset. When a why question is employed with average aggregation function (e.g., "Why did value drop in 2020?"), the highlight of the result is wrong (e.g., %DIFF -75% drop when values are 61650.19 vs. 53150.14. Please see the attached image). If the same question is asked with SUM aggregation function, the highlight of result is correct! Could you please help me to address the issue? If there is an opened bug in AWS Quicksight Q, could you please send a link to track when it is resolved.
Best,
