periodOverPeriodPercentDifference(sum(Sales), {Order Date}, WEEK, 1)

0

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

asked a year ago218 views
1 Answer
0

Hello,

QuickSight defines Sunday as the start of the week, by default. Upon checking internally, we can make use of the following calculated field formula to group dates by weeks starting on Monday. Please replace {date} with the field name at your end

addDateTime(
    1, 
    'DD', 
    truncDate(
        'WK',
        ifelse(
            extract(
                'WD',
                {date}
            ) = 1, 
            addDateTime(
                -1, 
                'DD', 
                {date}
            ), 
            {date}
        )   
    )
)

There is an existing feature request internally to support custom week start day/date and the internal QuickSight product team is working on it. Unfortunately, we do not have an ETA at the moment for when this feature would be available, but would I recommend you to refer to the following for further updates :

[+] https://aws.amazon.com/it/blogs/aws/category/amazon-quicksight/

[+] https://docs.aws.amazon.com/quicksight/latest/user/WhatsNew.html

Reference: [+] https://stackoverflow.com/questions/55117362/start-week-on-monday-in-aws-quicksight/55857785#55857785

==========

Regarding WoW growth calculation, we can make use of the percentDifference calculated field like the below. Please replace Value, Date with the field names at your end.

percentDifference(Value, [Date ASC], -1)

[+] percentDifference - https://docs.aws.amazon.com/quicksight/latest/user/percentDifference-function.html

Thanks

AWS
SUPPORT ENGINEER
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions