Best Of
Re: How do I get color rules to apply to all pivot table levels?
Make sure you check this box in the "general" properties.
Re: Print A Word Document with Domo Data Using Word Template
This is something where you could use workflows to upload the text you want changed and use some simple javascript to modify the text and then download it.
Here is an example:
function downloadAsWordDoc(content, filename) {
const zip = new PizZip();
const doc = new Docxtemplater(zip);
doc.loadZip(
new PizZip(
`<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<w:document xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main">
<w:body>
<w:p>
<w:r>
<w:t>${content}</w:t>
</w:r>
</w:p>
</w:body>
</w:document>`
)
);
const blob = doc.getZip().generate({
type: 'blob',
mimeType: 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'
});
saveAs(blob, filename);
}
const template = Hello <USERNAME>!
I wanted to inform you that your <YEAR> <MAKE> <MODEL> vehicle is due for service.
You should contact 801-833-XXXX and plan a date to bring in your vehicle.;
const values = {
USERNAME: 'John Doe',
YEAR: '2021',
MAKE: 'Toyota',
MODEL: 'Camry'
};
const result = replacePlaceholders(template, values);
downloadAsWordDoc(result, 'document.docx');
————————
This type of implementation could take just a little bit of custom code to get working in my opinion, but the connecting it up will just take some tweaking.
Re: YouTube Connectors Using YouTube Account Username and Password
Hi @MrDomo
Do you have an enterprise account and you're wanting to pull the specific channel's videos? YouTube makes it a bit difficult as you have to log in / authenticate as the brand page account and not the enterprise account.
You account name would look something like *****-###@pages.plusgoogle.com. It'll be the same password as your main login account.
Color blindness & creative solutions
After the recent Domo XCanva Challenge, I am a bit more aware of when I am coloring outside the lines in producing a result. I just created a blank brick for a large table (simulated here in smaller version screenshots) that includes rankings on several columns. The request includes heat mapping on the columns. Since this is in a Domo brick, I produced my own heat rank.
Then I realized I had not accounted for people with color blindness. So I added functionality - a checkbox in the bottom corner. When checked, my table changes the colored heat map column backgrounds to white and displays black and white patterns for people who can't distinguish color.
Then I started wondering what creative solutions the rest of you might be implementing.
Re: Total of All States on State Map
Yes, create a beast mode to calculate the % of total. Then use that as your value.
SUM(value) / SUM(SUM(value) fixed())
Here is a reference on FIXED functions
Re: NetSuite Created Date
This is because Domo is applying a timezone adjustment. Domo assumes that date times are loaded in as UTC, and adjusts to your company timezone. In this case, you can fix this by changing the column type to be a date, and not a date time, and the adjustment won't happen.
I'd also recommend checking your other date time columns to make sure they are being handled properly. If they are not UTC, and you have a company timezone set, it's possible that some of them will shift between days.
Re: Compare to Budget - Actuals in one Dataset and Budget Values in second Dataset
@Data_Dev, I'm suggesting the opposite. If you take your monthly budget values, and turn them into daily budget values (by either dividing by the number of days in the month, or aggregating up to the year and dividing by the number of days in the year), you will end up with daily budget and daily actuals. This will let you do things like, MTD actual vs budget, last 30 days actual vs budget, etc. It will also let you filter to any date range, and have your actual vs budget be accurate. See here for a reference.
If you go through and map all the values, I would recommend doing this in a new column rather than updating the values in the existing column. This will let you display the data using the non-edited values, but still join.
Re: App Studio: Ability to remove filter icons from cards
No. There is another page setting dialog. If I click on this small space between my card and the scrollbar, it brings up a page settings display. At the bottom is "filter options". Click that button to get the dialog.
Re: Email connector
You'll have to set up a separate import for each tab in your document. There is an "Excel Sheet Tab Number" parameter when you set up the connector. If they all have the same data structure, you can then use a dataset view or Magic ETL to union them together.
May Community Forum Highlights
Hello Domo Community!
It's June! ☀️ Which means it's time to post the May Community Forums highlights. Follow the discussion, ideas, and user links to contribute to May's hot content 🔥
Leaderboard Top 3
We love seeing the monthly competition. @david_cunningham knocked @GrantSmith and @ColemenWilson out of the top spot for the first time in a long time. Huge thank you to all of you!
- @david_cunningham 1.4K points
- @GrantSmith 523 points
- @ColemenWilson 475 points
Top 3 Posts
Of the 303 discussions that were had in April, these three got a lot of views and engagement. Follow the links and leave a reaction if you found them helpful too.
Shoutout to the following community members for asking and answering our top discussions this month: @user027702 @MattTheGuru @ArborRose @Zel @david_cunningham @MichelleH @DashboardDude @Jarren
Top 3 Ideas
The Domo product is always improving because of your ideas. Of the 60 ideas posted in May, these three got the most votes. Click the links below and give these ideas additional upvotes to increase their chances of getting implemented into Domo.
- Add True Card View reporting
- Continually show tabs in app based on user attributes
- Make exporting, user comments, and real time collaboration possible within app studio
Congrats to these community members for coming up with innovative ideas: @ellibot @SherryR @thampton10
May Community Member of the Month
@Sean_Tully has shown up in May! @Sean_Tully answered 29 questions this month. Sean has received over 25 positive reactions in May (likes, agrees, insightfuls), so we know @Sean_Tully's content is valued! Thank you for your contributions to the Forums. We're getting excited to add you to our Coach club here soon ✈️
Like this post if you've been enjoying the monthly Community highlights. And make sure to congratulate @Sean_Tully in the comments below 🥳
