@Brett I found a work around by essentially moving all the filters that were in the visual into calculated fields with parameters instead, omitting the need for a PRE_FILTER LAC and was able to use distinct_count instead (which was really annoying but it worked).
However, I wouldn’t call the issue “fixed” since still occurs when I use any ifelse in distinctCountOver.
Here’s an example when I test the same calc using countOver vs distinctCountOver.
trial_sf_id is a UUID text field directly from the database with no nulls.
Both calculated fields save successfully.
Both calc fields save successfully.
But when I add them to visuals (any type, kpi, table, it doesn’t matter), distinctCountOver always throws a SQL exception error (not a ‘visual calc reference missing’ error).
This seems like a bug with distinctCountOver, but I’m not sure how to report it as such.
FWIW I’m not the only one encountering this issue, there’s another topic here along the same lines.