Filter out Blank Verbatim Responses from Record Grid | XM Community
Skip to main content
Michael_Cooksey
Administrator
20 days ago
Solved

Filter out Blank Verbatim Responses from Record Grid

  • January 13, 2020
  • 4 replies
  • 541 views
Paul_Farrell
Level 2 ●●
Forum|alt.badge.img+5
Hi, I'm wondering if anyone knows of a way to filter out blank responses from a Record Grid by way of filters, or some other method? I have a record grid where i'd like to hide any rows of data where there is no response to a certain verbatim question. Creating a filter with the verbatim field only allows me to filter by keyword, but I don't know if there's any way to engineer filtering verbatims that are not blank? It would be preferable if this could be done in dashboard via filters, but if there's some other method to achieve the same result i'd be keen to hear. Thanks

Best answer by snhenderson

You should be able to do this by creating an advanced filter on the widget. Select Add Filter > Advanced Filter (should be at the top of the list) then Insert New Condition. Select the verbatim question that you want to filter on, then on the next dropdown, select "is not empty", and save the filter.
View original

4 replies

S
Level 1 ●
Forum|alt.badge.img+1
  • snhenderson
  • Level 1 ●
  • 5 replies
  • Answer
  • January 13, 2020
You should be able to do this by creating an advanced filter on the widget. Select Add Filter > Advanced Filter (should be at the top of the list) then Insert New Condition. Select the verbatim question that you want to filter on, then on the next dropdown, select "is not empty", and save the filter.
Paul_Farrell
L
2 people like this
  • Paul_Farrell
    Paul_Farrell
  • L
    LarsR
Paul_Farrell
Level 2 ●●
Forum|alt.badge.img+5
  • Paul_Farrell
  • Author
  • Level 2 ●●
  • 6 replies
  • January 14, 2020
In all my times using widget filters, i'd never even noticed the advanced filter option at the top of the dropdown! Thanks alot.
S
1 person likes this
  • S
    snhenderson
ashleigh_quaill
Level 3 ●●●
Forum|alt.badge.img+19

Hi all,
Just to follow on from this question - is there a way to toggle this on and off for users? For example, I want to configure it such that by default my record grid only shows responses where the open text questions are not blank, but I also want them to have the option to remove the filter. If I leave the filter as not locked, as far as I can tell users can change the entire advanced filter which is not what I want. I want to set the fields for the advanced filter and just let users turn it on or off.
Any suggestions appreciated!
Cheers, Ashleigh

Adam_Jermain
Level 2 ●●
Forum|alt.badge.img+4
  • Adam_Jermain
  • Level 2 ●●
  • 9 replies
  • October 12, 2022

ashleigh_quaill Did you ever find a solution to a comment filter that you can toggle on/off? I am trying to accomplish something similar to your situation, without much luck.

Leave a Reply


Terms & Conditions