A question regarding adding images to filter dynamically: What do you do if the image is not marked "Valid"? I followed the steps exactly and no matter what image I select it always marks it "No" under the valid header (step 10).
So how do I make the image valid?
David, it's easy to miss a step. Something is going wrong somewhere around Step 7. Are you getting the 0 & 1 in the top/bottom left/right set correctly? Also, go back and make sure you set up Step 5 correctly. If all else fails package up the workbook and post it and I'll set it up for you. You might have to post your image files separately, as I don't know if invalid images get included in the twbx.
Shawn, thanks. I tried it again with another image and it worked. Not sure
why because I followed the same steps. But thanks for responding so quickly!
On Wed, Mar 26, 2014 at 4:08 PM, Shawn Wallwork <
Interesting. What type of file was it? png, jpg? Would you post the image here, so I can play with it and see if I can figure out why it failed. Thanks,
It was .jpg. Just a random sample I pulled from a sample gallery of
But I'm beginning to think I didn't put the "1" in the Y-axis the first
time. Thanks for your help.
On Wed, Mar 26, 2014 at 4:48 PM, Shawn Wallwork <
No thank you for tracking down your issue. Anomalies drive me (and I'm sure Tableau) crazy. Still sort of wondering why clicking all the Map Options on locked up all my Tableau menus... but that's a whole different conversation.
Is there a way to do this with parameters instead of quick filters?
Great tip btw!
Yes. You'll create a parameter. Then use that parameter in a CASE statement. Something like this:
CASE [My Parameter]
WHEN 'Coffee' THEN 'Coffee'
WHEN 'Tea' THEN 'Tea'
Put that on the Detail shelf. Whatever you call that CASE statement will show up as an option in the Add Image > Options > Add > Select a field: dialog box.
Glad it worked for you (at least the first time). No I haven't run across that one. You might just try starting over again. Or at least, deleting the ref to that image and then try re-establishing it. Pretty terse message, but I'd guess Tableau can't read your images name, maybe because it has some special characters in it. Maybe a doubled extension (two periods) is confusing T.
Curious: has anyone dynamically loaded images into the row headers of a viz ?
I do have a calculated field in my data source which returns the URL of an image for each row. Now I need the way to display each image in the row header.
Tableau's row headers and axis labels are text-only as far as I ever seen, the formatting options are limited to color, borders, and banding. And Tableau really only supports one web object at a time for dynamic input, if you have multiple web objects Tableau can get confused about what should go where (usually everything ends up directed to in the first web object in the view). Also, other than the URL active at the time the worksheet was loaded, URLs drawn from data aren't automatically loaded unless the user activates the URL Action via hover, select, or the tooltip menu. There might be some way to have the auto-load via the JS API, I'm not sure.
An other workaround would be to have a floating worksheet that contains all the images that is set up to have the right spacing & borders so it floats over the rest.The two routes for putting lots of images on a worksheet are to use custom shape images or background images. This means downloading the images so they can be part of the workbook, losing the flexibility of leaving the images online. For using custom shape images, here's a nice tutorial from Jewel Loree: Jewel Loree » Dealing with 718 Pokemon Shapes in Tableau. One thing to be aware of is keeping everything in the borders of the worksheet, otherwise you'll end up with two scrollbars, one for the floating worksheet and one without.
Depending on the exact view, though, you might be able to get away with something like a multiple axis crosstab and have one axis be a fake "header" using the images and then have the rest of the view on the other axes.
Thanks for your detailed reply! I've submitted the new IDEA #3433, please give it an up-vote if you're so inclined.
I'm curious about your ideas around "getting away with something like a multiple axis crosstab and have one axis be a fake "header" using the images and then have the rest of the view on the other axes."
How do you envision this would work, exactly ?
I've come across this blog entry about breaking the rules, and the approach described there achieves something similar to a dual axis crosstab. Can you help me to understand what you had in mind ?
Yep, that's what I call a multiple axis crosstab. You can see a crazy use if one at http://public.tableausoftware.com/views/conditionalformattingv4/Introduction. Download the workbook, the captions have instructions and overwhelm the display.
My thought is that you'd set up a MIN(1) or whatever axis with something like a Shape Mark and the right level of detail to draw all the images.
OK, I'm getting the idea now. If I put these multi-axis crosstabs together with 718 pokemon shapes, then I might be able to get there. But not without a LOT of labor. That's because, as far as we know, there isn't any way to dynamically set the image URL.
I would need to download all of the images locally, rename them to match the dimension values, and then sort alphabetically & assign a custom shape palette.
Then, if I wanted to share the workbook with anybody else, this is going to explode the size of my workbook, because the custom shapes if I'm not mistaken are stored as binary objects inside of the .twbx.
Anything mistaken about my assessment up to now ?
What I'm most curious about is a "workaround" that was mentioned in the comments of this Tableau Public vis by Lori Williams. I've tried sending her an e-mail, but no reply yet. That she mentions a work-around exists back in 2012 leads me to hope that some nicer approach must hopefully be available.
After all, I do have the URL of the image sitting in the database, just ready & waiting to be used