jaeW_at_Onyx Coach 
-
Re: Grouping using two criteria / subgroups / subtotals
Be advised, in your viz you're showing Josef / Milk = 0. A GROUP BY tile won't show the empty spaces, it will only show where data exists. To include NULL spaces you'd have to include the universe of…1 -
Re: Sum specific product sales from one e-mailadress
@user046467 , if you only care about Product 1 and 2, then count ( distinct CASE WHEN product in ('1', '2' ) then email end )1 -
Re: Sum specific product sales from one e-mailadress
@GrantSmith you're right. I think if it were me I would ListAgg all products purchased by email onto one row and then do a CASE with a LIKE with MySQL. either that or Group By and combine strings in …1 -
Re: Updating individual rows- dataset
Typically one doesn't update individual rows of data once it's stored in Domo. Mark is correct you can transform the entire dataset (and just define your transformation to target an individual row) .…1 -
Re: Percent of total by month in Pivot table
@user30972 , you are correct, mid Spring, Domo changed functionality so that PARTITION on calculated columns, month(SoldDate) no longer functions.1
