Forum Discussion

AuraCorp's avatar
AuraCorp
New Member
10 years ago

up arrow / show a shape based on a formula

Hi all.    I just want to show a shap (in this case a green arrow) based on a comparision between two numbers. 
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

AuraCorp - OK, here is what I did, see if something like this will work for you:

 

Values Table

Value 1,Value2

100,10

20,5

 

Keys Table

Key,Image

p,https://upload.wikimedia.org/wikipedia/commons/3/31/Urban_Meyer_vs_Michigan%2C_2013.jpg

q,https://upload.wikimedia.org/wikipedia/commons/b/b5/Luke_Fickell_in_2014.jpg

 

Formated Image as Image URL

 

In Values, create new custom column:

 

Key = IF([Value 1]-[Value 2]<20,"q","p")

 

Relate Key to Key table

 

Simple table visualization shown below:

 

 

 

"p" is Urban Meyer, "q" is Luke Fickell

 

So, if you have a red down arrow or green up arrow that you can point to online this might fit the bill.

VidaLi's avatar
VidaLi
Frequent Visitor
9 years ago

HI, Greg_Deckler

 

how did you manage to get your picture URL display as image.

 

I used matrix to create a table. but when use the image URL as VALUES, it's still dispaying as URL not the actual image, i have applied the set the column to be "Image URL" as for the Data Category.

 

I read from other post where it will work for ROWS but not values, i have tried that it's the fact for me. can you please let me know how did you make the image to display and it's a value of the table please?

 

thanks,

Vida

  • VidaLi's avatar
    VidaLi
    Frequent Visitor
    8 years ago

    instead of Matrix, you have to use use tables to be able to display the image. Matrix doesn't work. 

     

    Thanks,

    Vida