CODEWITHSUNDEEP
tableau-api
Shivi Bhatia
Shivi Bhatia

Reputation: 189

Finding Difference from Previous Day Volume to Next Day Volume

I have been struggling to find the new incoming volume per day.
I have categories as : - total ticket, Resolved, closed and Daily left.
So the calc is everyday resolved and closed are moved from the queue and
'daily left = Total Ticket- (Pending + Closed)'
Now there is some carry forward everyday hence the total ticket for the next day includes some volume i.e. Daily left of previous day.
I am not able to figure out how to show that number, I have tried using previous value but it is not helping. Please suggest. Attaching a print screen of the data.Please refer to 03-01-17 For 3rd the # of records are 33 however there is 1 carry forward from previous
day hence the Fresh Vol should be 32. I have used the formula to calc but it is
not giving correct result

sum([Number of Records]) - (PREVIOUS_VALUE([Daily Left Volume]))

This is taking the left over of current day and not previous day.

I am also using look Up function but that also does not show the current output.
LookUp Function
The output from tableau after using the lookup function is below attached as well
enter image description here

Upvotes: 1

Views: 1131

Answers (1)

Aman
Aman

Reputation: 49

I am new to this community and dont have enought reputation to comment :P. So writing few possible solutions here: 1) Make sure the data is sorted by date and is unique on date level. If it is not then Previous or lookup might not work 2) Another solution will be take running_sum of every field and then apply the operations. This should give right answer 3) If this does not will it possible to change the way you import the data? a) Simply create another filed as Date_past = Date-1 in your raw data. b) Duplicate your data. c) join the two data sets on Date = Date_past d) Now you have all the data of today's date and last day in one field and you can perform operations as you need

Upvotes: 1

Related Questions