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, 2022 in Tableau by Vaani
• 7,070 points
974 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, 2022 by Neha
• 9,020 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
2,012 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, 2022 in Tableau by Vaani
• 7,070 points
504 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, 2022 in Tableau by Neha
• 9,020 points
1,068 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, 2022 in Tableau by Vaani
• 7,070 points
500 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

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

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
450 views
0 votes
0 answers

Tableau Map view Continent List

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

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
569 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, 2022 in Tableau by Vaani
• 7,070 points
582 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, 2022 in Tableau by Neha
• 9,020 points
880 views
0 votes
1 answer

How to upload data to Tableau Server in Python

Then install the tableau-api-lib utility for Python ...READ MORE

answered Mar 4, 2022 in Tableau by Neha
• 9,020 points
2,209 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP