Skip to main content
GruppiRetail & Consumer GoodsDomanda di Tableau Community Forums Member (Inactive)
Tableau Community Forums Member (Inactive) (Salesforce) ha fatto una domanda in Retail & Consumer Goods
4 mar 2021, 15:30

How can I use the sales of the last week of 2020 and compare it with each of the weeks of 2021

I ask for your help to create a calculated field or parameter to be able to subtract from each of the weeks of 2021 the last week of 2020 and to be able to graph the differences. thanks and regards

 

W53-W01

W53-W02

W53-W03

W53-W04

W53-W05

W53-W06

W53-W07

2 risposte
  1. Venkatesh E
    5 mar 2021, 10:24

    I have created parameter to select year, currently selected 2020, displayed week number and sales. Using LOD found 2019 last week sales. finally difference between them.

     

    Added line chart based on weeknumber of current year.

    I have created parameter to select year, currently selected 2020, displayed week number and sales. Using LOD found 2019 last week sales. finally difference between them.Please find attached packaged workbook.

     

    Hope it will help !

    WeekNumber.twbx
Scrivi una risposta...
0/9000