Best Of

Hi @rockchalk629

You won't be able to combine those three separate types of graphs however there is a Line + Stacked Bar chart which would allow you to get portions without the area piece.

Hi @jgospel

It's because of the extra columns you have displayed in your chart. Because you have Compliance Error, question_max_score and answer_value it's grouping by those so it's only looking at the compliance error within that specific group rather than at just the agent full name level. If you remove several of those columns that are for debugging your query will likely work.

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