jasminwing's avatar
jasminwing
Advocate II
9 years ago
Status:
Needs Votes

Custom Filters

The functionality to be able to create a customised filter would be very useful. For example, if a column contains numerical values of item sold price you could create a custom filter which would allow the viewed to filter the data by set value ranges e.g. £11-£20, £21-£30, £31-40. Another example is: I have a column that shows the number of days since a client has been contacted. I want to set up a default filter to show different ranges e.g. less than 30 days, between 30 - 60 days, over 60 days. Currently, the only way I can do something like this is by creating an individual graph for each value range.

2 Comments

  • Hi - you just need to create a calculated column using the Switch(True () ,,,,) function https://www.youtube.com/watch?v=-ykkaAtlCMc FYI I think there is also a number visual filter now

Recent ideas