MarkSnodgrass Coach

Glad I could help!

I'm guessing your detail fields are null in table B for MNO. In your ETL, add a formula tile and for each of those fields, add the following formula IFNULL(Bfieldname,0) . This will replace nulls with zeros. This should fix your issue.

There isn't an accordion feature to collapse sections, but you can use the tabs feature in app studio to break up the page.

I would make sure that you don't have any filters in place that are from table B and none of your chart fields are using table B.

@ellibot is the best!!!!

Looks like your screenshot is from this KB article https://domo-support.domo.com/s/article/360043429073?language=en_US which is for the Flex Table chart type that is found in the Tables & Textboxes section of the chart types. Choose that and then you can put Product Line in your series. You would also change the Date Range…

You should look at these posts by @GrantSmith to help you with calculating business days https://community-forums.domo.com/main/discussion/52678/domo-ideas-conference-beast-modes-add-business-days https://community-forums.domo.com/main/discussion/52686/domo-idea-exchange-beast-modes-business-days-prior-to-today

@ArborRose this seems like it would be best to submit a support ticket in instead of posting to the community forum. I can confirm I am seeing the same issue that you are and it requires a refresh despite the message saying "all changes saved" after re-ordering.

Ahh.. If you are using the nested bar chart, you can accomplish this without any special fields. Remove the filtering and sorting and then go to chart properties - general and choose Sort on Totals Descending and Maximum Items 5. These two properties act differently than the Limit Rows and Sorting features and should get…

I would also remove what you have in the Sorting and replace it with the rank field.

You should be able to do this with a slight tweak to the RANK function I covered in the video if I am understanding your requirement. Try something like this: Create a beast mode called rank that looks like this - RANK() OVER(ORDER BY SUM(returnsfieldname) DESC) Add this beast mode to your filters and filter to less than…

Yes, the Limit Rows feature won't work in a grouped bar chart. You will need to use a formula to generate a rank and put that in your filter. Here is a video that shows you how: https://youtu.be/0p2CP-r6C8Q Also, know that in the Chart Properties - General, there is a sort on totals and sort on category settings that are…

Congrats @ellibot !

I agree that the Form Builder instructions are challenging and there are definitely specific steps to make it work properly. I would suggest you use the Forms feature in App Studio. It is much easier to set up. Form Builder is likely to be deprecated at some point as Domo is focusing on App Studio going forward.

Alternatively, you can automate the process of generating the synonyms and context following the steps I outline in this video: https://youtu.be/kNJvYcN6dRQ

I have found that if I want to add multiple synonyms, I would enter one and then tab to go to the description and then go back to the synonym section. I am currently finding that pressing enter after adding a synonym does correctly turn it to a pill and lets me add another one.

Yes, you would be entering the username and password of your OData account. Domo will use this information to access the endpoint. As for the data tag, I would try leaving it blank since it isn't required and then refine it if you can see that information in the data once it is pulled into to know how to better refine your…

That is interesting challenge. I would not be surprised if @ellibot has looked into this. He has done some pretty creative things.

Definitely seems like a bug so you did the right thing by contacting Domo Support.

In your Magic ETL, are you using the Group By tile and using the formula option? You should be able to put your aggregation in that spot and it should work. This Domo KB Article may help you https://domo-support.domo.com/s/article/360044876094?language=en_US#group_by_tile

I did a quick test with a current value of 4000 and previous value of 0 does result in a comparative value of 4000 so it seems like this chart does not correctly divide by zero but treats it as 1 instead. You could add some additional logic to your current value beast mode to be zero if your previous value is zero. This…

This has been a common request. You can upvote this idea here and hopefully it will be implemented soon. https://community-forums.domo.com/main/discussion/55887/dynamic-variables-should-dynamically-change-formatting-as-well

Here's a video where I walk through how to create a more flexible YoY comparison https://youtu.be/mDwSQGAjIrs This one may also be of interest to you https://youtu.be/mP8ZjakQsD4

I just downloaded the Domo Governance Pages and Cards report and the only Owner information I seems to be to the pages, not the individual cards. This report also doesn't seem to list personal Overview pages, so that could be another reason for the discrepancy. I think you are also correct about the pageless cards. I would…

On the Overview tab, did you scroll down to the bottom to see if there is this message? If you click on Start, you will have access to the other tabs.

That is odd. I would try editing the ETL, clicking on the output dataset and then click on Details and then click on the hyperlink that is the dataset name. If it takes you to to the same dead end, I would log a support ticket.

It may have something to do with your custom sort logic. Are you able to share that? I was able to sort my x-axis in ascending order and my legend in descending order by putting both in the sorting section and starting with my x-axis and then my legend.

There are a couple of DomoStats datasets that might help you. Dataflow History Dataflows With Input Datasources The first one has an execution type that will let you know if it was executed on a schedule or on a data update. The second one list the dataflow ID and which input datasets are linked to it. To analyze the…

I would try submitting a ticket to support@domo.com to see if they can enable it for you if it currently isn't.

Looks like @Data_Devon proved me wrong as I needed to reset my chart properties first, Great job Devon!