MarkSnodgrass Coach

Instead of this: Case when discarded_at is NULL and archived_at is NULL then count(invoice_id) else NULL end try this instead: SUM(Case when discarded_at is NULL and archived_at is NULL then 1 else 0 end) Using 1's and 0's with SUM is another way to count items instead of using the COUNT function.

Domo, Please combine these upvotes with the upvotes from an earlier Idea Exchange with the same request.

Domo released a new Office add-in at DP23. I would try using it instead.

You might try seeing if any of the Domo Bricks can be extended to do what you want to do. There are several map brick apps in the app store.

Create a beast mode like this might work for you to exclude the prior year entries are excluded if they are from the 2 days that aren't yet in the current year data. CASE WHEN DAYOFYEAR(yourdatefield) > DAYOFYEAR(DATE_SUB(CURRENT_DATE(), INTERVAL 2 day)) THEN 'Exclude' ELSE 'Include' END You would drag this beast mode into…

It might actually be that your IN does not have a space before it so it is reading accountIN as one thing, when it isn't.

@GrantSmith is the Regex guru. He will be able to put something together for you.

Sent you direct message with a link. I am free for a few minutes.

There are not color ranges in this card, but you can assign positive and negative colors. For the formatting, try setting the format on the gauge value and the target value to number. There are also individual formatting options within the chart properties, which can be confusing. I feel your pain there.

It is the multi-value gauge. Here's the KB article for the complete documentation. https://domo-support.domo.com/s/article/360042924774?language=en_US

Yes, you can do this. I would put the field (can be a beast mode) that has the value for your records with a certain value in the Gauge Value and then the field that that has the total number of records in the Target Value. You will also need to put something in the Group By that will aggregate the data appropriately. In…

Your CSM/AE should be able to lay out how credits are consumed, but as I understand it, creating beast modes has no impact on credit consumption. Credits are used when dataflows are executed.

In Analyzer, for each of the amount fields, did you select an aggregation type? If not, then choose Sum and it will sum it by team and month, which looks like what you are trying to do.

@karlysindelar_2023 glad you are getting in and using Domo. Happy to help. I am assuming that in your nested bar chart you have a field in the series which contains the values of (Invoices keyed, Rail, Port, SSL, Other, Inland). If you drag that field over into the Filters Properties, you are then given the option to…

I would do the following in Magic ETL with the formula tile and create them in this order: Client ID - RIGHT(clientfield,5) Client Name - TRIM(REPLACE(clientfield,Client ID,'') If you extract the client ID first, which you know is always the last 5 characters of the string, you can then use the replace function to replace…

If Invoices Keyed is actually your overall total, you could filter out that type by adding that field to your filter properties and choose Not In and then selected Invoices Keyed.

Would it work to add a single row to your report that you can then filter out in your first magic ETL dataflow? That might be the easiest solution.

@FXM32 Not sure if you are still needing help on this, but I put together this in Magic ETL that may help you. Here is what is happening in these tiles: Use the Select columns to select just the start and end time columns and then use the Remove Duplicates to get a distinct list of all start and end times. Add a Constants…

This feature is coming soon. I believe i was mentioned briefly during Domopalooza 2023, but I'm not sure if a date was revealed as to when this functionality will exist.

One way I have been able to accomplish something like this is if my "brand partners" are in my series, I hide the legend and adjust the hover text properties to not show the names. I also disable drilling so they can't get to the raw data, and since you are embedding, they wouldn't have access to the dataset in the data…

Unfortunately, it looks like INSTR and LOCATE have their arguments reversed. For INSTR() it needs to be INSTR(trailid,'G2'), for example.

I use the INSTR() function for this type of work. INSTR(STR,SUBSTR)Returns the position of the first occurrence of substring substr in string str.

No problem. Happens all the time. If you can mark any answers as accepted, that will help others in the community.

It doesn't like the tics around Unassisted Entry. Use the same type of single quotes you have around LiveStream and PhoneAutomatedPin on the Unassisted Entry and it should work.

Create a beast mode/calculated field that looks like this: CASE WHEN joinmethod in ('PhoneAutomatedPin','LiveStream') THEN ‘Unassisted Entry’ ELSE joinmethod END Drag this beast mode into your series instead of the joinmethod and the chart will do the rest.

@zgranperc in your card, set the date range to be the last 7 days On your scheduled report, set to run every Friday and make sure the time is set to 12:01am, or something very close to the start of the day. This will keep it dynamic and will work as the weeks go by.

I would look at @GrantSmith 's post here: It does a nice job of how to calculate the difference for you.

@NathanDorsch I was able to accomplish what you want to do by developing the period over period comparison in Magic ETL. I created a video that walk you through it, which is below. In Magic ETL, you just need a few tiles: Formula tile to create a common month/year date using the LAST_DAY() function Group by tile to sum up…

I think this is why the Period over Period charts aren't used too heavily as they have some pretty rigid code tied to them. I often use the standard Line + Bar chart and create a few beast modes to have a more flexible period over period chart. I walk through how to do it here:

I would use the DateDiff function to do this. Something like this: case when DATEDIFF(CURRENT_DATE(),Credit Release Date) <6 THEN 'Recent' ELSE 'No' END Returns the number of days between two dates from datetime values. DATEDIFF(CURRENT_DATE(), 'lastmoddate')