I have a client who wants to see current number of membership cards sold by month. No issues doing this, but what they provided is a target that changes every month. I need to show on a dashboard with the monthly count is higher or lower than the target. They want to see this in color and in the tool tip. The problem I am having is that the target is different every month as their business has peak times. How would I go about doing this?
Is there a way to add the target as its own column which you then plot?
This question would be easier to answer if you had a packaged workbook with some data. If you have sensitive data, take a look at Anonymize your Tableau Package Data for Sharing.