What i want to be able to do is to be able to customize the PCI ranges at the left side without hard coding the ranges. This means when i filter , for example PCI from $200 to $1,500. The first row might show something like >= $200 to <=$1,500. Basically to be able to define my own ranges and to display it in the table. Please help if you have any idea.
(An idea i had was to create columns with no values and then put them as dimensions and then use the PCI range to toggle around. I am unsure if it is possible)
You can use a class() function for the PCI dimension but the interval has to be fix for both intervals (0-100, 100-200, ...). If you need to user different ranges (0-200, 200-1500, ...) you have to do it in the script. Using an intervalmatch you can get it.