ColemenWilson Coach

Are you using the response text to identify a specific responder? What if instead you had the responder or response ID as the filter so you wouldn't have that character limit issue?

Nice work @ArborRose !!!

There is not. The easiest way to do this would be to combine the data using Magic ETL or a Dataset view.

No, the closest thing to that would be to apply a filter to the scheduled report that makes the cards blank. You'd still see card titles though. You could also make a duplicate of the dashboard and remove those cards from it.

You could just create a beastmode that is `your value` * 1000000000. Then in the chart properties, select General > Divide Values by > Billions. End result (this original number in my data is 95.72, once I take the steps above I get the below):

Can't wait to hit the slopes with ya'll!! 🏂️

Yeah! The best thing to do is split the email out so you only have characters left of the @ sign. Then remove all text and only keep numbers. Then count the characters left. Use the following: CHAR_LENGTH(REGEXP_REPLACE(SUBSTRING_INDEX(Email, '@', 1),'[^0-9]+','')) Then use a case statement to filter out anything you don't…

Have you looked at using TIMEDIFF()? https://www.w3schools.com/sql/func_mysql_timediff.asp Here is what I use to calculate duration between two datetime: CASE WHEN ((UNIX_TIMESTAMP(`datetime`) - UNIX_TIMESTAMP((`datetime2`)))/3600) < 24 THEN TIMEDIFF(`datetime`,`datetime2`) ELSE (UNIX_TIMESTAMP(`datetime` -…

Users can set their own language that can differ from the company language settings:https://domo-support.domo.com/minasan/s/article/360043439133?language=en_US

You don't have to do the recording, just the screenshots. Cheers!

The only way currently to get that custom formatting is in a separate card that you could place next to the card on the dashboard. I would recommend adding an idea to the ideas exchange for a dataset last updated date display smart text. https://community-forums.domo.com/main/categories/ideas

A workaround (if you have workflows) would be to create a workflow that updates the data every 15 minutes or hour. A word of caution, if you are on consumption model of Domo this would incur high usage costs.

@Joe_M if you're interested in doing this, then you may enjoy my Demo Slam presentation today: https://community-forums.domo.com/main/events/117-2024-domo-demo-slam

If you are using default roles, the user would need Admin to be able to revert changes. If you are using custom roles, the grant "Manage DataSet" will allow the user to revert changes. These are high security grants/roles and caution should be exercised when granting them.

You can just apply filters to the card, you don't need to include the logic in the beastmode. All you need is a table card filtered to the current year and filtered with COUNT(individual_id) > 2. Then in your table card add Request Date, Individual ID and Top Requester. Then aggregate the Top Requester field with a count.

Can you share a data sample and your utilization beastmode?

You'll need to use a calendar dataset. There is one in the Domo Dimensions connector. The calendar dataset will have every date for your card. You then need to join your data with the calendar dataset so there is data for every month you are displaying. Domo only plots what is in the data, so if 0's don't show in your data…

What does the data for `Students` look like? Is it a student id? Or is it a number that represents the number of students? Also I noticed missing (or extra) parentheses in your beastmode in your most recent comment - so double check that.

It appears to be permanent. I would recommend emailing betafeedback@domo.com to let them know about this issue. I'll do the same!

Try this: COUNT(CASE WHEN `acceptance_flag` = 1 THEN `students` END) / COUNT(`students`) * 100

Because you still have Amount in your sorting. You need to remove it from your sorting.

Try removing the SUM of Amount from your sort.

Because they have now been aggregated and Domo doesn't know how to aggregate the remaining columns. So if you include them in the group by then they aggregate as much as they can with those fields, example: - You have dates and a category included in the group by and individual transactions summed. Domo will aggregate…

Could you normalize them against a benchmark? So you are visualizing +/- against that benchmark? Example: Total sales benchmark is $1,000,000 and the current month value is $1,200,000 Total sales benchmark is $1,000,000 and the current month value is $1,200,000 Graph would show 20% increase over benchmark of 0 (with…

In MagicETL use the formula tile and create the following formula: DATE(CONCAT( -- Year REGEXP_REPLACE(SummaryDate1, '[^0-9]+',''),'-',-- Month CASE WHEN REGEXP_REPLACE(SummaryDate1, '[0-9]','') LIKE 'Jan%' THEN '01' WHEN REGEXP_REPLACE(SummaryDate1, '[0-9]','') LIKE 'Feb%' THEN '02' WHEN REGEXP_REPLACE(SummaryDate1,…

I don't. That may be a question for the Google community forums 😄

This actually does exist. It is a Domo Governance dataset called "Card Fields and Beastmodes". It returns the fields used on cards, ONLY if they are used in the card - which sounds like exactly what you are looking for.

Ah good ol' empty strings!

Create the following beastmode: CASE WHEN `UN Number` IS NOT NULL THEN 'Include' ELSE 'Exclude' END Then drag the newly created beastmode into the filter section in analyzer and filter to include "include"

You could use Google MyMaps and create a map, then embed it using the HTML Easy DDX brick. Search in the Appstore for HTML Easy: Just copy the embed code from Google MyMaps and then paste it in the HTML section in the DDX brick. I spent alot of time working on dynamic sizing, here is the code to save you time: <!DOCTYPE…