ColemenWilson Coach

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: https://monday.com/marketplace/10000027

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.

Thanks @shreeyab. Some things to check/consider: 1. You can prevent drilling down to the final dataset view by selecting "Prevent drilling to final data grid view" 2. When editing the drill path, you will be in analyzer view with all data being displayed - this means that as you are creating the drill path, the data will…

There is a Domo Governance dataset called "Card Fields and Beast Modes" that shows all of the fields used in the cards in your instance. https://domo-support.domo.com/s/article/360056318074?language=en_US

Hi @shreeyab could you provide a bit more information?

I’m not at my computer to verify so someone please correct me if I am wrong, but the only way to do it would be in a beastmode and share the beastmode to the dataset or in the ETL. for beastmode it would be: DATE(yourDateField) in ETL it would be using the date tile or a formula tile with the above beastmode.

Welcome to Domo! Here are the steps to accomplish what you are hoping to do: 1. Click the + icon in the top right of Domo and select "Dashboard" 2. Over on the right side of the screen you'll see icons representing the various objects you can add to a dashboard, select the one that says "card" and click and drag into the…

The drill path will lead to a view with a filter applied for what has been selected. So if the bars are months and you click January, for example, then the drill path card will only show data for January. If your bars are days, when you click a day, January 3rd for example, then the drill path card will only show data for…

Remove the "AS trx_yr_week" from your beastmode Other date formatting: yyyy-mm-dd DATE_FORMAT(trx_date, '%Y-%m-%d') yyyy-mm DATE_FORMAT(trx_date, '%Y-%m') yyyy-ww (Where Monday is the first day of the week) DATE_FORMAT(trx_date, '%Y-%u') Other date formats: https://www.w3schools.com/sql/func_mysql_date_format.asp

I agree with @MichelleH , you would then use the new field as a filter on the card and select IN complete.