conditional default preselections for Analyze UI due to recent `type=required` addition

Follow-up to !1474 (comment 292440493)

One minor note is that I think that this will select the first column even if a required column is set bellow it. If that's true, this should not be the case in the presence of required attributes: We auto-select the first column cause we want to show a report on load and we are not sure what to show. But when a required attribute is set, we know that the intended behavior is to use that column, so why also select the first one?

FWIW I anticipate this being < 30min (likely much less)