MarkSnodgrass Coach

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: https://docs.mapbox.com/mapbox-gl-js/example/cluster-html/ @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. https://domo-support.domo.com/s/article/360044951294?language=en_US

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. https://community-forums.domo.com/main/discussion/42497/summary-number-conditional-format-colors-with-directional-arrow I have gone away from this method and stacked a…

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. https://community-forums.domo.com/main/discussion/42497/summary-number-conditional-format-colors-with-directional-arrow

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.

If you select unbounded for preceding and enter 0 for following, that will give you a running total by partition. Is that what you are wanting?

Commenting on this for people who were interested in voting this up.

@ColemenWilson I wonder if you could use the Java CLI tool to change the schedule manual. That might be your closet way to do something in bulk.

It was great to help so many people last month! Now, I will go back to "sleep" and let some others get the top spot for the month… as long as they aren't named @GrantSmith 😀

@elvira_bannon slight correction to my initial beast mode. The first line needs to change so that we are just looking to see if the current date is the first day of the month. CASE when DAY(CURRENT_DATE()) = 1 THEN CASE when MONTH(startdate) = MONTH(CURRENT_DATE()) then 'Exclude' ELSE 'Include' END when MONTH(startdate) =…

Here is what I suggest you do. Change your date range from Month to Date to Last 2 Months. This will bring in the current month and the previous month data. Next, create a beast mode that looks like this: CASE when DAY(gldate) = DAY(CURRENT_DATE()) and MONTH(gldate) = MONTH(CURRENT_DATE()) THEN CASE when MONTH(gldate) =…

On your initial dataset, you can it to append instead of replace, which will allow you to build a historical trend.

Are you saying that your report viewers want to be able to select a date and view the data as of that date, but your data is set to replace so there is no historical data?

You could look into using data from the DomoStats/Domo Governance datasets to get the batch date and then join it to your main dataset so it would be available as a column on your card. Look at the Datasets or Dataset History reports from the DomoStats connectors.