Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
7 years ago

filtering out data that is blank

Please see attached screen shot.  I have some Modules with questions.  Not all modules have the same number of questions.  I am doing a funnel chart so I can see performance by question.  I have a sl...
Need Help
dax's avatar
dax
Community Support
7 years ago

Hi jcastr02,

It seems that Q1, Q2 is measure , right? You said you can't type value in less than field, what did you type before? It seems only recognize numeric type when it is measure. In addition, if you want to remove blank, you could set filter like below

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • jcastr02's avatar
    jcastr02
    Post Prodigy
    6 years ago

    Hello there, yes they are set as measures, but it won't let me type anything. Also, I've tried using the filter you described below but it's still not taking Q11-Q15 out of the chart.  They show up as empty spaces.  

    • jcastr02's avatar
      jcastr02
      Post Prodigy
      6 years ago

      Hello, Here is another example of where if I select a certain item in the table, I don't want to see values that are equal to 0 or have no data?  I've tried to use the filters you mentioned above, but they still show up?