3 Replies Latest reply on Jul 8, 2016 2:36 PM by Naveen Agarwal

    LOD Calculation

    Thisie Schisler Do



      I am new to the forum and relatively new to Tableau. I am trying to create a LOD Calculation that counts the number of faculty by year [Year], by division [Division], and by department [Dept.]. I haven't been able to get it to work. When I get one field working (the year, for example), the other two don't.


      Here is what I started with:


      {Fixed [Year]: CountD([Faculty ID])}


      This works for counting faculty by year; however, when I filter down on the faculty's division (Natural Science) or department (Biology), the count of faculty is still the same as the overall for that year, and doesn't change along with the filters.


      I then tried this: {Fixed [Year], [Division]: CountD([Faculty ID])} - This worked for Division, but messed up the Year counts and didn't do anything for Departments.


      Can anyone help me with this? It has been super frustrating!! I hope I have made sense, but please let me know if you have questions!


      Thank you for anyone's help and time