david_cunningham Coach

@TheBeard to open a ticket click on Blue Question Mark in the top right of Domo. Then click on "Support", and enter your companies domain You'll then be able to create a new case (support ticket)

The main difference between the two is that the IFNULL function takes two arguments and returns the first one if it's not NULL or the second if the first one is NULL. The COALESCE function can take two or more parameters and returns the first non-NULL parameter, or NULL if all parameters are null. In your case, either one…

IFNULL(Posted Bill Rate, Original Bill Rate) + IFNULL(Posted Bill Adj, Original Bill Adj)

I don't have an answer to this, but curious if anyone knows if Workbench Enterprise would enable you to achieve this. Curious to hear from others who have used the new WBE.

What you want to do is create a beast mode that creates a flag of 1 when your condition is met. Then use an aggregation of that beast mode in your summary number, and set the condition of the alert to be when > 1.

Perhaps I'm not fully understanding your question. But it sounds like you can take the Net Gain column and add that to the Month column to get your month ending balance. It looks like you already have this column in your example screenshot. What am I missing?

@DustinBlock I had this happen, and clearing the cache wasn't enough for me. Here is what I had to do to fix the issue. Press Ctrl+Shift+i to open up the inspector. Then right click on the browser refresh button and select "Empty Cache and Hard Reload". Clicking that and then refreshing the page solved it for me.

Are you saying that you want each value in it's own row? If you want in a unique column, you could use the Split Column Tile. If you want each in it's own row, you would need to first split into columns and then use the unpivot tile to convert to row format.

@Data_Devon - yes, unfortunately that is a limitation of the Pivot tile. There is no dynamic generation. Keep in mind that you wouldn't have to code every single patient ID, just the appointment types. The patient ID would be your group (row) identifier. Not sure how many appointment types that you have. If that's too…

@Data_Devon I’d recommend looking at and using MagicETL pivot roles. Here is a link to the documentation. Feel free to reach out if you have any questions. https://domo-support.domo.com/s/article/360044951294?language=en_US

@Agnes0815_ - I would recommend Analyzer or Beast Mode

@Sean_Tully - you can use the Line + Grouped Bar Chart and then just specify the number of series on the left scale in the properties. This was built using a unique beast mode for each column/line

You would need to remove the $ if it is stored as text. You can do that with string functions. REPLACE() is probably your best bet.

What card type are you using? Can you please post a screenshot of your problem and what you are trying to achieve and I'd be happy to help troubleshoot.

One thing you could do is to use a tooltip and wrap your value inside ABS() in beast and then display that tooltip. That way the values you display will be positive, but the chart will still be inverted like you are looking for.

@DavidChurchman - yes, the table card approach is usually what I have done in the past. I was mostly just curious and posting due to yesterday's Frenzy day. I was hoping that someone at Domo would know of a way to achieve this. I think that tooltips are somewhat of an under-developed / under-utilized feature, and thus have…

Agree with @ArborRose on this one. In fact, I had essentially the same response written out, but I guess I forgot to hit "Post". Anyways, just stopping by to say that the path Arbor suggested is the same route I would likely take if I was trying to do this.

In order to do that, you would need to fill in the missing data. The best place to do this would most likely be in your ETL combined with a date dimension. This will help you make sure you have data for every single day of the week. You can also wrap your column inside of an IFNULL() to replace Nulls with Zero

@ColemenWilson yeah, that's about as far as I got as well. Would love to connect and figure this out together. Curious to hear from Domo peeps what they think is possible on this front

Can you post a picture of the configuration for the Custom2 attribute? You can open this up by clicking on the pencil icon on the attribute management page.

@TejalGovila - I would say that variables are probably your best bet. You would want to define the logic for the date ranges and then use that variable inside of a case statement. You can then place the variable on to a dashboard as a control, and let users toggle.

At this point, I'd recommend opening a support ticket. I wish I could help you out more! Please let us know what the issue/resolution ended up being. If anything else comes up, feel free to reach out.

@Nahanaeli I haven't done this - but off the top of my head I would say the easiest way would be to: Connect Domo data to Excel using the excel connector, and pull into Excel. Make the charts/visualizations you want Reference that in your PPT

@German_Rodriguez - there are a couple of functions that work that are not listed in the official documentation. There are also functions that exist in MagicETL, that do not exist in Beast Mode (and vice versa). In this case, REGEX_REPLACE is a listed MagicETL function.

What happens if you try setting up the connection on a brand new workbook rather than a new sheet?

Something like this is going to be fairly difficult to do in a single card. Reason being is that the way you would have to structure your data would be very particular to this individual visualization. Rather than trying to create a single visualization, I would recommend splitting it out into several cards that you can…

Are you pulling data from Domo into Excel, or are you trying to push data from Excel into Domo? Have you tried breaking and re-establishing the connection?

There is a Google Sheets connector that you can use. You'll want to prepare your spreadsheet as much as possible before ingestion into Domo with the proper columns/labels. With this connector, you can set it up to import manually, or on a schedule. If there are any transformation that are difficult to do in Google Sheets,…

@Cbrack are you still experiencing this issue? I ran into some issues myself with the Excel connector, but they seemed to have resolved themselves as of this morning.

I can't speak specifically to this connector, but in the past when using some of the Microsoft connectors, I've had to make sure to be out of the file for it to update properly. You may have already done this, but linking the documentation below so you can review to make sure that you have everything properly configured.…