Fixed filter allow : multiple allow

Adrien
Adrien Member
in Beast Mode

Hello,

maybe it’s me, but I don’t seem able to specify multiple dimension in the filter allow or filter deny using the fixed function ?

When I try it, only the first column is used, not the other.

ex : sum(sum(count) fixed (by ‘name’ filter allow ´date’, ´region’))

’date’ will work but not ´region’

Answers

  • GrantSmith
    GrantSmith Coach

    It should allow multiple columns with a comma. Is your code using back ticks ` or actual forward ticks´ and it's just a copy and paste issue?

    The documentation clearly outlines multiple columns are allowed: https://domo-support.domo.com/s/article/4408174643607?language=en_US

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Adrien
    Adrien Member

    Thanks Grant !

    Yeah the document was saying it was allowed but I was not able to. But found out why finally.

    My problem was that I tried to fixed and allow a filter that also affected the list of named showing in the card. Dumb error lol.

    For the tick, they were ok in my code, just not ok in my translation here on the forum :)

Categories