Summary dataset (from detailed dataset)
We have a dataset (agent hours) that contains cumulative/summary data by status/day, and a beast mode to determine the total number of hours worked (something along the lines of start time - non work activities/statuses - end time = total actual hours worked), plus another dataset that is detailed/transactional for commissions paid on every offer# provided by an Offer Agent that was ultimately accepted & completed.
It's unclear if the summary dataset we have was imported that way, or if a transform of sorts was done, and I've nothing comes back in Domo searches to locate information on HOW to create a summary dataset from a detailed one, or if it's even possible; hoping to get some assistance or pointed in the right direction on how we can accomplish this, preferably using ETL since my SQL understanding would not be adequate.
To summarize (no pun intended!), we want to take a detailed dataset and make it into a summarized dataset of commissions paid, by agent, by day in Domo so that we can join ith with an existing summary dataset that provides the agents total hours worked that day in order to arrive at an "hourly rate" based on commissions paid/hours worked.
Hope that makes sense, and thanks in advance for any assistance you can provide!