It seems that this functionality no longer exists in Domo. I am trying to graph data from the Quickbooks connection. The data category series appears in 2 different columns. I want to add each of these to the Series on a vertical bar graph, but can no longer add 2 series to a chart. I know I was able to do this in the…

It sort of worked, but still wasn't exactly what I was trying to accomplish. I solved this by using a dense_rank function.

I tried that and it still outputs multiple rows for each order. I grouped by order_id and the order_date (taking the max(order_date) as most recent), but it still outputs 2 rows for a user with 2 orders.

Is there a way to add just a single Count aggregate column while also maintaining all the other data for a single user? Some of the data might be different for various fields (such as order_date which is different for each order), but I want just 1 column for a user with a given name, email, etc. and all the other info…

That defeats the purpose of grouping by the user_id. That is still outputting multiple rows for an individual user_id. If a user has 3 orders it displays 3 rows. I want to consolidate this into 1 row.

I am joining the data based on the user_id's in both tables. Then I group by the user_id from the Users table and count the order_id's from the Orders table. This drops all my other columns and leaves me with just the two columns that get pulled into the Group By transform. I want the Count column to be added as an…