Best Of
Re: Numbers are not visible on bar chart
Agreed, thanks a lot for your time and efforts. The resources which you shared are super useful.
Jay.p
Re: Compare gauge value with more than 1 target/comparison values
I don't believe you can compare more than one using the card. The multi-value card only supports one target value. You could create a custom brick using html, css, javascript.
Or use a table card with beast modes
% Change vs LY: (SUM(`Income`) - SUM(`LY_Income`)) / SUM(`LY_Income`)
% Change vs Budget: (SUM(`Income`) - SUM(`Budget_Income`)) / SUM(`Budget_Income`)
Re: Magic ETL Won't Save DataFlow?
Welp - I just had to remove some datasets and add them back. Not sure what happened exactly but glad that stripping down the inputs helped. 3
Re: Can I save a copy of a card's drill path as a standalone card?
@mhouston Correction... "Save As" is not within Analyzer, but can be found in the Sharing menu from the drill layer. My apologies.
Re: Cannot retreive more than 2000 rows without a unique ID in Salesforce Connector.
The connector requires a unique id in order to retrieve more than 2,000 rows. You'd need to add a unique id to your report or you'd have to construct a SOQL query that replicates the report
Re: Request Manager Approval for Multiple Employees in 1 email
Notifications can be configured on a user by user basis.
Re: why date filter is not working? When I chose last 7 days, it doesn't filter data.
@jhp Do you have the date range hidden on your revenue cards? If this box is checked in Analyzer, then the card will not react to dashboard date filters.
Re: why date filter is not working? When I chose last 7 days, it doesn't filter data.
I'm assuming the "Date Presets" card is a Date Selector filter card. Do the "Date Presets" and "Revenue" cards use the same dataset? If no, they both need to contain date columns with the same name in order for the filter interactions to work.
Re: Request Manager Approval for Multiple Employees in 1 email
It sounds like you need to iterate through the dataset twice to get what you want.
First pass: Group the results by manager to send a single notification email per manager. Unless personalization is crucial, you can simplify the email content since the manager will be directed into Domo to complete tasks anyway. If you do want to list employees in the email, loop through each manager’s employees and build a concatenated list to include in the message body.
Second pass: Create an individual approval task for each employee, assigning it to the appropriate manager. That way, managers receive just one email but see distinct tasks for each direct report requiring access approval.
