pie graphs+heat maps

[#1]

Hello everyone, 

   As a marine biologist, I recently stumbled across a visual presentation of coral reef data that I really like (see attachment). In it, you will see various pie graphs in which the individual wedges are essentially heat maps to show relative levels of certain parameters. I would like to adapt this for my own research, and I THINK it cn be done with Graph Builder, though not as a heat map, per se. Here is my idea: say I want four pie wedges representing four response variables (A, B, C, and D). The size is unimportant, so I will give each a value of 0.25 so that they occupy equal areas. I realize I can overlay color, so I created a "color" column and assigned values for the four response variables, but then my graph didn't change accordingly. I tried value coloring and labeling, but no luck. I feel like I just set up my table wrong! Any suggestions?? Thanks!

[#2]

John,
This is great! Do you think it could be done directly in Graph Builder or would it require scripting and advanced knowledge to do so? I know I can just modify the script but I’m just thinking in terms of streamlining it were I to go with this option over the pie graphs for tons and tons of data. Did it require a custom shape or did you manually pin all those icons in the map?

[#3]

Anderson, 

Graph Builder doesn't provide a way to place bar charts or pie charts at specific locations on a map. You can get around it by:

1.  Creating a table from your Graph Builder graph where you use sample number in the map role (built using bars or the custom map shapes. This creates a table with sample number column and a column of images for each sample. 
2.  Copy the image column from the generated table back to the unstacked data table( make sure that the image column matches the order of the sample number. **
3. a. Label the image column OR b. Set 'Use as Marker' for the image column. 
4. Using the unstacked data table, create a Contour Map in Graph Builder using salinity or temp column as the color Role.
5. Add a points element.  Optionally using another color role.
6. If you follow step 3.a, the images will appear in hover labels. You can pin some hover labels and Replace Text to remove any unwanted hover label text. 
7. if you follow step 3 b, all markers will be shown with the image from the image column. This can cause a cluttered display which you can resolve by zooming in or by deleting images that are overlapping. 

** I found they were not in the same order, and had to sort before copying the image column. In hindsight, I realized I could have used a join or virtual join to get the images on the correct rows. I wish I would have read this first: https://community.jmp.com/t5/JSL-Cookbook/Geographic-Maps-with-Graphs-as-Markers/ta-p/53782.

I published both 3.a and 3.b here:

https://public.jmp.com/packages/Heat-contour-with-image-annotations/js-p/5d64597acf28b80f980812ba

About the method I used to draw the bars. I didn't use custom maps, I used the custom graphics script to calculate the length of the bars and to position them above each point. 

When it comes to streamlining, JSL is often the best choice.

~John

[#4]

This discussion inspired me to create a paper and presentation for JMP Discovery Americas 2020.   

As I prepared the paper, I had time to experiment and improve on the techniques described in this post.  

Included with the paper, are some resources (custom maps and examples) and detailed instructions on how to use them. 

I hope you will find this post and my paper useful.

Thanks, 

~John

[#5]

John, 

   This is great, and I fully intend to watch the talk your week (it is on my schedule.). I think this capacity, along with the "graphlets," will open up all kinds of doors for overlaying data onto Graphbuilder graphs and plotting data onto custom figures (like the human body example we talked about earlier that is found somewhere on the JMP website in the form of a tutorial, I believe). I'll be curious to see if anyone has any suggestions in terms of aesthetics. I personally like the pie graphs, but maybe there is a better way we are not even considering? I like your idea of the video game style "health bars," too.

Come to think of it, maybe this could benefit epidemiologists. For instance, if you had infection rates overlaid on a lat-lon grid, then pinned wedges/pie graphs with additional information about patients or groups of patients on the contour plot, you could potentially add a layer of complexity that may not be possible using the standard GraphBuilder features (I guess for most types of data, the graphlets would work for this, too, though). 

[#6]

Anderson, 

That human body example is used here : and here:  

I saw your Discovery Summit Americas 2020 Presentation recording :  but I'm looking to forward to seeing it live! 

~John

 

[#7]

Hello ,

 I'm joining this discussion quite late, but I am trying to create a very similar type of visualization. I'm particularly interested in the "3.b" solution, as I want to display pie charts on a grid across Europe (the label style is not readable at all in this scenario).

Point is that when I use graphs as marker, the background is white which doesn't look so good on the maps : they tend to overlap on the corner.  

Although I can make the white area smaller by adjusting the pie chart size, the white background remains visible. Is there a way to make this background transparent or remove it entirely in JMP 17 ?

Johanna

[#8]

Hi @johanna_younous , 

Welcome to the conversation.

When I first joined this conversation, I had white backgrounds in my graphs too.

By the time I did the presentation I mentioned above, I figured out how to make the background transparent.

I used the following JSL script to make the white pixels transparent in my table of images where the name of the column of graph images was "Graph".

dt=CurrentDataTable();
For Each Row(
	{r, g, b} = dt:Graph[] << getpixels( "rgb" );
	a = !AND(r == g, g == b);
	dt:Graph[] << setpixels( "rgba", {r, g, b, a} );
);

This also makes gray pixels transparent where the red, green, and blue color components are all the same. I had some gray in the background too. 

I hope this works for you.

~John

[#9]

Thank you @John_Powell_JMP , 

Unfortunately, this loop is not fully working for me, and I 'm struggling to figure out why.

When I run the full loop, the white background on my graphs is not removed:

); 
dtgraph= Graphbuild<< Make Into Data Table( );

For(  i=1, i <= nrows(dtgraph)  , i++,       //i=3
    img =dtgraph:Graph[i] ;      
    {r, g, b} = img << getpixels( "rgb" );
    // Pixel coloré → alpha = 1 (opaque)
    // Pixel gris/blanc/noir (r==g==b) → alpha = 0 (transparent)
    a = ! (r==g==b);
	    Wait(0);
	img << setpixels("rgba", {r, g, b, a});  

    Wait(0);
    dtgraph:Graph[i] = img;
);

But if I run this step by step, the update is successfully applied to the first row!

    img =dtgraph:Graph[1] ;      
    {r, g, b} = img << getpixels( "rgb" );
    // Pixel coloré → alpha = 1 (opaque)
    // Pixel gris/blanc/noir (r==g==b) → alpha = 0 (transparent)
    a = ! (r==g==b);
	    Wait(0);
	img << setpixels("rgba", {r, g, b, a});  

    Wait(0);
    dtgraph:Graph[1] = img;

This is driving me crazy so far. I'm guessing it might be a question of update timing or something linked to the Expression type column?

Any insights would be greatly appreciated :) 

Johanna

[#10]

Meanwhile, I managed to get it work in the most surprising way ( after I went through a long journey of tests and fails as can testify this really suboptimal script) 

dtgraph= Graphbuild<< Make Into Data Table( );

For(  i=1, i <= nrows(dtgraph)  , i++,       //i=6;
    img =dtgraph:Graph[i] ;     //  
     img1=char(img);
    {r, g, b,a1} = img << Get Pixels( "rgba" );
   a2 = !AND(r == g, g == b);
	    Wait(0);
	eval(parse( "img << set Pixels(\!"rgba\!", {r, g, b, a2})"  ));
	img2= char(img);
	print(img1==img2);
    Wait(0);
    dtgraph:Graph[i] = parse(char(img2));
    img=empty();
); 
print("fin loop1");
//exact same loop !! 
For(  i=1, i <= nrows(dtgraph)  , i++,       //i=6;
    img =dtgraph:Graph[i] ;     // 
     img1=char(img);
    {r, g, b,a1} = img << Get Pixels( "rgba" );
   a2 = !AND(r == g, g == b);
	    Wait(0);
	eval(parse( "img << set Pixels(\!"rgba\!", {r, g, b, a2})"  ));	
	img2= char(img);
	print(img1==img2);
    Wait(0);
    dtgraph:Graph[i] = parse(char(img2));
    img=empty();
);
     print("fin loop2");

// log output

1
1
1
1
1
1
"fin loop1"
0
0
0
0
0
0
"fin loop2"

It's a really, really weird behavior, but since it works, let's say that's good enough: I spent way too much time on this problem ^^

I would still be really interested in any explanation on this phenomenon. 

[#11]

@johanna_younous , 

While I'm glad you were able to find a solution and share it with the community, I agree that there is probably a simpler, more efficient solution.  It could be that "For Each" loops have advantages over "For" loops. 

I was surprised to see that you used "rgba" in the Get Pixels function, but maybe after running the script once, the pixels in the images had an alpha component. 

Where I used my script, the images were in a separate data table and linked using virtual join. That may be different from your situation, causing the change in images to be reflected immediately for me. 

Maybe someone in the community with more JMP scripting expertise than I will be able to provide a simpler solution or explanation.

Thanks,

~John