Need help building something like this? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909 Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
This was very helpful for the data I wanted to visualize. I have a data set with issues over the years with an issue open date and issue close date. I tried the same approach and I was able to arrive at open issues over time. Now I was also trying to add a color legend for different issue types but when I do that my running total becomes skewed. For example total issues as of March 2023 for Type A is 10 and Type B is 15. Now in April there was no change in Type A but Type B issue count reduced to 13. Now in the chart ideally it should should 23 with a color legend for Type A as 10 and Type B as 13. But it only shows type b 13 as there was no change in Type A. Can you help with this query?
We're glad to hear this helped! Hmm, it seems like that should work. It's hard to say without looking at it. Are you able to sign up for an office hour to dive into it together?
The other thing that comes to mind is, what are the end dates for the Type A values? Could the end dates (or lack thereof) be causing them to drop off?
I'm sure you could! We've done things like that for our HR clients. Feel free to shoot us a message at start@onenumber.biz if you're interested to work on it together!
What kind of data source are you using? 3 options come to mind: 1) Do the union in Tableau Prep 2) Use Custom SQL 3) Do the union before Tableau (e.g. in the database)
LOOKUP is a table calculation. As a result, it has to apply to the dimensions in a given worksheet. That means it can only be applied to one worksheet at a time as a filter. Your best bet would proabably be to add it individually to each sheet.
Need help building something like this? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909
Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
Thank you for your great channel and nice video explanation 😀
You are welcome!
Thanks, I hope if you can do more videos on HR topics.
You are welcome! That is helpful feedback!
This was very helpful for the data I wanted to visualize. I have a data set with issues over the years with an issue open date and issue close date. I tried the same approach and I was able to arrive at open issues over time. Now I was also trying to add a color legend for different issue types but when I do that my running total becomes skewed. For example total issues as of March 2023 for Type A is 10 and Type B is 15. Now in April there was no change in Type A but Type B issue count reduced to 13. Now in the chart ideally it should should 23 with a color legend for Type A as 10 and Type B as 13. But it only shows type b 13 as there was no change in Type A. Can you help with this query?
We're glad to hear this helped! Hmm, it seems like that should work. It's hard to say without looking at it. Are you able to sign up for an office hour to dive into it together?
The other thing that comes to mind is, what are the end dates for the Type A values? Could the end dates (or lack thereof) be causing them to drop off?
Could you follow something like this to figure out MoM turnover/attrition?
I'm sure you could! We've done things like that for our HR clients. Feel free to shoot us a message at start@onenumber.biz if you're interested to work on it together!
What do you do if step one (same data source union) won't work?
What kind of data source are you using? 3 options come to mind:
1) Do the union in Tableau Prep
2) Use Custom SQL
3) Do the union before Tableau (e.g. in the database)
I like to apply the Lookup Year filter to other views/worksheet. How to do that?
LOOKUP is a table calculation. As a result, it has to apply to the dimensions in a given worksheet. That means it can only be applied to one worksheet at a time as a filter. Your best bet would proabably be to add it individually to each sheet.