MarkSnodgrass Coach

You can make stars by doing a beast mode like this: (CASE WHEN AVG(Object_Health_Score) >= '.8' THEN ' ★★★★★' WHEN AVG(Object_Health_Score) >='.6' THEN ' ★★★★☆' WHEN AVG(Object_Health_Score) >= '.4' THEN ' ★★★☆☆' WHEN AVG(Object_Health_Score) >= '.2' THEN ' ★★☆☆☆' WHEN AVG(Object_Health_Score) < '.2' THEN ' ★☆☆☆☆' END)…

Depending on what you are actually displaying, you could simply drag your expense category into the filters and filter to that specific category. If you need to still show the other categories, you can create a beast mode that only sums that category like this: SUM(CASE WHEN category = 'mycategory' THEN valuefield END)

For #1, you need to change the interaction filters for the card in your dashboard settings. For #2, the chart uses the series for the filter for drilling. You would need to have your city in your series for it to filter like you want.

If your dataset in Domo contains the fields Sales and Cost, you would create a beast mode in Analyzer that is simply Sales - Cost and label it Profit. You would then drag that into your pivot table rows or values section

The maps don't natively allow you to click on a symbol and go to a website. You would need to add a drill path and have a table card as your drill path card. In the table card, you can build the html href link with a beast mode. It would look something like this: CONCAT('<a href=',`Linkfieldname`,'…

The pivot table is more limited in the html that it accepts. I would suggest adding it to the idea exchange to see if it could be added in the future.

If you don't want the dataset to go into this state, I would create a card based off of it and add it to your Overview page. You might also build a scheduled report off that card to ensure it is being accessed.

I agree with Colemen. I lean toward the approach of stacking smaller gauges on top of a card to give an additional indicator about the visualization. Such as this where I have two smaller cards on top of a main card in a dashboard.

Based on the error message, it looks as though one of your rows contains a value of LAST_RUN and not any form of a date. You can try and handle this two different ways. In your formula tile, you can try wrapping a TRY_CAST function around your STR_TO_DATE function like this: TRY_CAST(STR_TO_DATE(Date, '%Y-%m-%d') as DATE)…

Based on the error message, it looks as though one of your rows contains a value of LAST_RUN and not any form of a date. You can try and handle this two different ways. In your formula tile, you can try wrapping a TRY_CAST function around your STR_TO_DATE function like this: TRY_CAST(STR_TO_DATE(Date, '%Y-%m-%d') as DATE)…

It is likely throwing any error because of how you are trying to use the count function. Are those individual fields within your dataset? The count function just takes one field: COUNT(plant) . If you are looking for any data in any of those fields, I would use the COALESECE function inside the COUNT function and list all…

If your dataset already has the booking date, shipment date, shipping dollars and order number, you shouldn't need any additional fields. Have you tried using any of the above suggestions in Analyzer? Start with a table card and see if it returns the results you expect.

If you only want to show the orders that meet your criteria, you can create this beast mode and then drag into your filters and filter to include. CASE WHEN QUARTER(booking_date) = QUARTER(shipment_date) AND YEAR(booking_date) = YEAR(shipment_date) THEN 'Include' ELSE 'Exclude' END

I would use the QUARTER() function and the YEAR() function to ensure that you get the expected result. It would look something like this: CASE WHEN QUARTER(dt) = QUARTER(CURRENT_DATE()) AND YEAR(dt) = YEAR(CURRENT_DATE()) THEN 'Same' ELSE 'Different' END

There is not a horizontal alignment option, but if this card is part of a dashboard you can sort of get around by trying a couple different things. You can put an empty content about the above multi-value card to move it down into position. In the dashboard layout, you can tell it to show the card description, and if your…

Have you looked into the JSON Webook connector? That would be an easier solution than creating a custom connector. https://domo-support.domo.com/s/article/360042931494?language=en_US

You should be able to do this all in the same chart. You would create a beast mode that looks at the variable and then will do whatever you want based on the variable value. You would then put this beast mode in your sorting properties so that it sorts the way you want as the different variable is selected.

You will want to create a 2nd beast mode that you would use just for sorting purposes. Just make sure it results in the same granularity as the field you have in the x-axis. You might be able to just create a beast mode that is just WEEK(dt) and put that in the sorting.

I believe you can do this by clicking on the metric dropdown when setting up the alert and scroll way down to Charted Values and select Late. Then choose greater than. I'm not totally sure if the greater than is looking at percentage because it is a percentage based chart or if it is looking at a value. Might need to play…

You would click on Calculated Field Write your beast mode and name it Drag that field into the x-axis Hope that helps.

You can construct your own week text with a beast mode and put that field in your x-axis. Something like this: CONCAT('Week of ', DATE_SUB(dt, INTERVAL (DAYOFWEEK(dt) - 1) DAY) )

I agree with @ColemenWilson that I think this could be possible, but you need to supply more information as to how you go about determining the "X" row of the table. Your drill path card will automatically be filtered by what you clicked on in your main bar chart, you can have additional filters already applied in your…

If you are running Windows Server 20212, you need to install a patch to make it work again. This thread outlines it. https://community-forums.domo.com/main/discussion/62150/i-lost-connction-to-domo-get-could-not-authenticate-user

That's a good question and worth submitting an enhancement in the ideas exchange to allow subscribers to build ETLs off of the federated dataset. Published datasets are federated because of how Domo is pushing the data around behind the scenes (from what I know.) Your CSM could likely put you in contact with someone from…

Since you already have the rank and priority in each, your ETL will be a little simpler. Here is how I would lay it out. The filter tile filters to departments that have a vacancy as I noticed you had one that had no vacancies so they shouldn't get any student.s The Rank & Window tile creates a running total using the sum…

You can also use TRY_CAST(myfield as date) this will null the value if it can't convert it to a date, otherwise it will make it a date formatted value.

Have you tried swapping the values that are in the gauge value and comparison value? I think the default chart properties might actually work for you if you switch which values you have in the gauge and comparison values.

The Line bar chart is set to take the first item in your series and make that a line and everything else becomes part of the stacked bar. You can read more how it works in this KB article. https://domo-support.domo.com/s/article/360043428053?language=en_US You would likely need to restructure your data if your line was a…

This is an interesting one. First, your student version will be the same as the full version, from what I understand. I would start by creating a running total of the organization "vacancies" by the highest priority. You would use the rank & window tile for this. This would allow you to create a start and ending amount.…

@MichelleH has what I would have suggested, but she mistyped the character you are looking for. :) Should be: REPLACE(RIGHT(`Sent Email`,((LENGTH(`Sent Email`))-(INSTR(`Sent Email`,'@')))),'>','')