In List filter option not available
Answered
Hi,
I am trying to set up a filter for a chart. The variable I am using is flag which is stored as 0 (N) and 1 (Y). I have tried changing the variable to a reference code (flag).
When I add this variable as a filter it does not allow for In List.
Could someone please help.
Many thanks,
Mon
Hi Mon,
Could you please confirm which version of Yellowfin you are using?
Has the field been aggregated in any way?
Initially, it looks like the problem is that the data is in a metric/ date format, where it might be better to format it as a dimension. Are you able to test this by creating a calculated field with SQL, setting it to the field name? You can then use the calculated field as a filter to see if this changes the behavior. See below for reference.
Thanks,
Simon
Hi Mon,
Thank you for your question.
Could you please expand on what you mean that it doesn't allow you to filter 'In List'? Is the option not showing up at all, or are you not getting the expected results?
I have made an attempt to replicate this using sample data with no luck. Is the underlying data saved as a dimension or a metric? This might make a difference if it is saved as a metric.
Let me know how you go!
Regards,
Simon
Comments have been locked on this page!