ColemenWilson Coach

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…

You can use the REGEX_REPLACE() function. REGEXP_REPLACE(yourField, '[^0-9]+','')

@gagliardi we created a service account to solve this very issue. Highly recommend!

You can use a rank & window tile in your ETL to create a rank or create a rank with the following beastmode: RANK(Metric) OVER (order by Metric DESC) This will create a dynamic rank value that you can use to assign your color rule.

Here is an example of how I brought a specific cell into Domo: Here is what my google sheet looks like and I want the green highlighted value in cell E2 This is how I would setup my connection to the google sheet in Domo: Output: Alternatively, if you are bringing in the entire sheet, you need some way to point to that…

You could set the color rule based on rank. So when Rank <= 2 then color

Yes. You can use the Google Sheets connector to connect to the sheet. You could bring in all the data for that sheet and in an ETL pull the specific cell you are looking for, or choose a specific range (in this case just the cell and a cell to the left or above it as the header) to pull in.

100% agree. We would love to do all dashboard development in app studio, but exporting and scheduled reports are not possible which is a hard stop for us. Navigation is not great with apps. We can't set an app as a default landing page for a user. Domostats need to be improved. I get that it is in beta, hope this beta…

Do you have a timestamp or just a date?

Awesome. Let me know if you find that anything is not working.

The way I've done this is utilizing the rank and window tile to rank in descending order grouped by the unique field, in your case it looks like you'd group by `patient`. Then add a filter tile to only keep the records with a rank of 1. This will keep only the most recent date, and corresponding row, for each patient.

It looks like there is a 3rd party app in the Monday.com marketplace that will allow you to embed iframes:

It's not possible to use only the data table in a card, however you can do quite a lot with table cards in terms of layout and formatting. Could you share what your data table on your line bar chart looks like and I can help suggest formatting to recreate the same look in a table card?

Hmm no error here. I'd suggested submitting a Domo Support ticket.

I'm not 100% sure what you're trying to do here. Could you share a bit more and perhaps provide some examples of what a sample data table would look like before and after your ETL?

Are you getting an error? I just tested with over 100 columns and it ran fine:

Easiest thing to do would be to create a table card and have 2 columns on it: 1. New Product ordered/ bool 2. A count of New Product ordered/ bool that is a new field that handles nulls. It will look like this: IFNULL(New Product ordered/ bool,'null') You'll need to create a new field that handles nulls. It will look like…

Yes. In the Domostats and Domo Governance connectors there are reports related to dashboards and cards on dashboards. You can join these with the activity log.

It isn't just duplicate beast mode names. If a non-beastmode field exists in the data with the same name you will get the error as well.

I used: CASE WHEN stepAnswerUploadType = 'IMAGE' THEN CONCAT('<a href="',`stepAnswerUploadUrl`,'" target="_blank">', '<img src="',`stepAnswerUploadUrl`,'" height="20px" alt="Click for image"/>', '</a>') WHEN stepAnswerUploadType = 'PDF' THEN CONCAT('<a href="',`stepAnswerUploadUrl`,'" target="_blank">', '<img…

You'll get the format you want with a pivot card if you set it up as shown below: Would these results work for you? If not you can use the table card and click "transpose" in General Chart Properties but I don't think that gets you the format you are looking for: But if so you can use the table card and click "transpose"…

Well, if it is an aggregate function - COUNT or MAX then yes you would see different values then if you just drill into the final data view because the final data view is an unaggregated view of the underlying data.

MEDIAN() It doesn't show up in the function list in beastmode editor but you can use it and it works.