MarkSnodgrass Coach

Someone else had a similar question and I suggested creating a beast mode like this to filter to the list of values. Not sure it will work for your use case, but may help. 1. Create a beast mode that has your e-mail addresses by using a case statement like: CASE WHEN 'email' IN (<your list of e-mail addresses>) THEN 'Y'…

If I have pages that I need everyone to look at and control the order of the subpages, I add them to the company pages. You can do this in Admin -> Company Page Settings

Not sure if this is what you are going for, but I put together how to get the Top N of a Subcategory that may help you. https://youtu.be/hfIUQqeRVkM Hope this helps.

Did you have any luck with this connector? It may help others in the community if you are able to share you experience,

When drilling from a table card, the drill path will use whatever field is clicked on as the filter. So, if a user clicks on appt # 80136, it will drill into that next card filtered to appt #80136. This seems like what you want to the user to do. All you would need to do is add a filter in analyzer on your drill path card…

I have not seen this before. Did you get this figured out? If not, if you post a screenshot, that may help.

can you be more specific as to what api call you are using and how you are sending it? I think if you provided more details, someone might be able to help

Have you tried this: COUNT(DISTINCT CASE WHEN `pageid` = 'ABC' then `sessionid`end ) This should do it

I would consider creating a Magic ETL that appends all your datasets together into a single dataset that would be used for all your cards on this page. You can add a constant for each dataset before appending to make it easy for you to create the card for each of your "feeder" cards because you can use that constant as a…

You can leave the start date as your x-axis, but you need to change how you count your open and closed dates. I would create a beast mode for open and one for closed. They would look like this: Open CASE WHEN LAST_DAY(startdate) = LAST_DAY(openeddate) THEN 1 ELSE 0 END Closed CASE WHEN LAST_DAY(startdate) =…

Have you tried the Hubspot Quickstart? That is an easy way to see what is possible with the connector as it will create a page full of cards for you based on the data. Looking at the link in the documentation that takes you to the Hubspot API documentation, it looks as though Hubspot has been replacing their API and Domo's…

If you have window functions in beast modes enabled in your instance, you could this in analyzer. It would look something like this case when MAX(`product_weight`) OVER(PARTITION BY `invoicenumber`) = `product_weight` then `product_description` end In your card, drag the invoice number and this beast mode into your card.…

You can do this in Magic ETL pretty easily with a formula tile, group by tile and a rank and window tile. In the formula tile, use the LAST_DAY() function to normalize the dates in each month to the same day, like this: LAST_DAY(datefield) In the group by tile, group by your last day field and do a distinct count of…

Embedding a dashboard is a premium feature. You can reach out to your CSM to get a trial of it and pricing information.

If all your SKUs are actually all numbers, could you specify the type to be integer in your API? Perhaps that would keep Domo from adding the decimals.

If you are referring to using the Send/Export button and choosing PowerPoint, Domo is creating an image of the card and putting it into a slide. Once inside PowerPoint, you can drag the corners of the image to resize it. Tables do not export well to PowerPoint through this method. If the table is very wide or very long,…

I am finding that Form Builder is in its infancy as far as feature development and things aren't completely built out. I found their bulk upload to not be very useful as it doesn't provide you any guidance as far as acceptable values. I would encourage you to add suggestions to the Ideas Exchange and hopefully they will…

That's quite strange. I did the same searching and it resulted in the same thing. Shows up in Google results, but not in the appstore when I am signed in. I would ask your CSM about the connector. It may be one they has to be enabled by request.

@svetlana what Grant is saying is that you need to have two beast modes, one to be used for display purposes on your chart and one to be used in the sorting properties. They will have the same case statement syntax in them, just the sorting properties beast mode will result in a numerical value rather than a string. This…

@elicohen since DDX bricks are so new, I expect to see a lot of future releases addressing issues that come up as people try to use them. This appears to be a CSS issue. Have you tried changing the z-index on the navbar menus to see if you can get it to float over cards below this one in your dashboard? I think that is the…

Unfortunately, you can't have a drill path card be dynamic in what columns are displayed at this time. A workaround is to build a dashboard and then build cards around your main card that would show the different variations that you want. You would can then configure your main card not to drill, but to interact with the…

Well.. I suppose you could do something in MySQL by using the information_schema table during the process. You could google mysql dynamic column names and see if that is what you would want to do. However, having new column names all the time will require you to update any cards tied to that dataset. The cards won't be…

It seems like you could look at the number of distinct days and the sum of the hours and then divide it and see if it is greater than or less than 7 to determine if it is full. If you did this as a beast mode in the card, this would give you flexibility to allow the user to select different date ranges. Your beast mode…

It seems like your columns names are locked into what they should be renamed to regardless of what the current date is. Wouldn't you just use the Select Columns tile in Magic ETL and change the columns there? FC1 -> Apr-22 FC2 -> May-22 FC3 -> Jun-22 ....

Magic ETL does need a column to be selected. The easiest way to do this is to use the Add Constant tile and create a column with a constant value or do the same with the add formula tile. Then, just add this column to your group by and sum on the field you need to sum up. You can remove afterwards with the select columns…

If you are using Domo Workbench you can set the column type to string on the schema tab. If it is coming from somewhere else, you can add the zero back in Magic ETL by using a formula tile and the LPAD function like this: LPAD(zipfield,5,'0')

Makes sense. So the base url is specific to the form that was created. For everyone's benefit out there, it is easiest to do a test entry and attach a file and then copy the URL that is being used for that form and then the final number at the end is the file id, which is stored as a value when the form is submitted. Use…

@DanielShurina690 great job figuring that out. How did you determine your base URL? https://dd887... It seems like that might be different for every Domo instance and it's not clear what that is based on.

Try moving your count distinct to the very outside like this: count(distinct (CASE WHEN `BRAND` = 'A' THEN (case when `Volume` > 0 then CONCAT(`CUSTOMER_NUMBER`,`BRAND`)end) WHEN `BRAND` = 'B' THEN (case when `Volume` > 0 then CONCAT(`CUSTOMER_NUMBER`, `SubBrand`)end) END)) 

We have form builder, but haven't used the attachment feature yet. I just played around with it and I don't see how you are supposed to view attachments. I see a documentid column, but it is unclear what url you might add that to in order to view the uploaded document. I will be curious as to what the answer is for this.