Calculating True AVG of column with same value
Hi,
Am I missing something or misusing something? I have this beastmode to calculate the True average of a column called Days_In_Service, however it just appears to be adding up the distinct values and not dividing them. If the Unit# is the same then the days_in_service will be the same. I am trying to avoid the situation where if the days_in_service are the same but have different unit# then the days_in_service wont be counted due to using distinct.
Any help is appreciated, Thank you!
Here is the beastmode. The output for this beastmode is 29,150 instead of 14,575.
SUM(DISTINCT Days_In_Service
) OVER (PARTITION BY Unit#
) / COUNT(DISTINCT Unit#
)
Here is a snippet of my data.
Best Answer

SUM(MAX(
Days_In_Service
) FIXED(BYUnit#
)) / COUNT(DISTINCTUnit#
)If I solved your problem, please select "yes" above
0
Answers

SUM(MAX(
Days_In_Service
) FIXED(BYUnit#
)) / COUNT(DISTINCTUnit#
)If I solved your problem, please select "yes" above
0
Categories
 All Categories
 1.8K Product Ideas
 1.8K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 296 Workbench
 6 Cloud Amplifier
 8 Federated
 2.9K Transform
 99 SQL DataFlows
 614 Datasets
 2.2K Magic ETL
 3.8K Visualize
 2.5K Charting
 727 Beast Mode
 53 App Studio
 40 Variables
 677 Automate
 173 Apps
 451 APIs & Domo Developer
 45 Workflows
 8 DomoAI
 34 Predict
 14 Jupyter Workspaces
 20 R & Python Tiles
 394 Distribute
 113 Domo Everywhere
 275 Scheduled Reports
 6 Software Integrations
 121 Manage
 118 Governance & Security
 Domo Community Gallery
 32 Product Releases
 10 Domo University
 5.4K Community Forums
 40 Getting Started
 30 Community Member Introductions
 108 Community Announcements
 4.8K Archive