1 of 1 people found this helpful
I believe a more ideal structure would be:
One column for "value" with all values in one column. Then 2 additional columns: one to flag rows as Type "real" or "target" and another to flag KPI Type as "sales", "costs" or "employees".
I'm not an expert on this, but I know things are typically much easier in Tableau with TALL, rather than WIDE data.
I'm also not very good with SQL, so I'll leave the transformation up to you. Someone can correct me if I am wrong on how to approach the data structure.
Sorry. Got errors while trying to download the packaged workbook.
Thanks for the tip...I changed the input format to more like I think you meant:
...and it has helped inspire a solution I think!
With this I can consider just type = Real, and use a table calculation "percent of difference" to show everything against target. Then if I hide the Target columns, I get pretty much what I want.
And Ryan, sorry you had an error downloading it. But thanks for trying!
Book4.twbx 9.8 KB
Yep, tall data can really make life easier in Tableau. Cheers.