Skip to main content
GruposRetail & Consumer GoodsPergunta de Tableau Community Forums Member (Inactive)
Tableau Community Forums Member (Inactive) (Salesforce) perguntou em Retail & Consumer Goods
4 de mar. de 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 respostas
  1. Venkatesh E
    5 de mar. de 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
Escrever uma resposta...
0/9000