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.