Best Of
Re: Pivot/unpivot help Magic ETL
@Cbrack - perhaps I'm misunderstanding you, but to achieve your desired output you should be able to load in the group as your column and then average your qty_percentage in the value. For example.
Or are you saying that you want to turn your rows into columns in your ETL?
Re: Datediff in Redshift vs Magic ETL
@Robaba04 Your "week" calculation is the closest to the logic used in Redshift, but you will need to put a FLOOR function around it to round down to the nearest integer:
FLOOR(DATEDIFF(`end_date__c`,`start_date__c`)/7)
Re: Capture filters on a page
You can utilize the onFiltersUpdate function within your domo brick to capture the event when the filters are changed.
Re: Duplicate a card
The easiest way to do this is in analyzer. Just "Save as". You can either name your card the same thing or something different. These 2 cards will not be linked.
Alternatively, if you're wanting to do this with a dashboard, you can "Save as" the dashboard in the same way and create a duplicate copy where the cards are not linked.
Re: Drill within same card
you can change the interaction of the card on your dashboard to drill in place to allow users to drill but keep them on the dashboard. Just edit the dashboard and for each affected card change the interaction from the cards wrench menu to be drill in place
Re: Dashboard Editing
@travisbreeden thanks. You'll need to create a support case. Do so, by clicking in the top right 'support' button or email support@domo.com - please describe what you mentioned and that it's all dashboards. Send the screenshots.
TSHEFFET
Re: MFA on every login
I see this is awaiting review from the product team - hoping there is also an opportunity to authenticate via third party MFA apps (Google Authenticator, etc) on the near term road map?
Re: WorkFlow Code Engine Help
I recreated the codeengine function that you are asking about.
Loom example:
Exact code:
______________
http://const codeengine = require("codeengine")
async function addUsersToGroup(group, person) {
try {
const url = `/api/content/v2/groups/${group}/user`;
await codeengine.sendRequest("put", url, [person]);
return true;
} catch (error) {
throw new Error(error);
}
}
module.exports.addUsersToGroup = addUsersToGroup;
_________________
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
Re: Magic ETL Tiles groups for clearer organization and visibility/observability :D :D :D
@matthewpinson thank you kind stranger whom i've never met before
