En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

Weekly Data metrics

0

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

Sujets
Analytique
Balises
AnalytiqueAmazon QuickSight
Langue
English
Shiva
demandé il y a 2 ans462 vues
1 réponse
0

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).

profile picture
EXPERT
iwasa
répondu il y a 2 ans
  • Shiva
    il y a 2 ans

    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

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents