Solved: Chart counting cells within a ranged number value - Page 2

Jerome_Canete · 07-05-2020 09:28 AM

Hi,
Pls help. I have a number type column called [Distance] and i wanted to make a chart showing based on conditions that for example, count all the cells that belongs to a range like from 0 to 9.99 and likewise count all cells having values that are equal 10 and above. Can’t seem to figure out how.

LeventK

You need to construct 2 Virtual Columns for that initially and then use this 2 columns for your charting:

COUNT(
    SELECT(
        TableName[Distance],
        AND(
            [Distance]>=0.00,
            [Distance]<=9.99
        )
    )
)

COUNT(
    SELECT(
        TableName[Distance],
        [Distance]>=10.00
    )
)

View solution in original post