GrantSmith Coach

What format is your data in? Are you attempting to store all of the values within a single column or are each response a separate record in your dataset? How are you seeing the 1.5 value and the 3k value?

You can utilize your variable and select the different fields depending on the value of your variable: CASE WHEN `variable` = 'Date Value' THEN `date field` ELSE `category field` END Toss that beast mode into your sort and select sort descending.

Your AE would be the person to help you get an answer to this. I'd recommend reaching out to them.

Not exactly pull out a match but you can use REGEXP_REPLACE to fin the string and remove everything else from it. REGEXP_REPLACE(`value`, '^.*(MATCHCODE).*$', '$1')

Are there any other sort of identifiers on how to extract the code? Is it always [space]AAA[space] for the format? Would that ever appear multiple times in the string?

Are the pfilters getting set correctly and have you validated the format of passing in the pfilters? Have they been url encoded?

Currently this isn't an opiton. What you could do is utilize a beast mode to check to see if they have Prelim selected and then return a string to use on a text box card to display a warning above your variable control letting the user know 3rd party isn't available.

They would need to add the data in another dataset. You could utilize a Web Form for the user to edit within Domo (or alternatively a Google Sheet / Excel Document) and then join that data to your dataset to include the annotation.

Currently this isn't an option but I'd recommend adding this to the Idea Exchange as a product enhancement

There isn't a supported version to automated this process however you could utilize the internal APIs to do this.

Currently no, this doesn't appear to be an option to remove it. If you can, perhaps filter out the negative values from your dataset.

Agree with @RobSomers . Fixed functions are great for this use case. You can find more information on them here with several examples.

You'll need to prep your data via an ETL to do this. You can pull in the calendar dimension dataset from the Domo Dimensions connector. In the etl filter your calendar dataset to be after your first date in your dataset and exclude any dates in the future with a filter tile formula `dt` >= DATE('2020-01-01') AND `dt` <…

What method are you using to automate the loading of your data? How quickly do you need your data updated?

What sort of error message are you getting?

Not exactly however you could include an additional column with the notes and use that field as a tooltip and include that in the hover text but that would be a on a row basis and not on a cell basis.

Median isn't able to be calulcated in a beast mode but you can do it within a Magic ETL using a group by tile.

You won't be able to visualize MoM and YoY on the same graph with the PoP charts Domo provides. When I'm trying to visualize both in the same graph I will utilize a custom date dimension table and utilize a line + bar graph to show both values and the PoP % change. I've done a write up on how to configure a custom date…

An alternative would be to have the SA360 data ingested into BigQuery and utilize the BigQuery connector to pull the data.

There is an option with the premium Brand Kit which allows you to white-label your outgoing emails with some features still in Beta. I'd recommend reaching out to your AE to discuss it with them.

Yes, you'll schedule jobs to query your database and then send the data up to Domo to ingest. You can read mode about it here: https://domo-support.domo.com/s/topic/0TO5w000000ZapUGAS/workbench-51?language=en_US

If the user hasn't logged in yet you can go into buzz for the user who sent the invitation under conversations > Buzz and you can click the remind button to send them another email. Alternatively if they need to log in and forgot their password you can have them click the Forgot password? link on the login screen.

Currently it's an all or nothing in terms of the interactions however, have you looked into utilizing a FIXED function beast mode with some FILTER DENY to prevent the calculation from being affected by certain columns?

You can utilize a beast mode as part of your card (just make sure to save it to the dataset so you can filter on it on your page) to define the categories.

Not with a connector. You could utilize workbench and have that server connect via VPN before connecting your your database

You can then set your chart to be the last 13 months and create a beast mode to return either yes or no if they're less than the current month. CASE WHEN LAST_DAY(`Date`) < LAST_DAY(CURDATE()) THEN ‘KEEP’ ELSE ‘EXCLUDE’ END Then just filter on that beast mode for the KEEP values. LAST_DAY is a hack I use to get the last…

Correct

You could have 2 separate slicers, 1 for the high level category that would filter the other slicer having your lower level slicer to show only those values in your high level category. Alternatively you could likely utilize a Domo/DDX brick to get more control over the filtering / UI interactions to combine them in to a…

Are you simply looking to just remove the open and close brackets and the double quotes?

Alternatively you can use a group by tile and select the minimum value for your pass fail column and join it back to your original dataset that way if any are marked as fail all would become fail.