Count records for particular year

tableaucommunity@tableau.com — Fri, 08 Mar 2013 09:16:29 GMT

Hi,

I am new to tableau, we have scenario where we need to calculate the rates og graduation by satifying the below logical condition.

COUNT([Time_To_Degree]<=4 AND [Cohort_Year]=2004)/COUNT([Time_To_Degree]>=4 AND [Cohort_Year]=2004).

I used the same logic in tableau and all I am getting are 1 or 100%(when i change the number format).

The same logic applies good on excel sheet. Can someone please help me out here.

Thanks

Ashok

Content in Tableau Community Forums