How to get around the non-aggregate/aggreate mix in an IF statement

tableaucommunity@tableau.com — Wed, 22 Feb 2012 18:08:04 GMT

I have several categories of products and I need to calculate metrics using different criteria for each. For example, I calculate the metric for Cat Toys like this:

(sum([QTD Actuals])/sum([Full Quarter Target Growth]))*.3

and the statement looks like:

IF [Product Category]= "Cat Toys" THEN

(sum([QTD Actuals])/sum([Full Quarter Target Growth]))*.3

ELSEIF [Product Category]= "Dog Toys" THEN

(sum([QTD Actuals])/sum([Full Quarter Target Growth]))*.5

END

This calcuation yields the 'cannot mix aggregate and non-aggregate comparisons or results' error. What is the best way to handle this error?

Thanks!

Filtering and Layout Containers

tableaucommunity@tableau.com — Wed, 15 Feb 2012 19:24:04 GMT

A few months ago we had our trusty Tableau consultant out and he was able to build out a dashboard that had multiple charts in one layout container.

Our company is broken up into regions, branches and managers. At the bottom of this dashboard is a 13-month line chart showing the % of happy customers, by month. When there were no filters applied to the dashboard, the line chart showed the metric for the entire company. When I selected the North Central region, the chart showed the metric for just the selected region. When I then selected a manager, the chart showed the metric for the selected manager in the selected region.

I wasn't around when this was built out, but the way a co-worker explained it was that there were mulitple chars in the layout container, they just were 'squished' (his word) when the relevent filter was not applied. I'd like to try and figure this one out before I go running to mama for help.

Thoughts?

Thank you!

Content in Tableau Community Forums

How to get around the non-aggregate/aggreate mix in an IF statement

Filtering and Layout Containers