ColemenWilson Coach

@Lu_zhang this should help! 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() You could do this in a MySQL…

Awesome!

You'll need to use the pivot/unpivot tiles in magic ETL. More info here: 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: Alternatively, you could change the update method to append instead of replace and then overtime you would have a history greater than 7 days. You would need to have a unique identifier of each row so you could remove duplicates in…

@ArborRose had this exact problem, here is his solution:

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!:

@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:

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 ) Join it with your data:

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: 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.

I would use an ETL to convert the chinese characters into English, which Domo should recognize: Chinese English 北京市 Beijing 天津市 Tianjin 上海市 Shanghai 重庆市 Chongqing 河北省 Hebei Province 山西省 Shanxi Province 辽宁省 Liaoning Province 吉林省 Jilin Province 黑龙江省 Heilongjiang Province 江苏省 Jiangsu Province 浙江省 Zhejiang Province 安徽省 Anhui…

I have done a ton of testing and I am quite sure this is a bug. I would submit a support case to Domo to investigate.

I'd be happy to jump on a call with you to troubleshoot if you're interested: