Best Of

Re: CRM Sales Formula Help

Mark I need to buy you a drink!!! :) Thank you! Worked like a charm!

mattwelykholowa

1

Re: Is it possible to calculate 6 months of data for a metric?

Thanks Mark. This was very helpful.

vikrao

1

I would suggest doing this in Magic ETL since you need to access previous rows. You can do this by filtering to Inherited Sale = True and then join it back to your original dataset and choose left join with your original dataset being on the left side. Join on Engagement ID and and Full Name. Records that show from the filtered tile, will be your Referred By column. The ETL would look something like this:

MarkSnodgrass

2

Re: Magic ETL - Group By Tile - Sum Multiple Integer Columns

@MarkSnodgrass Solution worked!

The two issues i've posted in the Dojo so far have been a result of Null value issues. Maybe I need to take a step back indeed!

Thank you Mark!

DigitalAviator

1

Re: Best way to filter on trends in a chart

Not sure if this is what you are going for, but I put together how to get the Top N of a Subcategory that may help you.

https://youtu.be/hfIUQqeRVkM

Hope this helps.

MarkSnodgrass

1

Re: How do I return a string column value from the MAX() of another column value?

I need to do more testing, but on first glance the beast mode seemed to work. Thank you!

Pierce13

1

Re: Beast mode formula: Case When with distribution points

Try moving your count distinct to the very outside like this:

count(distinct 
(CASE

 WHEN `BRAND` = 'A' THEN 
 	(case when `Volume` > 0 then CONCAT(`CUSTOMER_NUMBER`,`BRAND`)end)

 WHEN `BRAND` = 'B' THEN 
 	(case when `Volume` > 0 then CONCAT(`CUSTOMER_NUMBER`, `SubBrand`)end)

 END))

MarkSnodgrass

1

Re: Empty plug in top left

Hi @Joshua98, welcome mate. So that 'M' logo seen in those videos is an example of a company logo of the instance users use. For your Domo instance, you can add in your company logo in place of that empty slot through Admin and then following the steps here: https://domohelp.domo.com/hc/en-us/articles/360043439053-Specifying-Your-Company-Name-and-Logo

amehdad

14

Re: Empty plug in top left

To add a bit more flavor, the M you see is for "Modo Corp" which is a fictitious company Domo uses for their demos.

GrantSmith

1