Customize Dynamic Filter

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Acknowledged
The Dynamic filters on the left of a report are great, but when there's a ton of values it can become a bit cumbersome. 

Is there a native way to customize the look/input type of the dynamic filters, to ideally help with such a situation? 

Thanks
Photo of Alex Gale

Alex Gale

  • 1,462 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,368 Points 10k badge 2x thumb
Hi Alex,

When in the report there is an option to Customer this Report and open up the report settings. Near the bottom there is a header specifically called out for filters and an option to change that reports dynamic filters where you can set them to use the default dynamic filters (set in your tables report default settings), have no dynamic filters, or to use custom dynamic filters that you select. This allows you to pick out fields that are more relevant as dynamic filters and remove fields with so many choices they become less helpful. It doesn't allow you to alter the data in the fields to trim down options but can help you to assure a report has more useful dynamic filters. I hope this information is helpful Alex. 
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,368 Points 10k badge 2x thumb
Yes unfortunately there isn't an option to set up a Dynamic filter to be searchable right in that side pane. A report can be set to use an Ask the User filter in the report settings. For example set up so that I can search Company Name by Ask the User. This way when the report is opened they could type in part of a name and all the possible matches would be returned when they hit enter. The problem with this is it does not provide many prompts for the user while still typing values in, it doesn't search until they finish. Thank you very much for your time today Alex. 
Photo of Alex Gale

Alex Gale

  • 1,462 Points 1k badge 2x thumb
I didn't know about that ask a user filter. That might end up coming in handy. Thanks for your help. 
...or just use the filter box at the top to type in the "filter" you want. 
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
..or just splice in some script and implement precisely what you want.
(Edited)
Photo of Alex Gale

Alex Gale

  • 1,462 Points 1k badge 2x thumb
Ya the users could just use the search box, but in this specific situation sometimes other fields may have the filter values in them incidentally. It's still by far the easiest solution since it's already built in, I just have to teach the users about it. 
Photo of Adam Keever

Adam Keever

  • 1,994 Points 1k badge 2x thumb
Is it true that you cannot use a formula field as a filter in a report?
It used to be true,  but that was enhanced maybe a year or two ago, so that any text formula field can also be a Dynamic Filer.
Photo of Adam Keever

Adam Keever

  • 1,994 Points 1k badge 2x thumb
Thanks Mark!
Photo of Adam Keever

Adam Keever

  • 1,994 Points 1k badge 2x thumb
Snap. Do you know how i can take a date field and return just the year then convert it to text?
Photo of Adam Keever

Adam Keever

  • 1,994 Points 1k badge 2x thumb
Nevermind... just used left since the year is the first four digits in the field.