Using Fixed Function with Filter None but don't want to use the By argument.

Hi,
I have a SITE column. This column itself I have taken as a interactive filter. I want the total unique count of sites irrespective of what I chose in the filter.
Don't want to use By because I want the overall count of sites. This is giving processing error when I am filtering out some sites.
I am using something like this SUM(COUNT(DISTINCT Sitename) FIXED (FILTER NONE))
Best Answer
-
Have you tried using BY
Sitename
to see if it works? FIXED will generally perform a double aggregation, one at the level you specify in the BY clause and then the surrounding one at whatever level you're displaying in the card.
If the goal is to have a card in a dashboard that only shows this, then you could instead control which filters apply to that card at the dashboard level instead, so when using the interactive filter this one card will not be filtered, while the others will.0
Answers
-
Have you tried using BY
Sitename
to see if it works? FIXED will generally perform a double aggregation, one at the level you specify in the BY clause and then the surrounding one at whatever level you're displaying in the card.
If the goal is to have a card in a dashboard that only shows this, then you could instead control which filters apply to that card at the dashboard level instead, so when using the interactive filter this one card will not be filtered, while the others will.0 -
By Sitename doesn't work. It doesn't give overall number of sites present.
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 437 Beast Mode
- 23 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive