Forum Discussion
Categorising a column
JorgePinho Yes, the threshold range should be changing dynamically. And my sample data is,
Current Period-
| Name | Purchase_Score | Purchase_Level |
| Jenifer | 381 | Very High |
| Josh | 139 | High |
| Kiran | 139 | High |
| James | 98 | Medium |
| Carolin | 62 | Low |
| Jerin | 1 | Very Low |
| Chris | 1 | Very Low |
| Ben | 0 | Very Low |
Next Period-
| Name | Purchase_Score | Purchase_Level |
| Ben | 432 | Very High |
| James | 256 | High |
| Kiran | 112 | High |
| Josh | 83 | Medium |
| Carolin | 79 | Medium |
| Jerin | 20 | Low |
| Jenifer | 1 | Very Low |
| Ben | 0 | Very Low |
Let me know if you need any further details.
Hi DianaChris
Can you help explain further how the threshold ranges change dynamically? They should change according to what? Is there any definite rules to define those dynamic ranges? Currently we cannot find the rules according to the sample data.
Best Regards,
Community Support Team _ Jing
Hello v-jingzhang , Suppose if I set the thresholds as-
Score > 400 =>Very High, Score > 300 && Score < 400=>High, Score > 200 && Score < 300 =>Medium etc.
In case in my next refresh the range of score is between 300(max)-1(min) then there will be no records falling under "Very High" category. Please correct me if my understanding is wrong.
So can you say directly what is the business rule you want to use to calculate the tresholds ?
