I'm trying to achieve the "Ideal State Data" column in the attached picture. There is a dataset where every day has a single row with lots of other information in other columns. One column flags dates at which a certain Salesforce field was changed, and it then stamps the row with that date. We want to be able to see, on any given date, what the current status of that field was, but right now we only stamp the day that it changed.
How would we populate the nulls in the "Current State Data" column? With the stage it was most recently in the past? I'm doing this in Tableau prep but would assume there are solutions in Tableau desktop as well
You could use:
IFNULL(ATTR([Current State]),PREVIOUS_VALUE(ATTR([Current State])))
Which would get you:
It is a table calculation and as such requires the detail (Date) to remain in the view. Best, Don
