Forum Discussion

AndrewPF's avatar
AndrewPF
Icon for Helper V rankHelper V
3 years ago
Solved

change variable from text to numeric - visual filter no longer works

I have a basic bar chart with business name as X-axis and score as Y-axis.  I have also applied some filters to restrict the data being displayed.  One of these filters used a field of type text.  ...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi AndrewPF 
    Text and numbers filters are behaving differently.
    The text has functionalities as :

    When at numbers you should use mathematical operators + logical and/or

    So if you change the data type of your filter field you need to modify it according to its options.
    For a more detailed explanation please attach a link to some dummy file.
    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

     

     

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

Hi AndrewPF 
Text and numbers filters are behaving differently.
The text has functionalities as :

When at numbers you should use mathematical operators + logical and/or

So if you change the data type of your filter field you need to modify it according to its options.
For a more detailed explanation please attach a link to some dummy file.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly