Hello,
I'm continuing to work through Eli Blankers' Challenge Workbook - Jedi Edition. I found Q10 pretty trivial to implement using LOD calculations (see my solution here), but the instructions explicitly say not to use them. Can anyone suggest an alternative approach? Would appreciate any hints!
Thank you.
The solution is probably using table calculations. When you restart on a dimension, it is similar to fixing on that dimension in an LoD. That is, it will return a different value for each member of the dimension.
[Edit] There is a solution using a couple table calculations. Getting the percentage is fairly straight forward once you place [Product Name] on the worksheet. That, however, will segment the bar chart. So the challenge becomes how to keep just one segment, but have it represent the whole length of the bar.
James Emery
Tableau Forums Ambassador
Please click 'Select as Best' on the one reply that answers your question.
