Compare this month and last month in line chart

[thecuon119]

Hi there,

I’m finding a way to add a line of previous month in this line chart but i don’t really know how to do it. Thanks a lot !

I did create this chart by create a calculated field:
coalesce(sumIf({count_clicks}, truncDate(‘DD’, {transactions_sales_time}) >= truncDate(‘DD’, ${Datefrom}) AND truncDate(‘DD’, {transactions_sales_time}) <= truncDate(‘DD’, ${Dateto})),0)

and limit time range by filter {transactions_sales_time}.

[ErikG]

Hi @thecuon119
Maybe you can have a look at

Creating period comparisons with QuickSight's periodOver and periodTo functions

This article uses the SaaS-Sales Dataset that you can download as part of the QuickSight Author Workshop. We will update the data to the current date so your calculations are realistic. If you do not have a QuickSight account please follow the instructions in the Initial Setup. Instructions to create the dataset can be found in Exercise 1 of the Build your first dashboard. Create an analysis for the dataset. The following steps show you how to create visuals to show data from the current year,…

BR

[thecuon119]

Is there any other simple way ? I’ve tried to follow the steps but it didn’t work

[robert.eibers]

periodOverPeriodLastValue - Amazon QuickSight
This one could work, but on a daily granularity it doesn’t work to 100% yet. sadly not every month has the same amount of days.
BR
Robert

[ErikG]

Hi @thecuon119
Did you found a solution?
BR

[Ramon_Lopez]

Hi @thecuon119

If wanting to look at chart with date field and potentially multple months, would suggest using periodoverperiodlast value as suggested above.

Another option, specially if mainly doing daily sales this month vs last month is to 1. create calc field for day num 2. use ifelse functions to calculate the two periods you want to compared. (to-from dates) and formulas as shown here.

Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

@prkgupta Great! To only take same days of last week (aka Last WTD, vs full last week) you can add one more condition. Ill add it to the article too. Last WTD: ifelse(truncDate(‘WK’, {order date})= addDateTime(-1, ‘WK’, truncDate(‘WK’, now())) AND {order date}<=addDateTime(-1, ‘WK’, now()), sales, 0)

lastmonth

This dashboard shows the two options side by side.