MarkSnodgrass Coach

When no filters are selected on your dashboard, your append card should be showing all your data. If it isn't, you need to see what filters are set on it in Analyzer that are keeping it from showing everything. Then, edit your dashboard and choose Edit Content on each of your filter cards and choose Change Interaction.…

All appending is done in dataflows, not in cards. When you say that all cards are coming from the same dataset, is that just the same origin, or they are all actual powered by the same dataset? You can tell by editing a card, and looking at the dataset name on the left side above the dimensions and measures. If all 10…

try adding IFNULL() around each of those like this: IFNULL(Inside Count,0) + IFNULL(Outside Count,0) + IFNULL(Phone Count,0) If you have blanks that aren't nulls, you may want to do some additional cleanup in a formula tile prior to the group by tile.

That does seem like a bug if you are now the current owner and it won't let you certify it. I would submit a ticket to support and have them look at it and hopefully they can create a fix for you. A temporary workaround would create a new ETL and that just has an input dataset and output dataset. If you create that, it…

Remove the sum function in your group by statement. The group by tile will sum it for you. You just need it say: Inside Count + Outside Count + Phone Count

I know I have certified my own datasets. I don't get an e-mail notification, but I am able to go to the certification center and approve it.

There is no way to disable the link to a parent page. I would consider re-thinking your navigational structure so that you have a meaningful parent page. If you can't think of any alternatives, you could create a table card or notebook card that just has links to the subpages.

Are you the co-owner, or the sole owner? It looks as though you need to be the owner of the dataset to request certification. Only DataSet owners—not co-owners—can start the certification process for the DataSet. If a request for certification is submitted by someone other than the owner, a message is sent to the owner…

Unfortunately not. Would be a nice enhancement. Not sure if it has been submitted in the Ideas Exchange, but would be worth adding. I know you're not the only one who could benefit from this type of feature.

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…