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 ! [image] I did create this chart by create a calculated field: coalesce(sumIf({count_clicks}, truncDate(‘DD’, {transactions_sales_time}) >= truncDate(‘DD’, ${Datefro…

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 function…

Compare this month and last month in line chart

Q&A

ErikG February 8, 2024, 11:32pm 5

Hi @thecuon119
Did you found a solution?
BR

Comparing This month value with last month

Topic		Replies	Views
Comparing This month value with last month Q&A quick-sight , Business-Intelligence-Engineer , qls-cudos	1	57	July 5, 2024
Previous Period Comparison Q&A period-over-period , quick-sight	4	281	May 14, 2023
Presenting a clearer period vs last period comparison in a table Q&A analysis , formatting , quick-sight , calculations	1	490	July 8, 2022
Month to Date vs Last Year's Month To Date Comparison Q&A quick-sight , calculations	4	2958	May 26, 2023
Calculating MoM, comparing between row month to last month of previous year Q&A period-over-period , feature-request , quick-sight , calculations	2	588	August 20, 2023

Compare this month and last month in line chart

Related topics