ccccc4 Member

It's getting closer. Now, it starts with the dollar amount but also grabs everything that comes after that. case when REGEXP_LIKE(trim(`body`),'^.*USD\s+(\d{1,3},\d{1,3}\.\d{1,2}).*') then REGEXP_REPLACE(trim(`body`),'^.*USD\s+(\d{1,3},\d{1,3}\.\d{1,2}).*','$1') else 0 end

I tried this and am getting the same thing. The preview renders, but the output is empty. I'm not doing any other operations after this in the dataflow. CASE WHEN REGEXP_LIKE(`body`, 'USD\s+\d{1,3}(,\d{3})*(\.\d{2})?') THEN REGEXP_REPLACE(`body`, '.*USD\s+(\d{1,3}(,\d{3})*(\.\d{2})?).*', '$1') end

No matter which combination of base url and dynamic parameters I use, it doesn't work. I can't seem to get around the "?=" it inserts in between the base url and parameter. This might just be a limitation of the Domo connector. Appreciate your help!

No matter how I divide up the URL into the base part and the dynamic part from the dataset, it seems to insert an additional "/" into the resulting url. Even if I structure it so the slash fall where one of the slashes in the url is, it returns an invalid url

I built a P&L card by grouping the accounts/lines of the P&L and then EBITDA is the total row, and the sections of the P&L are subtotals. What if you group the sections of the P&L into EBITDA and Non-EBITDA and use that as an "outer" grouping in the pivot table? So then EBITDA becomes another subtotal and Net Income is the…

Thanks Marcel! If I could use a dataflow or view to pre-aggregate by Div_Order_Num, I think this card would be very easy to build. Unfortunately, the person who requested it wants the ability to filter the data by individual labor activity types within each Order (Mechanical, Engineering, Painting, etc.) This means that…

I feel like I've seen before what you're referring to, but the Total menu only gives me options for formatting the total row style options

Since the beast mode is "pre-aggregated", the field settings don't have the option for choosing which aggregation type

We've gotten around this by separating the symbol series into two separate beast modes, and then using color rules on each. So instead of one "net" beast mode, create a "net >= 0" beast mode and a "net < 0" beast mode.

Once subtotals are added, I can see the ability to collapse rows, but not columns.