So long as your level of detail on the view is always on the individual day level (which to me it sounds like it will) your calculated field should just be [Sessions]*1.1 Then it will auto recalculate if your base data changes and calculate per each day so long as that is the level of detail on your visualization.
Hope this helps
Thanks Brian for the response,
I'm not sure this is going to be possible through Tableau, it needs to be like this
Date Sessions Target Sessions 2018-01-01 9530 (2017-01-01 Sessions *1.1) 2018-01-02 12197 2018-01-03 13061 2018-01-04 12199 2018-01-05 11327 2018-01-06 10610 2018-01-07 10413
I think I may need to perform the calculation in my raw data somehow before uploading into Tableau this may be the only way
Quick question: do you only want it to be this date for this date last year? Or YTD this year vs YTD last year? Thanks!
Just this date last year,
The aim is to populate the column with the target data so that I can then see how this year's sessions are tracking against last year in the view.
Thanks for your in-put however I've managed to work around this by inputting the target figure dynamically into the raw data so I've managed to get a fix
Thanks for the help! I've worked around the problem and managed to input the figure dynamically into my raw data
I created a new sheet within Google sheets which references the dynamically updating data, and performs the calculation, just like you would in Excel.
By doing it in a fresh sheet the data isn't over-written when the Google Sheets reports are ran.
I hope that makes sense if anybody by any chance comes across the same issue.
I'm having the same issue creating a calculation in Tableau as described by Jordan. I'm looking to create a target calculation that is based on my defect data from 2017. I create a calculation that does the following:
Closed Defects / (Open defects as of 1/1/17 + Defects Created during 2017) to get my base number then add 10% to that number to get my target number for 2018.
That target number then needs to fluctuate by product line when I select a particular product line in the filter.
Is this possible?
It’s definitely possible! I would be curious to see your data structure. I’d recommend creating a new post so more users get eyes on it. And there you can post a twbx and/or sample data. Feel free to tag me as well.
Thanks Bryce, unfortunately I can't publish this file, so I will try to solve internally first then if I cannot I will try to create a sample with other data and create a new post.