Want to add minutes of a particular day from different rows
I want the sum of downtime in minutes for a particular day. Eg: 14th May had a total downtime of 33 minutes. I want to have a single row for 14th May with downtime 33 minutes.
How can this be done?
Best Answers
-
In a table card:
- Add the date field
- Add the downtime in minutes field
- Change the aggregation for the downtime in minutes field to SUM as shown below:
If I solved your problem, please select "yes" above
0 -
It all depends on what want to achieve. In general if you just want to display the Date with the Total minutes you can achieve this the way @colemenwilson suggested, selecting only these 2 fields and setting your card to display by Day. This will give you a single entry per day with the Total Downtime for and this will even allow you to switch to see total downtime on different periods.
If you add other fields to the card, you'll get the total downtime at that granularity, like if instead you have Date, Ticket and SUM (Downtime) then what you'll be showing is the total daily downtime by ticket.
On the other hand if what you need is to show all entries but want the total Daily Downtime as another column, you can do this via BeastMode with the FIXED function (so that it'll be an additional column in the table you shared):
SUM(SUM(`Downtime in Minutes`) FIXED (BY DATE(`Start Time`)))
Keep in mind that regardless of the approach you'll need to define how you want to address if there is downtime entries that span across multiple days, like if it stars 2022-08-15 23:20:00 and ends 2022-08-06 01:17:02.
Hope this helps!
1 -
Make sure you have Aggregation set to Sum for the minutes_new field:
Your screenshot cuts off but if any unique values show in the table other than date it won't aggregate by date. Also check the sorting section in analyzer. If there is a sort enabled there with a field that is a timestamp for example then it won't aggregate properly.
If I solved your problem, please select "yes" above
0
Answers
-
You can either use subtotals and totals on your table or remove the unique fields from the table and aggregate by Date by summing Downtime in Minutes. If you add unique fields the table expands (unaggregates) to show the unique values.
So for the 14th of May, you have the start and end time fields, the Ticket ID, etc.. to show these the table has to expand and cant have a single row for the 14th because there are many different values for those columns: 02:19:00, 02:01:00, CRQ000003578158, CRQ000003571961, etc…
If I solved your problem, please select "yes" above
0 -
any other way to add up the minutes for particular day?
0 -
In a table card:
- Add the date field
- Add the downtime in minutes field
- Change the aggregation for the downtime in minutes field to SUM as shown below:
If I solved your problem, please select "yes" above
0 -
It all depends on what want to achieve. In general if you just want to display the Date with the Total minutes you can achieve this the way @colemenwilson suggested, selecting only these 2 fields and setting your card to display by Day. This will give you a single entry per day with the Total Downtime for and this will even allow you to switch to see total downtime on different periods.
If you add other fields to the card, you'll get the total downtime at that granularity, like if instead you have Date, Ticket and SUM (Downtime) then what you'll be showing is the total daily downtime by ticket.
On the other hand if what you need is to show all entries but want the total Daily Downtime as another column, you can do this via BeastMode with the FIXED function (so that it'll be an additional column in the table you shared):
SUM(SUM(`Downtime in Minutes`) FIXED (BY DATE(`Start Time`)))
Keep in mind that regardless of the approach you'll need to define how you want to address if there is downtime entries that span across multiple days, like if it stars 2022-08-15 23:20:00 and ends 2022-08-06 01:17:02.
Hope this helps!
1 -
thanks a lot.. this helped but this still shows duplicate entries. How do I get single entry for that day?
0 -
Make sure you have Aggregation set to Sum for the minutes_new field:
Your screenshot cuts off but if any unique values show in the table other than date it won't aggregate by date. Also check the sorting section in analyzer. If there is a sort enabled there with a field that is a timestamp for example then it won't aggregate properly.
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
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 621 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 743 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive