See if the attached workbook points you in the right direction. You need to separate your Fill Rate into two separate years, making one of them a negative and the other a positive. Not sure about the ratios or results, you'll know your data better than I will. If this resolves your question, please mark this response as correct. If it points you in the right direction, please mark it as helpful. So that others may find it useful in the future. Thx, Don
I used this calc for 2017 as example, with a negative sign in front of the [FILLRATE] so that all values are negative for that year. Duplicated it for 2018 and removed the negative sign to make it positive.
I used the following LOD calculation for the FILLRATE:
divide.twbx 96.7 KB
Thanks Don. It answered my question. Also, what are the good ways to learn query inside of Tableau? I felt that I've gotten the ideas but i just can't get it right.
2 of 2 people found this helpful
Usually an internet search for Tableau specific functions will get you very positive results.
Sometimes I just peruse the Forums to see what and how others are handling a situation or answering a problem. There are also many online videos and other Tableau specific websites that can help steer you in the right direction and for specific chart types. When you find yourself getting stuck, try something else related to your first search. What I've found with Tableau, and in reading various responses to problems on the forums, is that there are many ways of achieving good results.
You might like this site: http://www.tableaulearners.com/
Each of the people on the forums are generally volunteers that feel they have enough experience to attempt to answer issues/concerns. Myself included. Sometimes we succeed, sometimes we fail, but we are always learning...just keep trying!!
Glad to have helped...Thx, Don