MarkSnodgrass Coach

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. https://dojo.domo.com/main/discussion/52682/domo-ideas-conference-beast-modes-time-difference-formatting

@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: https://youtu.be/mDwSQGAjIrs

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

I would use the formula tile and use the replace function multiple times to remove those characters. Something like this: REPLACE(REPLACE(REPLACE(fieldname,'[',''),']',''),'"','')

@pstrauss I was thinking you would convert the time to a military time so that there is no confusion between 1am and 1pm. I haven't tried it, but would think you could use the time_format function to do this. You can use this page as guide to the proper formatting. https://www.w3schools.com/sql/func_mysql_time_format.asp…

If by blank you mean null, then you can use the IFNULL() function to do the replacement ilke this: IFNULL(`appeal determination date`,`determination date`) If it isn't actually null but an empty space you can do this: CASE WHEN TRIM(`appeal determination date`) = '' THEN determination date ELSE appeal determination date END

I find it best to use a numeric sort for the heat map. I would create a beast mode for the day of the week that returns the number (1-7) for the weekday, I would also do beast mode that returns a numeric value for the time.

@gbrown Form Builder is pretty basic and doesn't have any barcode scanning or QR code functionality, to my knowledge.

I have not experienced that issue. If you can replicate the issue with the user, I would do a screen recording of them submitting the form and then show that the dataset still doesn't show the submission and then sending that recording to Domo support as a ticket.

I would check in your data center to see if there is another responses dataset with a very similar name. Depending on how your form viewer was created, you can have multiple response datasets. It's possible the other user's entries are going in that other dataset. You can merge them together using the Append tile in Magic…

@gbrown if you are talking about viewing past submissions within the form viewer app, you have to configure that in the form builder configuration. In Form Builder, click on the 3 dots next to your form and click Edit. Then select "Allow previous submissions to be viewed". You can also allow previous submissions to be…

If you really wanted to generate the name of the month and year as text in your ETL, you can use the formula tile to do this. Your formula would look like this: DATE_FORMAT(`ActiveDate`,'%M %Y') However, if you leave the date as an actual date, in Analyzer, you can use the custom date format option in the field.…