Hello,
I am trying to conduct some promotional analysis. I have Circana data that is weekly that I need to phase over the promotion at a daily level, as the data sets have different start dates.
The Data is blended using Table prep where I have taken internal data and a date scaffold to give the daily levels. When i remove all date fields, the LOD calculation i have for the Base Units does not remain at a daily level. Why is the calculation not working? There are a number of other fields I will need to calculate as well, but the principles will be the same.
I also need to get the filter to work when changing the "External ID" field, but i have limited this data set to just this one External ID for size purposes.
Thanks for your help
Jon
#Tableau Desktop & Web Authoring
sorry when your workbook opens it does not include your work- did you really blend the data? I suspect you used a Cartesian join to create the scaffolded data (at least you should) - in any event - I would recommend the 2nd or 3rd example here https://jimdehner.com/2025/01/27/say-goodbye-to-cartesian-joins/
that will show how to use a scaffold without exploding the data
Also in the future please attach your workbook in a twbx format
