GrantSmith Coach

Did you try and run the beast mode and it said it couldn’t find it or are you looking for it in the list?

@ankt84 Domo currently doesn't provide the actual owner of the beast mode in the governance datasets, only the card owner. I'd recommend putting this as an idea in the Idea Exchange.

Hi @Hedger You can use some case statements to convert your values to 1 or 0 and then add them together: CASE WHEN `Column A` = 'Yes' THEN 1 ELSE 0 END + CASE WHEN `Column B` = 'Yes' THEN 1 ELSE 0 END + CASE WHEN `Column C` >= 1 THEN 1 ELSE 0 END + CASE WHEN `Column D` >= 1 THEN 1 ELSE 0 END

@Chet Do you have multiple client IDs and secrets? Have you confirmed you're using the correct one (This has happened to me multiple times)? Are you able to make that API request using another tool like Postman to narrow down if it's something with how Domo is sending the request with the Domo action or if it's how Domo is…

Hi @Salmas In your example for Token ID 108 you have two records - Are you wanting to keep these records separate or should they be merged into a single row? Assuming they're separate rows you can use COALESCE and NULLIF: COALESCE(NULLIF(`A`, 0), NULLIF(`B`, 0), NULLIF(`C`, 0)) NULLIF returns null if the column given is 0…

If you reload the page does it still show it as having other objects being affected?

Single Value card with a beast mode will get you what you're looking for for the current date: DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL '1' MONTH), '%M %Y')

I've done write ups of this in the past about how to structure your data differently to get YoY periods like you're requesting. You can read up on it here: https://dojo.domo.com/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest

How is this dataset coming into your instance? Through a connector or through workbench?

You can utilize Domo Workbench or the database connectors to write queries against your instance and bring in that data as a dataset but there isn't an actual interface to explore your data by writing queries against it,.

@brave14 Try using a formula filter to convert your string you're using for comparison to a date: `TicketCreatedDate` >= DATE('2022-01-01') AND `TicketCreatedDate` <= DATE('2022-02-21')

DONE

I was getting the field formatting mixed with the summary number formatting. For whatever reason Domo doesn't have that option on the summary number formatting options. You'll need to have a separate beast mode for your summary number where you divide the final number by 100 and format it as a percentage.

Uncheck the box that says to multiply by 100 and that should resolve your issue

You won't be able to aggregate on an aggregate within a beast mode. You'd need to pre-aggregate your data to get the average signups and average targets. You can then use that aggregated data and apply the beast mode to count the number of records which meet that criteria.

Currently it won't send a buzz, likely because that'd be a lot of unnecessary buzz messages users would get. If you're looking to configure a notification when a measure changes have you thought about utilizing an alert to send out a notification to a group that way?

This isn't compatible with the group by options in the date range because we're defining how we want to do the grouping in the window function with the PARTITION BY section.

Hi @dylang91 How are your numbers weird? IFNULL returns the second parameter if the first one is NULL. This means you're subtracting NULL - CaseSubmissionDate which equates to null. NULL / Number is also NULL. What you'd likely want is something like this where you're calculating the value if it's not null:…

My guess here is that Facebook deprecated any API version prior to v12 recently and it cause an issue with the connector but was upgraded to a newer version so it’s working now. Complete guess though. I only know Facebook deprecated their APIs prior to v12 because it cause me some issues outside of Domo

@Abhijith wrap your entire case statement with the SUM instead of just the condition SUM( CASE WHEN `Approved` = 1 THEN `Total Charge` ELSE 0 END) SUM( CASE WHEN `Approved` = 0 THEN `Total Charge` ELSE 0 END)

This appears to be a display bug. I’d recommend reaching out to support and logging a case with them.

Currently no. You’d need a separate page.

It depends on how your company wants to define success but I'd recommend 'Invalid' and 'Success' SUM(CASE WHEN `Status` IN ('Error', 'Invalid') THEN 1 ELSE 0 END)

You can't use aggregates in the formula tile. It's processing data on a record by record basis. You'd need to break out your different component's you're aggregating into separate columns then feed that into a group by to do the aggregation (sum) and then do your final subtraction and divisions. Total `Amount` +…

Hi @Fadem What's your beast mode? Is it using the same column(s)? Are you getting any sort of error message?

-- This is a comment SUM(`Column`)

Use an ETL to group it based on the ID and the status and then count the IDs. This will break down your dataset based on the statuses and give you a count. You can filter out then for specific codes Alternatively if you're using a beast mode you could do a conditional sum: SUM(CASE WHEN `Status` = 'Failed' THEN 1 ELSE 0…

Hi @ankt84 You can find this information using the DomoStats connector and pulling the DataFlow History report. It'll list all the executions for all your data flows so it'll show if it failed and when it failed. https://domohelp.domo.com/hc/en-us/articles/360043433813-DomoStats-Connector#4.6. has more information on this…

As a note of clarity CONVERT_TZ will convert a time based on the current day's UTC offset and not when the date actually occurred. So if you have a date from 6 months ago affected by Daylight Savings Time (an extra hour off of UTC) and you try to convert it today it will be off by an hour from what's expected (It'll…

This seems to be a bug. I’d reach out to support to have them take a look.