In JMP report, is it possible to create a table, add "autoshape", and save as html?

shaira

Hi,

I am trying to work on a script that takes a data table, does a data integrity check based on several aspects, and then feedbacks if data is good or bad.

Flow is as follows:

1. Input data table, output relevant graphs, save as interactive html. => I can manage this.

2. Add link to the graphs in a master directory html ==> I'll use this https://community.jmp.com/t5/Discussions/URL-in-report-via-JSL/td-p/16634

3. In the master directory html, I wanted to add a color indicator (e.g. red circle or green circle) to indicate if data passed the criteria. It kinda looks something like a table below:

Test ID   |       Date         |   Failure Rate              |  Data Drift                     |  Correlation                |

12-345   |    18-09-20     |  <red circle>  <link>      | <green circle>  <link>    |<green circle>  <link>   |

02-333   |    18-09-20     |  <red circle>  <link>      | <red circle>  <link>        |<red circle>  <link>       |

11-445   |    18-09-20     |  <green circle>  <link>  | <green circle>  <link>    |<green circle>  <link>   |

 

So, I kinda have an idea on how to add links and create table layout for the directory html. But I want to know how to add the red and green indicator. Doesn't have to be a circle, just a solid shape with red/green color will do.

 

Any ideas?

 

Thanks,

Shaira

gzmorgan0

Create a picture of the symbol you want with some graphics app like Paint: one red one and one green one. I suggest making a separate column for the symbols.  An alternative is to color the cells. The script to produce these pictures is attached.

 

ColorSymbolCell.jsl