display variable values in UI filtered by Dependent (Forecast) Variable and the line type (statistic)

[TatianaBurek]

Currently we use Dependent (Forecast) Variable to find values for the field (fcst_thresh).
This is the example of the query:
SELECT DISTINCT fcst_thresh FROM stat_header WHERE BINARY fcst_var IN ('HGT') ORDER BY fcst_thresh
Include the line type (statistic) to make the result list shorter and more meaningful

[TatianaBurek]

From Ying:
An example is the AWS database mv_ylin_metplus, which contains thresholds for 24h and 3h CTC stats and 24h/6h FSS. Thresholds for the 24h CTC are

gt0.254, gt2.54, gt6.35, gt12.7, gt19.05, gt25.4, gt38.1, gt50.8, gt76.2, gt101.6; (threshold group 1)

For 3h CTC they are
gt0.254,gt0.508,gt1.27,gt2.54,gt6.35,gt12.7,gt19.05,gt25.4; (threshold group 2)

For FSS (6h or 24h) they are
gt1, gt2, gt5, gt10, gt20, gt50 (threshold group 3)

In the current METviewer, when I choose the threshold as independent variable, all the above values show up in the selection window. If there’s a way to use the Y dependent variable to sort the thresholds that’d be great, e.g. if the attribute stat selected is NBR_*, then only thresholds in "group 3" above shows up; for non-neighborhood CTC scores, “group 1” for Dependent variable of APCP_24 and “group 2” for APCP_03.

[TatianaBurek]

This will increase the time to find values and display them in the UI. It can bring other complications such as:
Possible complications:
-user did not select a statistic
-user selected more than one statistic
-user selected a statistic that can be calculated with or without aggregation (for example, BASER)