GrantSmith Coach

Currently no, there isn't a way to define spacing between the bars in a grouped bar chart.

This is an issue on Domo's backend. You'd need to reach out to Domo Support and log a ticket with them to have them look into the issue.

I'd recommend logging a ticket with Domo support as it sounds like a bug in the system.

Are these users within Domo already that you'd be able to use their profile pictures?

You can also try and right click on the application and select open to possibly bypass the message or opt down option and double click it to allow for you to open it

Start with you CSM to see if they can assist in getting the latest version.

Have you looked at the "DDX SQL Input Bar Chart Output" DDX brick in the app store? You'd need to specify the different datasets in your DDX brick but you should then be able to utilize your join.

Typically I'll add a text card atop the page and have it simply return an error message saying to select a single date if more than one is selected (I'll also make it red text to clearly notify an error to the user). Currently we can't limit the date selector to a single date. CASE WHEN COUNT(DISTINCT `date`) <> 1 THEN…

How is your data formatted? Is it summarized on the reporting date or are each date a snapshot of the values? I'd recommend using a MagicETL dataflow to calculate the maximum data for each year (calculate the year with a formula tile YEAR(`date`) then pass it into a group by grouping on the year and select the max date…

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…