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 | | | |
02-333 | 18-09-20 | | | |
11-445 | 18-09-20 | | | |
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, thanks! This is easily implementable and very helpful.
@John_Powell_JMP., thanks! I would consider interactive table as next step when I'm done with the basic table.
Regards,
Shaira
In case you're interested in your pass/fail table being interactive on the web page, you may be inspired by:
https://community.jmp.com/t5/JMP-Scripts/Export-to-HTML-with-Pass-Fail-Coloring/ta-p/21579
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.
