Best Of
Re: Workflow - Email Notification
Recluz, I would encourage you to replace the "Query Dataset" step in the template (new updated template should be out soon) with the new Query Dataset shape (click on the 3 dots on the upper right of the shape, and you should see that option).
Alternatively, you can edit the "currentRow" object variable to add the children (remember, this is case sensitive and type sensitive) and then call those children directly. That will save you having to use the "Get Text From Object" steps to extract them to additional variables.
Re: Documentation on Activity Log Event/Action Definitions
@eburns I love that idea! And I second that the more visibility into credit usage the better!
Re: Scheduling Dataflows with Multiple Notebooks Within a Single Jupyter Workspace
Hey Don, had a great time meeting you last week! Glad we could get this working for you.
Re: Carrying date range in hyperlink
@GrantSmith is there any update on this? I have a parent page that hyperlinks to several child pages and I need to be able to carry over the global date filter. Users are very confused by seeing a completely different date range when clicking through to a child page.
Alex_G
Re: Microsoft Powerpoint Ad-In Template and/or Card Title format customization
The new plug-in doesn't have the same features as the old one. You might be able to replicate what you want with a custom visualization but I'd recommend logging a ticket with Domo.
Re: Filtering by latest date in table
if you use @GrantSmith 's window function you will only keep rows on that max() date.
example. if you had a report where every day you sent the customer table, you could ask for "the most recent version of the customer table" and guarantee that you'd see every customer.
but if your question is, "i only want to see the most recent purchase from each customer" , each customer doesn't make a sale every day. so if you filtered on max(max(date)) ... then you'd only keep customers who had a sale on that most recent day (which would exclude a ton of people.)
so if you want the most recent row for each item you can still keep using window functions OR use a rank window function in ETL.
sum(sum(1)) over (partition by item order by date desc)
this will rank each transaction per item ordered by date desc. and you could filter by rank = 1.
do a rank window function in ETL with the same over() clause i outlined.
Please go back to the last UI design
Hoping others feel this way and it gains some traction? I know it's trivial, but still….
kevinJWS
Re: No undefined variables have been added to Variable list
You have a list of objects and you need a list of persons. Send me a DM and we can setup a call where I can show you.
Re: Display Row count at every step in Magic ETL
This is a great idea, Domo is silly for not implementing this sooner
Re: Replicate Spreadsheet P&L in Domo
If you add a row number column in your ETL you can use it to place a blank row between two other rows. For example, if I want a blank between Revenue and Wages I could assign a row number between them
And then I can hide column 1 in the chart properties:
This would create an empty row:
You can also play around with column widths in the properties but I don't believe you can selectively make certain columns wider or narrower
