I am trying to determine the most common price used for a particular item and cannot figure out which function to use. In Excel, I would use 'Mode" so I am trying to find the equivalent function in Sigma.
There is not a “Mode” function in Sigma currently, but there are a couple of ways you can find the most common value. The first option would be to group by this column, then you can add a new column with the formula “Count()”. The highest value in this count will be the most common value! The other option would be to click the drop-down menu and select “Column Details” this will bring up a screen of a histogram with the most popular values!