1 of 1 people found this helpful
I think I've got it! In order to do this, I created a parameter that allows the user to select a year or all. Just using a simple filter wouldn't allow this to work.
Basically you want to either show the actual rate for a single year or the average rate over all the years. I created a calculated field that distinctly counts how many years there are. Then I created another calculation that takes your overall rate and divides by the number of years. Finally, I created a calculated field that compares the parameter selection and uses the selection to determine which measure to use.
I've attached the packaged workbook as well. Hope this helps, enjoy!
Thank you so much for your help. However, when I opened your workbook, though I thought it was correct at first, it ended up having the same problem. This is what I'm seeing: Workbook: V2 Hawaii Count & District CAN rates 2007-2011
When I tried to open the file initially, it said there was a newer version. Could it be replacing your workbook with my (recently updated but still wrong) workbook?
Not sure what happened, but I just took the workbook I previously attached and have posted it to Tableau Public here: Workbook: V2 Hawaii Count & District CAN rates 2007-2011
It has two tabs, the first one is your original version and the second is V2. Please let me know if there's still an issue.
Something is still very strange when I'm trying to work with this. Right now, when I look at your tab, the axis goes from 0 to 22 when I click "All" and now it goes from 0 to 200 or so when I click on individual years - it looks like it's setting things according to the overall number instead of the rate. In all cases, the axis should be from about 0 to 5 or so, as it is on my original document for each individual year.
I also swear that I saw something different the first time I looked at your tab than what I'm seeing now. Perhaps I'm accidentally selecting some different view? I'm still rather new to this, so I may be making rookie mistakes.
Thanks again for your help and I'm sorry to cause you so much trouble!