ColemenWilson Coach

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.

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: https://calendly.com/cwilsondomo/15min

You need to click "Properties" at the top of the window

The easiest, but perhaps not most efficient, way would be to utilize Domostats datasets, specifically the DataSets report. You can use the Last Run date time field and then a datediff/timediff and set logic in a beastmode that if the time difference between the current time and last updated date/time is beyond a certain…

If your dataset is less than 5MB you can attach a CSV as an attachment: You could also probably utilize workflows if the above option doesn't work for you.

I would try adjusting your Email Connector settings to the following, let me know if you still have an error after doing that. Additionally, if you change the file type to "Email body as HTML" you should be able to see the link and copy and paste it.

I would recommend the beast mode functions guide, although it is similar to what you get within the beast mode editor above https://domo-support.domo.com/s/article/360043429933?language=en_US. Beast modes are mysql, and you can get more detailed information by just googling the function name + "mysql". For example, "ABS()…

I am seeing it in my instance. It may need a feature switch. I would reach out to your CSM!

Hi @benm_2000 could you provide more information?

CASE WHEN CHAR_LENGTH(`yourField`) = 7 THEN CONCAT('000',`yourField`) WHEN CHAR_LENGTH(`yourField`) = 8 THEN CONCAT('00',`yourField`) ELSE `yourField` END Note: this wont work in a beastmode, you'll have to use this in a formula tile in MagicETL