2 Replies Latest reply on Jan 24, 2019 10:25 AM by Deepak Rai

% Daily change

Megha Bhatnagar Jan 24, 2019 10:00 AM

I have a table with three columns

step

date

count

I want to find the daily % change between the latest and latest-1 date. The latest date will be refreshed everyday. What I am looking to do is find the % change i.e. count for Today/(count for Today-1)-1 for every step

How can I do that?
I am attaching a mock workbook.

mock.twbx 15.5 KB

1. Re: % Daily change

Kyle Boyce Jan 24, 2019 10:21 AM (in response to Megha Bhatnagar)

This will, by default look at the previous value from left to right. so when you get a new date it'll still look back one day
Like Show 0 Likes(0)

Actions
2. Re: % Daily change

Deepak Rai Jan 24, 2019 10:25 AM (in response to Megha Bhatnagar)
mock (1).twbx 18.0 KB
Like Show 1 Likes(1)

Actions

Go to original post

Tableau Community Forums

% Daily change

1. Re: % Daily change

2. Re: % Daily change

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account