Issues with Average Function
I have detailed biweekly pay data where I am looking for the average hours worked in every region per week (using a basic calculated field). This functioned well for 6 months but became an issue at the start of the year. Rather than finding my typical averages, suddenly the data is showing me trillions of hours in every region. My support team told me I have a excel/date formatting issue, but even after fixing this the averages are not working. If I pull a sum, the hours look reasonable, but if I change the aggregate on my card from Sum to Average, again the average fails. I attempted to reupload my 500,000+ datasheet hoping it would fix what might have broken earlier in the year but this also was no help. I don't know what else to do.
Best Answer
-
Have you attempted to do the average in a beast mode?
SUM(`Work Hours`) / SUM(1)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
Are you manually uploading into domo from your spreadsheet? First step in validation would be to make sure your average function still works in excel. Then, I'd try uploading a small subset of the data (maybe just this week's averages?) to try and see if the issue persists.
0 -
Yes, I was manually uploading into domo from Excel. I have exported the data from DOMO to Excel to include the last 365 days' worth of data (as it would appear in my card), pivoted to get the average and it looks just fine. I did the same to my most recent report (this week's upload) prior to uploading to DOMO and it too looks as expected. After uploading this new test data set into DOMO, I took it to Analyzer, selected my Regions on x axis, put my hours on y axis and I still see trillions using any kind of average function.
0 -
@MisterJimenez Could you please share a screenshot of what you see in Analyzer?
0 -
sure!
0 -
@MisterJimenez What chart type are you using? Is it the standard bar?
0 -
Yes, that is the standard bar.
0 -
Have you attempted to do the average in a beast mode?
SUM(`Work Hours`) / SUM(1)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
I did not try that! This seems to have done it!
Why does this work when the other methods fail?0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 96 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 705 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive