It looks like your taking the right approach. One problem you might be running into is aggregation. To fix this you would just rewrite the calculation shown as:
If [Pivot Field Names] = 'Inquired' THEN [ID] END
You would then add an aggregation when you put it on the columns or rows shelf as: COUNT([Inquired Students])
If this doesn't work, then it probably has something to do with the way your data is structured and I would need to see it to make any other recommendations.
Best of luck!
Thank you for your quick reply. I have tried several calculations, including the one you recommended, no luck at all. I have never used pivot before thus not sure if there is any special conditions or not.
Could you attach your packagd workbook for us to investigate for in detail?
Attached is a mock up workbook of my data structure.
or see below:
ID Inquiry Date Application Submitted Date Admitted Date Confirmed Date 1 8/25/2012 8/21/2012 2 8/22/2012 8/8/2012 3 3/19/2013 4 12/10/2012 12/10/2012 12/10/2012 12/20/2012 5 8/21/2012 8/21/2012 6 8/21/2012 8/22/2012 7 8/22/2012 8/22/2012 8 8/22/2012 8/23/2012 9 8/22/2012 8/22/2012 10 8/23/2012 8/31/2012 11 8/23/2012 2/3/2013 2/3/2013 12 3/19/2013 13 12/28/2011 14 12/28/2011 15 3/19/2013 6/3/2013 8/15/2013 16 8/21/2012 8/22/2012 17 3/19/2013 18 8/20/2012 9/8/2012 19 4/28/2014 4/28/2014 5/19/2014 20 8/22/2012 8/22/2012 21 8/23/2012 9/26/2012 22 3/19/2013 3/19/2013 23 3/19/2013 3/19/2013 3/19/2013 24 3/19/2013 3/19/2013 3/19/2013 7/22/2013 25 8/24/2012 26 8/24/2012 8/24/2012
Just validate your pivot field name's values once, check is there any space or special character in your values.
Is it same results are you getting in case of other field values like Applied/Confirmed/Admitted ect..
COUNT(IF [Pivot field names] = 'Inquired' THEN [ID] END)
If you still unable to get the correct result then as @Shin has mentioned share a sample workbook.
First connect your data in tableau then make a pivot
Then your data would be like this
You can do something like that just drag pivot field names in rows shelf and ID on label and make an agg on count.
Most important part you've to filter the dates(Pivot field values). Put relative date filters on Pivot field values as instructed in the below screen shot.
Hope this help. Let me know If you've any query.
Thank you so much for taking your time to reply to my question. I already applied Pivot table, but I can't apply calculated fields against it. Here is sample worksheet. There is no space or any special character on my field names.Again, I am trying to separate all pivot field names so i can do some calculations, like 'applied/inquired' or 'admitted/confirmed' rates.
I really appreciate your help on that. I was going around calculation field but looks like i missed two things on this: check only non null dates, and do if statement first and apply count on the top of it. It worked perfect as i wanted it. Thanks again.