GrantSmith Coach

Does everyone have access to every report or are they restricted on what they can view? Can you utilize PDP to allow certain users access to the different reports? This would filter the data before it's sent to the visualization.

@ozarkram Is your date always in the format of MM/DD/YY? The following regular expression will handle MM/DD/YY and MM/DD/YYYY formats. I'd recommend doing this in a Magic ETL as it'll reduce the processing needed when displaying your data and not have to calculate it every time you load your cards. You can use a formula…

Why do you want to create 1000 versions of the same page? Are you wanting to limit access to the different pages depending on specific criteria? If that's the case I'd recommend a single card but utilize PDP to limit the rows the user has access too instead of creating a bunch of pages and cards that you'd need to maintain.

Hi @lawiti I'll typically add in a timestamp on the queries that I'm writing or add the current timestamp in the ETL I use to process the data and then use that field to display when the data was last updated. A newer option that was just release in the latest version is Smart Text to display the last updated timestamp…

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.