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
Hi, @Shiva
I understand that you have two years of daily data and want to change it to a weekly format. Is my understanding correct?
In that case, you can change the scale of the datetime field (Daily-> Weekly-> Monthry ...) on the quick site. Is this insufficient as a function?
Please refer to the following article.
https://docs.aws.amazon.com/quicksight/latest/user/changing-date-field-granularity.html
Otherwise, it can be aggregated at the time of dataset generation or even before data source creation (eg aggregate with Athena).
Relevant questions
TRUNCATE DynamoDB table
Accepted Answerasked a day agoTimestream Historical Data (10s of years old)
asked 3 months agoWhy the LoginFailures metric showing no data for RDS MySQL instance?
asked 3 years agoQuicksight - Create data set (Athena) - Table query times out when trying to create data set
asked a month agoHow to load large amount of data from S3 onto Sagemaker?
asked 6 months agoCopying data from sql server to snowflake with AWS GLUE
asked a month agoWeekly Data metrics
asked 3 months agoUnable to refresh QuickSight Dataset
asked 5 months agoIf I have enabled sensitive redaction data on Contact Lens, am I still able to listen to the unredacted audio through the console?
asked 2 months agoI am trying to write an ETL job to the Data Catalog but its writing the Headers as Data
Accepted Answerasked 3 months ago
The data is dynamic here.I need to get only the information about individual,regions and sum of the tickets assigned to the individual of last week only.Its kind of only weekly metrics.sum of the tickets assigned to the individual is not working because its depends upon the values like regions and groups.let me know right formulas to be used in the calculated fields