MarkSnodgrass Coach

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.

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) )