Best Of
Re: Beast mode Training
@user000051, posting your questions and approaches to business problems in the Dojo is a great way to verify and refine your beast modes and other features. There are some great minds available here.
amehdad
Re: How to SFTP file in DoMo
Hi @user11651, have you read through this article [https://domohelp.domo.com/hc/en-us/articles/360042931914-CSV-SFTP-Push-Connector] beforehand?
amehdad
Re: Connecting Google Ads
Hi @user048760, how did you go with this? What was the issue/error more specifically that you encountered around joining?
I've used an email forwarding setup with the Google Ads data pull in the past, and the reports I used needed to be built so that the primary key was clear and identifiable before I start any work in Domo. That way, joining and cleaning data steps were easier to carry out.
amehdad
Re: PDP tied to user?
Sorry for any confusion in my last paragraph, I was trying to establish if there was any way of seeing the difference in policy settings on the 'PDP' section before you looked at Page 1 and 2.
So Page 1 and 2 have the exact same cards but you've applied a filter(s) on the data columns for Page 1 only, correct?
I believe this is a situation where someone will need to see you do the steps in your Domo view and then be able to troubleshoot because while your breakdown of scenario is clear, it is hard to pinpoint issues without seeing what is actually happening in your Domo.
Perhaps while your question is being looked at by others here, it is worth also raising a ticket to Domo Support [https://domo-support.domo.com/] so that they can organise a screen-share session to view your steps and work.
amehdad
Re: PDP tied to user?
Let's go step by step to determine if there was a step missing.
When you are in the 'PDP' section of your dataset, and you click on the 'Impact' button, are there clear differences in the outcomes outlined by Domo (i.e. Messages outlining what is being applied to limit the data) or does both your policies created say "Your current PDP policies on this DataSet will not have any affect on your Domo resources"?
Also, do you see this button next to 'Enable PDP'?
https://domohelp.domo.com/hc/article_attachments/360059655973/disable_pdp.pngIf not, then enable the policy to be applied to your dataset.
amehdad
Re: Simple Addition and Subtraction
@Emma the IFNULL function is also useful for this and does the same thing. COALESCE is useful when you need to evaluate multiple fields before replacing with a single value. Here is what yours would look like with the IFNULL function:
IFNULL(`Total Stock`,0)+IFNULL(`Total QTY to be delivered`,0)-IFNULL(`Total fcst QTY`,0)-IFNULL(`Total Reqmt QTY`,0)
Re: Simple Addition and Subtraction
Glad this worked for you @Emma. Can you make sure to accept the answer so it's easier for others to find in the future? Thanks.
Re: Map a zero value for weeks that don't have data
Glad this worked out for you @Rvannoy . Can you make sure to accept the answer so that others can more easily find this in the future?
Re: Simple Addition and Subtraction
Hi @Emma
You can use the COALESCE function to default a null value to a specific value. It does this by selecting the first non-null value in the list of parameters given
COALESCE(`Total Stock`,0)+COALESCE(`Total QTY to be delivered`,0)-COALESCE(`Total fcst QTY`,0)-COALESCE(`Total Reqmt QTY`,0)
If you use simple arithmetic operators (+, -, *, /) with a null the end result is null because it doesn't know how to handle nulls.