Tableau Summing up aggregated data with FIXED

0 votes

Data is broken down by client, invoice date, and product category.

The volume each week is calculated using a moving average. MA Volume depending on the last 12 weeks: window sum(sum([Volume]),-11,0)/window count(count([Volume]), -11,0)/window sum(sum([Volume]),-11,0)

We need to look at the current week's deviation vs. the MA for that week (Vol DIFF): [MA Calc] SUM([Volume])

We need to add up the variances for a specific time period (year/month). Essentially, this should inform us if we depart positively or adversely from the baseline on average over a particular length of time.
Unfortunately, I receive errors such as:

"The argument to SUM (an aggregate function) is already an aggregation and cannot be aggregated further." "Table computations or the ATTR function cannot be used in level of detail expressions," for example.

Do you have any suggestions on how I may improve my situation?

image

Mar 11 in Tableau by Vaani
• 6,820 points
60 views

1 answer to this question.

0 votes
I was able to solve this puzzle. It was necessary to add months to the view before using WINDOW SUM(Vol DIFF). It's that simple!
answered Mar 14 by Neha
• 8,560 points

Related Questions In Tableau

+2 votes
1 answer
0 votes
1 answer

How to replace the count(field) which is missing in data with zero in tableau?

Use calculated field to create a dummy ...READ MORE

answered Dec 21, 2019 in Tableau by sindhu
1,311 views
0 votes
1 answer

https://stackoverflow.com/questions/64076579/filter-data-with-parameter-tableau

The most typical scenario for utilising parameters ...READ MORE

answered Apr 5 in Tableau by Vaani
• 6,820 points
34 views
0 votes
0 answers

How to handle very large data with Tableau?

For data analysis, I'm using Tableau 9.0. ...READ MORE

Apr 25 in Tableau by Neha
• 8,560 points
30 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28 in Tableau by Vaani
• 6,820 points
60 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

Is there an executable for Tableau Desktop ...READ MORE

Feb 28 in Tableau by Vaani
• 6,820 points
71 views
0 votes
0 answers

Tableau Map view Continent List

I've been attempting to tidy up my ...READ MORE

Feb 28 in Tableau by Vaani
• 6,820 points
46 views
0 votes
0 answers

Downloading tableau workbook from tableau server with data

I'm brand new to tableau server. I ...READ MORE

Feb 28 in Tableau by Vaani
• 6,820 points
78 views
0 votes
1 answer

creating a tableau pie chart with no measures data

It's not difficult once you understand the ...READ MORE

answered Apr 12 in Tableau by Neha
• 8,560 points
40 views
0 votes
1 answer

How to upload data to Tableau Server in Python

https://www.tableautim.com/playlist-video/tableau-tds-and-tdsx-files/csv-to-tdsx Then install the tableau-api-lib utility for Python ...READ MORE

answered Mar 4 in Tableau by Neha
• 8,560 points
136 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP