MarkSnodgrass Coach

You can actually use color rules to do this and not lose the formatting you are applying to the cell. Create a color rule, select a color and set the opacity to zero, then select the table text to be the text choice in the middle and unselect the apply format to table row.

It doesn't appear that you have a lot of consistency to go off of since some of your first words have spaces and sometimes your first word is also the second word. Are the words at the end consistently the same? If so, you could look at the end of the string using the RIGHT() function and if it equals Referral or Internet,…

@jaeW_at_Onyx has several YouTube videos around Domo and Jupyter. He might be able to weigh in and answer this

Which report are you choosing with the HubSpot Connector as there are over 20 to choose from? It may be that you need to pull two different reports and then use Magic ETL to join them together so that you get the friendly names you are expecting and not just the internal IDs. One way that can make this easier for you is to…

You should be able to do this utilizing the partition support in Workbench. Here is the KB article on it. https://domo-support.domo.com/s/article/360062446514?language=en_US

I would double check the settings tab of the DomoStats Activity Log dataset to make sure that it is running daily and then check the history tab to see that it has run successful up to the most current date. You can also check the data tab and look at the Event Time column to make sure it is current. If those all check…

that's interesting the page filters are interacting with them if your javascript code in the brick is only referring to dataset1. There is not a way to add/remove datasets, which is an unfortunate limitation of bricks. The easiest fix I would suggest for you is to make a domo webform or an excel file that has 3 columns and…

I have been experiencing the same issue. I use Chrome on a Windows PC. I haven't tried Edge to see if I experience the same thing to truly determine if it is a browser issue or not.

You can do with the deep link filtering (or pfilters). Here is a video of how to do it: It's also covered in this KB article:

You can keep them from showing by doing the following: On the dashboard, click on the wrench and choose Filter Options Then toggle off the Show Filter and PDP icons

I would look through the mapbox documentation here: @ellibot may have some insight. I believe he has used this before.

Most people will flatten with a view or a query that joins tables together to cut down on the number of jobs that are running. It will also reduce the number of dataset and dataflow executions, if you need to worry about that from a cost consumption perspective.

You should be able to do this by grouping your data by caller and date, then joining to the Domo Dimensions Calendar dataset and then using the rank and window to create a 3 day, 4 day, etc. total. It would look something like this: You would replace my covid sample dataset with your caller dataset. In the group by tile,…

Yes, create a mega table that has your distinct values. In form builder, choose Add Lookup and select the mega table that you built as its source.

I would set two constants Segment and Site. Then use the Pivot tile to pivot the segment and sites. I would suggest reviewing the Pivot tile KB article if you are unfamiliar with it.

I would suggest considering Andrew's suggestion. It may be possible with the CLI tool, but will be very tedious and a lot of potential for errors if instance names are in the various JSON strings.

Is 2022 a column? Or is it a string value? You have the ` around both sides of it which is used for columns names. If 2022 is not a column, it will throw an error. If you are wanting to look for the string value 2022 then you should have single quotes around it.

I use the Microsoft SharePoint Online Rest Connector to connect several Excel files to our Domo instance. You can use the scheduling section of the connector to have it pull data in from the spreadsheet as often as you would like. You will want to read through the KB article for this connector as it requires some initial…

Nov XXXX isn't a date format, unfortunately. When I want to quickly group dates into a month/year, I use the LAST_DAY() function. You can then use the custom date format in the Card Analyzer to have it display as Nov XXXX or whatever format you like.

You could definitely do with the blank brick and build a html table with the borders and shading that you want and the values in the places that you want. You just need some basic html, css and javascript to do it. Otherwise, you can stack several multi-value gauges around each other to achieve a similar look. You just…

I mocked up an example in the Domo Community instance using the Domo Dimension calendar dataset and the DomoStats People dataset as my "employee" table. The ETL looks like this. The formula for the filter to actives tile is this: dt >= DateHired AND dt <= IFNULL(DateTerminated,CURRENT_DATE())

This is best done by adding a third date column by using the Domo Dimensions calendar dataset. You can filter it to pick one day out of each month and then create an IsActive column to by comparing the calendar date with the hire and termination dates. You could also do it for every day if you wanted daily granularity. You…

@ellibot has some experience with Python. He may be able to help you.

If you don't want ID='Liability' in your card, the easiest way is to drag ID into the filters section and choose Not In and select Liability. If you need those values for other parts of your card, but don't want it for this specific value, you could try this beast mode as another option. SUM(CASE WHEN Id<> 'Liability' THEN…

Try this: SUM(values) - SUM(CASE WHEN Id= 'Liability' THEN values ELSE 0 END)

Try this: SUM(values) - SUM(CASE WHEN Id= 'Liability' THEN values ELSE 0 END)

Yes, you can. It requires adding HTML and also formatting your value because it becomes a string in the process. This post outlines how to do it. I have gone away from this method and stacked a multi-value gauge on top of my other chart as @PaulJames suggests as it requires a lot less effort.

Yes, you can. It requires adding HTML and also formatting your value because it becomes a string in the process. This post outlines how to do it.

When adding a page filter, if the field name is in multiple datasets that are used on the page, you should see an arrow to the right of the name. Click on the arrow and then click on Select All. This will allow to affect all cards that are powered by those datasets on the page. KB Article Link:…

You can accomplish by using the group by tile to count the number items in each domain and then join it back to your original dataset and join on domain. The ETL would look something like this.