MarkSnodgrass Coach

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.

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. You would likely need to restructure your data if your line was a value that is not part of the series.

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`,'@')))),'>','')

I don't have an ftp job in Workbench to compare, but when looking at a job that pulls in a local Excel file, the Calculated Field Transform does not give me an option to extract data from the filename. I can only look at the columns. If you have different options, post a screenshot and that might help. If it is available,…

Another option is to use the Group By tile and choose Max for the aggregation type on the date field.

Color rules are limited to comparing against specific values and can't compare against other fields unfortunately. You can get around this by creating a beast mode that does the comparison and then build a concat statement that will color the text green or red using html div tags. The downside is that this value becomes a…

This how you would construct it to make the URL dynamic by Opportunity ID CONCAT('<div><a href="https://xyz.lightning.force.com/lightning/r/Opportunity/','`Opportunity ID`','/view', '" "target="_blank">',`Opportunity ID`, '</a></div>')

Since your estimated value is in a different row than your actual value, this isn't as easily done. You would need to be able to have your estimated and actual values in the same row and then create a beast mode to compare the two and then develop the color rule based on that.

You would want to remove CURDATE() from your formula and base it off of your orderstartdate. Something like this: (CASE WHEN WEEK(DATE_SUB(ORDERSTARTDATE_DATE, INTERVAL (DAYOFMONTH(ORDERSTARTDATE_DATE) - 1) DAY)) = WEEK(ORDERSTARTDATE_DATE) THEN (carrier pay)END) / (CASE WHEN WEEK(DATE_SUB(ORDERSTARTDATE_DATE, INTERVAL…

I would dynamically determine the first day of the month by doing this: DATE_SUB(`dt`, INTERVAL (DAYOFMONTH(`dt`) - 1) DAY) and then wrap the week function around this to figure out the week number. This would give you the first week of the month.

When you see the message "live updates are not available" that indicates that the workbench application is open by multiple users in separate logins. The first thing to try is to have each user log into that Windows machine and close the workbench application, then have one person go and try and authorize (make sure to…

Unfortunately, what you want to do is not currently possible in the pivot table. I would suggest adding it to the ideas exchange. You could think about using drill paths to accomplish what you want. Your top level card might have the % change and then you can click into that to see the details.

You should consider using the flex table chart type to produce the change and % change information. Here's the KB article on it. While the default setup of the flex table is to show a graph with % change, you can have it show values, so that it looks more like a table.

I would watch this video where Dan Hendriksen walks through some sample workflows.

The window function itself SUM(SUM(`qtyOrdered`)) OVER (PARTITION BY `OrderNumber` ORDER BY `CustomerName`) should be producing a running total of the qty ordered. To troubleshoot, try just having this as a beast mode and put it in your table. If it is working correctly, according to most recent result, your first row…

You are going to need to use a window function in beast mode to do this. This feature isn't on by default, so ask your CSM to turn it on if it isn't on already. Once it is on, you would need to do something like this for your calculation for Net On Hand TotalOnHand + QtyShipped - SUM(SUM(`qtyOrdered`)) OVER (PARTITION BY…

Can you provide some sample data or screenshot of how you want it to look? It's difficult to propose a solution without some additional information.

Domo can count them for your in Magic ETL by using the Group by tile. You can use the group by tile to generate the count and then join it back to your main dataset so that the count is repeated next to your user counts. You may need to share more about the columns in your dataset to be able to give you a more specific…