Welcome to the forums.
Is there any possible way of attaching a .twbx file that we can work with? And maybe a rough drawing (paint will do) so we have some direction?
PS: You're correct in calling it Pivot. In fact, Tableau can handle this task already: In the Data Source tab Highlight two columns, hit the arrow, and select pivot!
hope that helps!
Just wanted to check in on how things were coming? Did you reach a solution?
Thanks for your answer, and sorry for the latency, I've been traveling.
I'm currently preparing for you a tableau file with a reduced data set. I will upload it here as soon as I'm done!
Talk to you soon,
Here is a sample tableau file with some of my data. It's a bit of a mess, sorry about that.
Long story short: I created two folders ("model" and "sim.") where I put the measures I want to plot. I managed to plot what I want for the data coming from the simulator (See the "CPI stacks" tab). What I want to do is to add on this plot stacked bars with data coming from some of the measures in the "model" folder, so that I can compare the two. Note that these measures are calculated fields.
I'm not sure if I'm being clear, so let me know if you want me to clarify something.
stacked-bar.twbx 80.8 KB
Hi Rekha, and thanks for your reply,
I'm afraid this is not what I am looking for. What you did (if I am not mistaken) is to add more measures on top of the existing bars. What I would like to have is to add, for each table name/benchmark/cache configuration, a second stacked bar showing the data coming from the "model" measures. Basically, if I understand the tableau terminology correctly (which I probably don't!), this should be equivalent to adding a new dimension.
I still haven't found a solution to my problem, and would greatly appreciate if someone could have a look.