I have a large data table that I allow the user to filter down to a product to then create a subset and control charts. Products use different combinations of parameters so the main table and subset have empty columns that differ for each product. I would like to solve one of these problems:
How can I create a dynamic list to feed into the control chart builder to only plot the parameters that are not empty for a given subset?
How can I remove empty charts from the control chart builder after creation?
As an example, I have attached a subset of the Hot Dogs table with some parameters removed by Taste. Calories now has no data for all dogs with a Medium taste. In this instance, I would like to have every parameter plot but Calories, though it may be a different parameter for other Tastes.