Filtering a table column

[Sheetal]

I have a table with the following columns

Date    |     5's    |   4's  |    3's  |  2's  |    1's

The 5's , 4's  etc is the count of a field called responsevalue in the view.

For 5's , The value should be a count of all responses where the response value is between 4.5 and 5. I am using the following query in the expression for column 5's, but not getting the desired output;

=if([Evaluation_Data$.response_value]>=4.5 and [Evaluation_Data$.response_value]<=5, Count([Evaluation_Data$.response_value]))

Can someone please help with this. Thanks.

[sunny_talwar]

May be try this

=Count({<[Evaluation_Data$.response_value] = {">=4.5<=5"}>}[Evaluation_Data$.response_value])

[dplr-rn · Accepted solution]

try set analysis

Count( {<[Evaluation_Data$.response_value]={">=4.5 <=5"}>} [Evaluation_Data$.response_value])

share some sample data so we can help further

[Sheetal]

Thanks. That worked.

[sunny_talwar]

Awesome, we are glad it did.