Comments
-
Yes. Here's a KB article on it: https://domo-support.domo.com/s/article/360044876194?language=en_US Here's a video I have on it:
-
That sounds like you would need to contact the software dev if it is not even showing up in your initial dataset. Your only workaround would be to have another dataset that is either manually maintained or is another dataset that just lists all projects and then join them together in Magic ETL.
-
Yes, you can wrap IFNULL() around anything. If you are able to send a screenshot of what your card looks like in analyzer, that might help with the troubleshooting.
-
I'm guessing that your project cost field contains nulls, which is likely eliminating those other projects. Try creating a beast mode that looks like this: IFNULL(projectcost,0) Drag this field into your table card and see if that fixes it. Also, make sure project cost is not in your filters.
-
Yours looks like mine and mine works to put in the filter. Do you have a space before desc? It is hard to tell.
-
When you set the date range filter to This Year, you eliminate any previous year data. You would need to include the last 2 years in your date range filter and then use a beast mode to filter out the dates you don't want and add that to your filters. This video may help you:
-
Did you provide them with a PEM key for them to use when pushing the data? I have several third parties that use this connector and they are not experiencing an error. Here's the KB article if you haven't already looked at it: https://domo-support.domo.com/s/article/360042931914?language=en_US
-
If your Excel file is stored in OneDrive or your company's Office365/SharePoint system, you can use the OneDrive connector or the SharePoint Online connector to have it directly connected to a card.
-
Rank can be hard to do in a pivot table card. I would start with a mega table and see if you can get the ranking how you want it and then drag your ranking beast mode into the filter and set your number there. This video walks you through how to do it.
-
I don't have to work with GA4 data, but generally speaking, you can eliminate duplicates in Magic ETL. You can use the Remove Duplicates tile, or you can use the Group By tile and use aggregations such as Max and Count Distinct to remove duplicates.
-
Each user can set their own language setting by clicking on their profile icon in the top right corner of domo and clicking on the setting icon. They can set their own time zone and language.
-
This has been a common frustration with smart text. Until they add this ability, I use a dynamic textbox card and put it next to the accompany card to provide that context.
-
You can color just the text by sliding the opacity to 0 and then selecting one of the first 3 text options and unselect apply format to table row. This video walks you through how to do it. I think you would need to switch to a pivot table if you want total positions for both rows and columns
-
@BenSchein I'm glad you are in the same boat and can empathize with the annoyance of this issue. Hopefully, your influence will help this idea be implemented. I have started using both Chrome and Edge as a way to avoid running into the issues, but it would be nice to just use my preferred browser without worrying about…
-
Congrats on making your way through the exams! If I recall, you can either record a video or submit screenshots, whichever is easier for you. You don't need to do both.
-
I have not heard of a limitation to which groups are accessible. I would suggest submitting it to the beta feedback team.
-
When you are editing the app, I am able to click on the share icon in the top right and it lets me select a group. If you are not finding that functionality to actually work, I would submit it to betafeedback@domo.com
-
Are you referring to a custom app that you published? Or the new apps that are currently in beta that you build with App Studio?
-
On your dashboard, if you click on the wrench and select Filter Options, you can choose to not show the Filter and PDP icons.
-
I think you could make this easier by using the DATE_FORMAT() function along with DATE_SUB(). CURRENT MONTH DATE_FORMAT(NOW(),'%M %Y') Would return February 2024 PREV MONTH DATE_FORMAT(DATE_SUB(NOW(), interval 1 month),'%M %Y') Would return January 2024 CUR MONTH PREV YEAR DATE_FORMAT(DATE_SUB(NOW(), interval 1 year),'%M…
-
According to the KB article, Form Owners and admin should be able to view all submissions. https://domo-support.domo.com/s/article/360042933614?language=en_US Note: Users are the only ones who can edit their own previous submissions. Form owners and admins may view all submissions, but can only edit their own submissions.…
-
You should be able to see all submissions by looking at the raw dataset that stores the form submissions. Have you tried looking there?
-
You can get this formatted as a date field by using the STR_TO_DATE() function like this: STR_TO_DATE(yourfield, '%a, %d %b %Y %h:%i %p') You can use the monthname function around this function to extract the month name, but that will be a string value since it is text.
-
Another option might be to use the pivot table card. It will allow you to sort by your total column and still have subtotals
-
You can take the beast mode that Grant suggests and make it be the first column in your table, which will then allow it to be sorted first, but I don't think it is the look you are going for. I also found that the regular total column doesn't subtotal in the subtotal row. A workaround might be to make your top level card…
-
If there is always a comma between values, you can use the concepts in this video to break them up dynamically and each phone number will be a row. At the end, I would suggest using the function STR_DIGITS() in the formula tile to remove all non-numeric characters.
-
If you feel that your beast mode is correct, the first thing I would check would be your date range filter settings. Check to see which field is being used in the date range as this can often skew results if it is basing it off a date field that you weren't expecting it to.
-
I believe you can do this without doing any beast modes, but using the aggregation filter capabilities. Here's how: In your table card, drag in Request Date, Individual ID, and then Individual ID a 2nd time, but choose to Aggregate by Count. In your Date Range Filter, set your date range to use Request Date and graph by…
-
Ashleigh, I'm not sure about the ability to right-click, but if you want to have a link open in a new tab, change the false to true in the code that is just after the link. That tells it whether or not to open in a new tab.
-
You can follow the steps in the video to fill in missing dates: