GrantSmith Coach

Correct. It can get quite large so if you're not needing specific periods for comparison with your dataset you can filter them out before you join your data.

COALESCE(`rate`, 0) Coalesce also works. It returns the first non-null value supplied. This is assuming your data is actually NULL and not an empty string. If it is you can force it to be null: COALESCE(NULLIF(TRIM(`rate`), ''), 0) TRIM to strip whitespaces at the beginning and end of the string for good measure. Also to…

Are you referencing Adrenaline Data Flows or just Adrenaline in general as used by Beast Modes and DataSet views?

Domo aggregates your data based on the groupings you're using in your card. So in your example if you're doing it at a Zip code level it would have 5/10 (50%) and 400/100 (40%) If you remove the zip code field and replace it with the county it would pull all the values that match that criteria / buckets you've defined so…

How are you wanting QA_TimeStarted and QA_TimeCompleted and CA_DateAccess handled? Most recent time? Drop them? It sounds like you just want to us a Group By tile on the UE_OrgUnitID, OU_MasterCourses_CourseName, OU_CounselsA fields and take the MAX of the DP_DatePosted field.

@MarkSnodgrass - Clever hack!

Are all your tiles highlighted or are there some that are greyed out (I'd look at these if you have any)?

Yes, page filters apply to the datasets powering DDX Bricks.

Try something like this: CASE WHEN `source_name` = 'shopify_draft_order' OR (`referring_site` IS NULL AND `landing_site` LIKE '%invoice%') THEN [DO STUFF HERE WHEN IT MATCHES YOUR CRITERIA] END

There isn't a way to copy the list of shared users from one page to another easily. You'll need to manually share the page with each user / group.

@ozarkram You can't do aggregation or filtering in a formula tile. It's only simple calculations or functions are allowed. As @mhouston stated, use a filter tile to filter your dataset to get the current date, and then do a group by tile to get the max fiscal date.

If your revenue amount the amount for the total contract on each line item or are you needing to add all the line items together to get the total revenue?

Have you tried using an alter column tile to change your data type to a string before your formula?

There’s many ways to do this. One way is to select the last day of the month and then subtract the day number of the month minus one LAST_DAY(`Date`) - INTERVAL (DAYOFMONTH(`Date`) - 1) DAY

IN a magic ETL Use a full outer join on the id columns and then you can filter the join where table a’s ID is null OR table b’s ID is null

This is because you're attempting to compare the min and max values against each other. The only time this will be true is if you're looking at a records with a single Period End Date value. Once you go to the entire year the minimum value will never be the maximum value. If you're wanting to display a message to have the…

How do you calculate month 1 or month 2? What about months after 3? You'll likely need some sort of CASE statement using a DATEDIFF + CURRENT_DATE function to count the difference between two dates but you'll need the different logic for other months besides month 3 CASE WHEN DATEDIFF(CURRENT_DATE(), `date_created`) > 131…

Instead of keeping this logic within a beast mode I'd recommend using another dataset (Excel upload, Webform etc) with each of the different plant types and their goal for the day of the week and then use an ETL to left join your dataset to the goal dataset and then using a coalesce in a formula tile to set a default goal…

Hi @Fatias I'd recommend setting up a date dimension dataset and creating your own PoP card to give you more flexibility. I've done several videos and writeups on this. You can read more on it here: https://dojo.domo.com/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest

Are you using a MySQL dataflow or a Magic ETL data flow?

Are you wanting to have the iframe clickable and take you to a new domo page or are you wanting a link/text inside your iframe to go to the new page?

Do you have some anonymized data you can share t o better understand your data structure?

Try something like this CASE WHEN SUM(`Open qty`) > SUM(`onhandunits`) + SUM(`openpoqty`) THEN 1 ELSE 0 END

Does your card display properly when editing your drill path? Do you have any beast modes on your drill path card that would reference a column which no longer exists?

Hi @gabriellegeither It's a bit difficult to do this with a beast mode. I'd recommend utilizing an ETL and the Dynamic UnPivot tile to transpose your data. You can read on these here: https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot#4.

Hi @svetlana You can use a different dataset in your drill path card however if you wish to have the filter applied to the drill path card your filter field needs to be named the same within the two datasets.

Hi @HalD This appears to be a duplicate and I've posted an answer on your other question: https://dojo.domo.com/discussion/54952/can-anyone-help-me-understand-how-to-create-dynamic-text#latest

Hi @Saketh Have you looked into implementing a Fiscal Calendar from Domo? https://domohelp.domo.com/hc/en-us/articles/360042924254-Using-a-Fiscal-Calendar

@pratikrrana I'd recommend breaking your SQL down into chunks. Start by looking at what's being returned from your first query: SELECT GROUP_CONCAT(DISTINCT CONCAT( 'sum(case when x.question_text = ''', question_text, ''' then x.answer_text end) AS ', question_text, '`' ) ) from (SELECT DISTINCT…

You could utilize a Magic ETL to split out the lab classes and the lecture class, calculate the lecture class out from the lab class course code, join the two datasets together based on the lecture code and username then use a combine column tile to join your two columns together (alternatively you can use a formula tile…