community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Knowledge Base

Definitive answers from Designer experts.

Using Images in Reporting Tables

Community Content Engineer
Community Content Engineer

 

If you’ve ever wanted to spruce up your reports by adding images, you’re probably familiar with our Image Tool in our Reporting Tool Category. While it often comes in handy when you want to append images to a report, you can also append images conditionally, and to your tabulated datasets. This can help to identify patterns or communicate trends in your data more visibly and improve readability for your target audience. After all, a picture is worth a thousand words!

 

We’ve gone ahead and built out a brief sample of the approach in the attached v10.5 workflow export, PictureInTable.yxzp. This workflow uses a simple Formula Tool assignment to conditionally specify an image to be visualized next to reach row of data. In this use case, we wanted to show a down arrow image next to a negative (or 0) number in our Test field (trending down) and an up arrow next to a positive number (trending up):

 

11.png

 

Since the image files are in the same directory as my workflow, the Image Location field now specifies exactly where/what the images are for each row, allowing me to specify this field in the Image Tool. This will append the image at those file locations to each row of my data:

 

2016-05-05 16_21_56-Image (2) - Configuration.png

 

13.png

 

Then I simply build a table around the already tabulated data, excluding my Image Location field that was used to append the images. After rendering the table, you should see the images included:

 

14.png

 

There you have it - you can extend the approach to really liven your reports!

Comments
Atom

Image is not being picked up even i used same expression. can you please advise where should i place these .png/jpeg files.

Community Content Engineer
Community Content Engineer

Hi @Raju!

 

The .\ in .\name.ext for each file means the working directory that the Alteryx workflow resides in - so wherever you save your workflow!

 

Best of luck!

MattD

Atom

Thank You MattD