How to add range filter on a column with numeric data?


#1

In our easy bi report, we have columns A, B, C
C has calculated the result of A-B.
Now we want to highlight or point data in C where the number is <x or number is between some range (0-5).

Any thoughts? moreover, column C will have negative numbers as well.


#2

Hi Charan,

Please try to use the formatting option. You can access it by clicking on the columns header and in the drop-down menu select “Cell formatting”. You will be presented with the configuration window where you can specify ranges or just the minimum or maximum values of the selected column and some cell formatting options.
You can read more about cell formatting on the eazyBI documentation page.

Kind regards,
Robert / eazyBI support