ColemenWilson Coach

The best way is in a beast mode: CASE WHEN UPPER(`yourField`) IN('S','T') THEN 'Out' ELSE 'In' END Then use this field as a filter on the card/page.

Won't be too bad. Output becomes only input. Remove duplicates tile to prevent any duplicate rows. Set update to manual.

You could just make the dataset recursive and then you could remove the inputs.

@Lu_zhang this should help! https://domo-support.domo.com/s/article/4408174643607?language=en_US I used example #1.

If you remove the background from your dashboard that will go away. Or you can make the filter card wider on the page and it should also go away.

Yep then Group Concat is the way to go! See a basic MagicETL setup below (just swap `state` for `Page` and `Sales Rep` for `Group`: If you are using MySQL dataflow instead, use GROUP_CONCAT() and be sure to have a GROUP BY `page` in your query.

I am not sure exactly the format you are hoping to have, but if you could provide a screenshot or a data table from excel or something showing the format I could help out. I think maybe you are looking for a concatentation into a single column, which you could accomplish using GROUP_CONCAT()…

Awesome!

You'll need to use the pivot/unpivot tiles in magic ETL. More info here: https://domo-support.domo.com/s/article/360044951294?language=en_US Please let me know if you get stuck and I can help out!

You could submit that feedback to the Domo connector team through the ideas exchange here: https://community-forums.domo.com/main/categories/ideas/%40localize_url%28%27/domo-central/help%27%29 Alternatively, you could change the update method to append instead of replace and then overtime you would have a history greater…

@ArborRose had this exact problem, here is his solution: https://community-forums.domo.com/main/discussion/58361/format-as-number-without-comma

Yes. Create a new beastmode: SUM(revenue) /SUM(SUM(revenue) FIXED ()) Use that beastmode as your Province/fsa value Change the Province/fsa Value to a percentage as shown below:

You can change the currency prefix for the field by clicking the V next to your field > Format > $ > select the currency prefix you prefer. If the $ dropdown does not contain the currency symbol you want, you can enter your desired symbol in Chart Properties (Number Format > Currency Symbol). For removing the comma, what…

No but there is an idea for this in the idea exchange, please upvote!: https://community-forums.domo.com/main/discussion/57732/view-as-user-or-view-as-role

@Parkerains I re-read your original question and if you are trying to apply a filter for a certain input then the "Add Constants" tile approach is definitely the way to go. My method is for identifying which field came from which source, not which rows.

Do you want this to be a filterable value or you just want to filter out these values? If you just want to filter out the values, you could do it in an ETL. If you want this to be an option to select, you would need to add the value to the field and then just have a blank row of data beside the filter value in the field.…

No. Default aggregations in Domo are Count, Sum, Max, Min, Average. You can use other aggregations in some chart types and for some applications, as you have shown above, but in the case you are attempting it would require a default aggregation so I don't believe it is possible.

There are a few options for this, all of which we employ at my company. 1. Use field naming conventions. Example: `Salesforce.Account.ID` 2. Use field schema descriptions or tags Would these work for you? If so I could share more info on them if that's helpful.

Yes. You can use a beastmode to accomplish this: CASE WHEN `Color` = 'Black' THEN 'Black' ELSE 'Other Colors' END Here is a good video to help if you've not used beastmodes before: https://www.youtube.com/watch?v=SpVbmZPMAsM

Yep! You can use a pivot table chart type and put all the fields as rows except Note which you'll put as Values. Final result:

You can't using the email connector. You would need to setup multiple email connector jobs and then append/join in an ETL.

I think these chart properties would get you close to what you are looking for.

I've noticed the issue with "@" someone, when it isn't working I just refresh the page and it usually works at that point. Kind of annoying. For the ETL you'll need to: Bring the data table into Domo (as a webform is probably easiest https://domo-support.domo.com/s/article/360043436813?language=en_US) Join it with your…

This is about the best you can do right now, Admin > Company Settings > Display Share Email Notifications

Yes. There is a grouped and stacked bar chart option in Domo:

There is not. Apps use dynamic sizing so you are only estimating sizes either way. Relative sizing/spacing is all that you can ultimately control currently in Apps. I use an ultrawide monitor for app building which makes it easier to resize.

It looks like this Chart Property is not available for Bullet charts.

No problem! Happy to help.

I just tested and you will actually need to remove "province" , "autonomous region" and "Special Administrative Region" from the english names.

Here is how to get the fiscal calendar in Domo: https://domo-support.domo.com/s/article/360042924254?language=en_US But even then you will have issues. I replicated what you are trying to do in my instance and am getting the same result. It is a bug I am pretty sure.