Best Of

You just need to utilize aggregates in your beast mode to add all of the elements in the group before determining the percentage.

SUM(`performed`) / SUM(`projected`)

You can then format that as a percentage to display correctly.

The problem with the Total Row column is that it adds everything together so if you're at 80% for both weeks it'll think it's 160% instead of the 80% across the total.

You could try and union / stack your data such that there is a "Total" recruiter the the aggregated data but that won't allow you to see those total records if you're filtering on a specific recruiter.

Also, by utilizing a window function in a beast mode it'll properly handle any filtering done to the cards instead of doing it within an ETL.

Awesome! Glad to hear it @user028768

If you could mark my answer as accepted for others to make it easier to find I'd appreciate it. Thanks!

Hi @user048760

What you're wanting to do is possible by utilizing a date offset dimension. Essentially you'll have records for each day for current, lat week, last month, 2 months ago, whatever you want to define your offset / period definitions. There's been several write ups about this specific topic on the Dojo before. I've written on this topic here: https://dojo.domo.com/discussion/comment/50540#Comment_50540

Short version:

• Create a list of dates (use the dates Domo dimension dataset) with offsets (I used a MySQL DataFlow )
• Join your dataset to this offset table on the date field in your dataset and the comparison date in the offset dataset
• Use the report date in your reports and filter the offset period type (last week, 2 months ago etc)

This will allow you compare a single date to whatever time ago you define. You can use beast modes to define your differences over the different periods. For example -

YoY

SUM(CASE WHEN `Offset` = 'Current' THEN `Value` ELSE 0 END) - SUM(CASE WHEN `Offset` = 'Last Year' THEN `Value` ELSE 0 END)

MoM

SUM(CASE WHEN `Offset` = 'Current' THEN `Value` ELSE 0 END) - SUM(CASE WHEN `Offset` = 'Last Month' THEN `Value` ELSE 0 END)

@jaeW_at_Onyx has a good video of this process as well: https://www.youtube.com/watch?v=CDKNOmKClms

Hi @user000253

The histogram is fairly limited in the customization options. Currently you can't customize the number format for the bins. I'd recommend offering this as a product feedback (https://knowledge.domo.com/Welcome/Getting_Started/Submitting_Domo_Product_Feedback)

You could use a bar chart and custom bin labels as I've mentioned here: https://dojo.domo.com/discussion/comment/53208/#Comment_53208

If you are adding together multiple values and one of them is blank or null, it will not be able to add them all together and just produce a blank value. You would need to do this: IFNULL(likes,0) + IFNULL(shares,0) + IFNULL(comments,0) in order to add them together. If the fields aren't actually null, but blanks, you would need to do CASE statements around them as well to replace that with zero. I find it easier to clean these types of data issues in the ETL so then my beast mode is easier to read.

Also, to deal with the the incomplete months, you can add the DAY function just like you did the MONTH function but say when it is <= instead of = to.

Hope this helps.

You would just create multiple WHEN statements. You can have as many WHEN statements as you want in a CASE statement. Yours would look like this:

(case when (`Distributors`='DistributorA' and `Country`='CountryA') then 'Distributors'

when (`Country`='CountryB') then 'Distributors'

else 0

end)