0 Replies Latest reply on Aug 8, 2016 1:02 PM by Lauren Salazar

# Resolving Aggregate & Non-Aggregate Arguments - Cohort Rate Comparison

Hello all,

I am trying to create a dashboard that shows a variety of different calculation for districts in California.

I have a dataset with data for each school in each district which is disaggregated by Gender and by Race/Ethnicity (i.e. 1 row for african american males for school 1, another row for african american females for school 1, etc.). I want data aggregated by district.

I would like to show the following things in my dashboard:

1. Total A-G Completion Rate for the district
2. The difference between the African American and White A-G Completion Rate for the district
3. The difference between the Hispanic and Latino and White A-G Completion Rate for the district

All of this will be shown by District, which means the data for each school is aggregated per district.

The A-G Completion is calculated correctly, however, I am struggling to figure out how to calculate the difference between the A-G Rates by Race/Ethnicity.

Essentially what I want to do with my calculation is (A-G Rate for Whites for District 1) – (A-G Rate for African Americans for District 2). I have tried the following calculations listed below, but all end up showing me Null values. Any ideas?

Here is a link to one of the resources I used: http://kb.tableau.com/articles/knowledgebase/calculation-error-resolving-aggregate-nonaggregate-arguments

Also, could this be a case where I use LOD Expressions? I tried playing around with them, but couldn't figure them out.

African American A-G Rate:

CASE ATTR([Definition])

WHEN "African American, Not Hispanic" THEN [A-G Rate] END

African American Rate 2:

IF ATTR([Definition])="African American, Not Hispanic" THEN sum([Uc Grads]/[Grads]) END

African American Rate 3:

(IF ATTR([Definition])="African American, Not Hispanic" THEN SUM([Uc Grads]) END/

IF ATTR([Definition])="African American, Not Hispanic" THEN SUM([Grads]) END)

I'm attaching my dataset and my .tbx file

The data has 3 tabs which I've joined: "data" is the raw data, "Sheet2" has definitions for the race/ethnicity coding in data, and "College Futures Regions" has regional values based on counties.

Thanks ya'll!