Finding averages based on selected ID (client)
The data I am working is at an asset level (example below) and I would like to find the average of all client ages accurately when looking at any segment of asset.
Client | Account | Asset | Age |
---|---|---|---|
Client 1 | Acc 1 | Sec1 | 50 |
Client 1 | Acc 1 | Sec2 | 50 |
Client 1 | Acc 2 | Sec3 | 50 |
Client 1 | Acc 2 | Sec4 | 50 |
Client 1 | Acc 2 | Sec1 | 50 |
Client 1 | Acc 2 | Sec2 | 50 |
Client 2 | Acc 1 | Sec1 | 25 |
Client 2 | Acc 1 | Sec2 | 25 |
Client 2 | Acc 1 | Sec3 | 25 |
Client 2 | Acc 1 | Sec4 | 25 |
Client 3 | Acc 2 | Sec1 | 28 |
So for instance, assuming that asset levels Sec2 and Sec3 are of interest, I would like to be able to know the average client age for the clients who possess these asset (in this case which would be Client1 and Client 2).
Thank you.
Answers
-
Hi have you seen the FIXED BY functions in beast modes. This sounds like what you are describing in this case. Check out this article from the knowledge base:
Thanks
0 -
Charles, thank you for your response; however, I wasn't able to get the answer I am expecting from domo.
Any other ideas please? I am still very new to domo and still learning.
Thank you in advance.
0 -
@COYirenkyi I second @Charles_Fike's recommendation using FIXED functions since they provide a higher level of flexibility when aggregating data. If you are interested in the average age by asset, start by creating a card that displays the Asset as a dimension so that your data is grouped by Asset. Then you can use this beast mode as your measure:
avg(avg(`Age`) fixed (by `Client ID`))
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive