Fixed filter allow : multiple allow

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
-
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!**0 -
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 :)
0
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 182 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive