Context: JMP 17
Hi all,
I am working on a dashboard project where I use a function to generate a bunch of different plots that get stuffed into a big grid for the user to browse. That function handles the plot generation and has its own Where() clause to select from a larger data table which contains lots of other data. The grid of plots then sit inside a local data filter so I can do some high level filtering by data vintage. The plots all automatically recalc so the entire dashboard responds as desired.
The next step is to include a set of custom summary statistics (the plot platform summary statistics are not sufficient) for each of the plots. I'm fine using the same where clause as the plots to subset by the specific parameter but the summary statistics also need to be aware of the state of the LDF and update accordingly which is where I'm struggling.
My first pass at the problem works by subsetting the big data table with the same where clause as the associate plot, then running a Summary() on that subset and following up the summary by deriving some new columns, renaming old ones, cleaning it up, etc. and then spitting out the result with Get As Report() packaging that with the plot, wrapping both the plot and the statistics in a V Splitter Box, and then returning that V Splitter Box to be inserted into the dashboard grid. However, this approach doesn't seem to be capable of recalculating when the LDF is changed.
Am I taking the wrong approach by subsetting, summarizing, and postprocessing the summary? Is there a better way to do this? Is there a way to make a block of code LDF-aware? Even if this works, would I be stuck needing to keep all of the little subsets and summaries active? That might be enough reason to find an alternate approach...
Sorry, I don't have an easy way to include code examples so I'm just looking for architectural direction at this point.
Thanks!
