GrantSmith Coach

Currently the table is the only one that will work. If you want you can get more control of the visualiation utilizing a Domo Brick which would support circular images.

I think you may be missing a double quote after src=

CASE WHEN `Actual 1` IS NULL THEN —- If Initial is blank = On-Time CASE WHEN `Initial 1` IS NULL THEN 'On-Time' —- If Adjusted <= 25 days after Initial (or earlier than Initial) = On-Time. WHEN `Adjusted 1` <= DATE_ADD(`Initial 1`, interval 25 day) then 'On-Time' —- > 25 days = Overdue WHEN `Adjusted 1` > DATE_SUB(`Initial…

I'd recommend looking into TIME_TO_SEC function to convert your string into total seconds then you can divide that number by 3600 to convert to it to hours and then SUM it. TIME_TO_SEC Returns an elapsed number of seconds for all values in a date/time column. TIME_TO_SEC('DateCol')

Should be something like below: CASE WHEN `field` = 'Bucket 1 Value' THEN `value` END You can then use the aggregation options if you want to do a sum / min / max / avg. Just make sure you change the logic for your two different buckets

You can set your y-axis to be your total number / metric and then use two beast modes to calculate each of your two buckets for your bar, dragging each beast mode into your series section of your chart.

If you do a DOMO.log in the connector IDE code, is it returning the same JSON you're seeing with Postman?

Thanks for posting your solution @SeanPT ! Glad you got it figured out.

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:

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.