Display 'DISTINCT' Count in Infographic

Discussion created by jcibor on May 2, 2019
Latest reply on May 2, 2019 by jcibor

I have an app where I have several infographic widgets displaying various counts. The infographics work off of Extra Data Sources that are built off of a map layer. This is done so that the map and all counters adjust to filtering via the filter widget, and so the infographics display counts for the entire data set and not for current extent. I would like one of those counters set up to display a count of just distinct values. In standard development I would add a DISTINCT function to my Select statement. Does anyone know of a way to do this with a fairly low level of effort? Is the only option to customize the widget or is there a way to hack this in the configuration files? There does not seem to be any out of the box support for this.