Hi All - I am having trouble calculating a continuing benchmark/goal #
Its very simple in excel to create these formulas, however, I am unable to do so in Tableau, particularly when I want to show them as a text table.
Here is a sample of what I am trying to do as my "Goal" formula
Date | Likes | Goal |
---|---|---|
1/1/2012 | 1 | = Likes on Day1 |
1/2/2012 | 5 | = Day 1 *1.20 |
1/3/2012 | 3 | =Sum(Day1:Day2)*1.20 |
1/4/2012 | 6 | =Sum(Day1:Day3)*1.20 |
1/5/2012 | 10 | =Sum(Day1:Day4)*1.20 |
Is there a way in Tableau to calculate the YTD sum to the Previous Day, as my formula above shows?
Here is the worksheet table that I would like to create - As you can see I'd like to make it so the #'s will change as I filter dates.
I should get is from my above example is:
Actual Likes: 25 Goal Likes: 15*1.2 = 18
Essentially I am trying to show whether we are "Above" or "Below" the Goal Likes.
Hopefully someone is able to assist! Thanks in advance!
how about the attached?