When i use a calculated field:
if
attr(event year)=attr({max(event year)})
then window_sum(subscribers,-(day(event date)),0)
end
it returns 'all fields must be aggregates or constants while using table calculations from multiple data sources' and here all my fields are from the same data source. What is the problem and how can i solve it?
2 answers
good morning -
are you new to Tableau - see https://jimdehner.com/2022/01/11/table-calculations-when-where-and-how/ for how table calculations (and window is a table calculation) work
Jim