3 Replies Latest reply on Apr 9, 2018 6:32 AM by Sasha Hanna

    Histogram of group aggregates

    Konstantin Miller

      I have a data set containing sensor data, each row represents one measured value. There are three columns: SensorID (well, the ID of the sensor), Value (representing the recorded value), and a boolean column HasAnomaly, which an anomaly detection script sets to True if it flags the row as anomalous.

      Now I would like to plot a histogram of the number of anomalies over different sensors. So, in SQL terms, I would like to plot a histogram of sum(HasAnomaly) over (partition by SensorID).

      How can I do it in Tableau? If I select the dimension SensorID and the measure HasAnomaly, the histogram symbol in Show Me is greyed out, as it expects to receive only a measure.