Static national average not affected by filters

Reply
Highlighted
White Belt

Static national average not affected by filters

Hi,

 

I am looking to create a DOMO card with a static national average line that does not change with filters. The goal is to be able to compare a filtered view against that national average directly in the card. 

 

Has anyone done anything similar?

 

Any help would be greatly appreciated. 

Highlighted
Major Brown Belt

Hi @user007952 ,

 

You might be able to accomplish this using an ETL to calculate the national average since you can't do this as a beast mode as filters would affect the number. Take your data and calculate the average. Then adding a constant (Call it "join column" and set the value to 1) on both your calculated average dataset and the original dataset. Join them both together on this join column and then you should have the national average as a value for each row in your data table. You can then plot this line using an appropriate graph.



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**
Highlighted
Major Red Belt

There is a beta feature in development that will support this.  talk to your CSM.  I believe it's called filter groups.


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Announcements
Stand out in the Dojo: Choose your own recognizable username and add a unique profile photo in your profile settings.