RGranada Contributor

Can you please show me your card setup, just the columns section? Regards.

Ok, So you have multiple series... Each Serie corresponds to posts from a determined country, is that it? Regards,

Hi Is the country the only series in your chart? Regards,

Hi, Give this a try: CASE WHEN `cpt_code` = '20610' AND `icd_1` != '71516' AND `icd_2` != '71516' AND `icd_3` != '71516' AND `icd_4` != '71516' THEN 'Yes' ELSE 'No' END Basically, you were missing the AND operators and had a double cote in : «else "No'». The != (not equal) operator is a little faster when comparing text…

Hi, Try this : SUM(IFNULL(`cash`,0) ) + SUM(IFNULL(`credit`,0) ) Hope this helps, tell me how it goes.

I personally don't like that type of aggregation filters... Can you try this, and check the numbers... IFNULL( SUM(`CompletedOffers`) / NULLIF(SUM(`SettledOffers`),0),0) If you don't need the zero in case `SettledOffers` are zero and can live will null use : SUM(`CompletedOffers`) / NULLIF(SUM(`SettledOffers`),0) Any of…

No problem @John-Peddle. With the formula I provided if you filter the same agents at top level, the results do change? Or is it a diferent formula when you filter the agents at top level? Regards,

Hi @AS, @sia Doesn't the value returned by Weekday depend on the instance configuration(first day of the week), or time zone settings? I made a quick test and I'm getting 7 for Sunday... Furthermore, it seems to me that WEEKDAY as been deprecated in favor of DAYOFWEEK, I can't even find WEEKDAY on the documentation anymore…

Hi @John-Peddle, I think the problem on @Valiant code is that it has an Aggregation deep in 2 nesting CASE WHEN statements, from my experience that is something DOMO just, doesn't like... Now if I correctly understood your problem, this code should help you: SUM(CASE WHEN `Owner` IN ('Jane Doe','John Doe') THEN…

Hi, If I understood correctly your question, this may help: COUNT(CASE WHEN `Owner` = 'Jane Doe' OR `Owner` = 'John Doe' THEN `Owner` END) / NULLIF(SUM(`Settled`),0) Tell me how it goes.

Hi The catch is that for a Beast Mode to be eligible to be a Summary Number is has to be aggregated. In other words, the values in it have to be obtained using an aggregation function like SUM(), MAX(), AVG(),... In order for your Beast Mode to appear in summary number you will have to aggregate `%ofGoal`, but being a…

Hi, From my knowledge, it is not possible to copy actions between two different Magic ETL dataflows. There are some ideas in that sense like this one : https://dojo.domo.com/t5/Ideas-Exchange/Magic-ETL-Repository-for-Saving-and-Accessing-Pre-Configured/idi-p/30102/jump-to/first-unread-message Hope this helps.

Hi, Currently, most if not all card types only have one Goal setting out of the box. Sometimes what I do is create a series for each goal I need to represent. This goes well with a Line+bar chart. Hope this helps.

Hi, You must be looking for something like : CASE WHEN Ad = Rewards and Activity = 'App Complete' THEN click through WHEN Ad = RewardsZX and Activity = 'App Complete 2' THEN click through2 WHEN Ad = Type2 and Activity = 'App inComplete ' THEN click through3 END those are example situations. There is a nice video on case…

Hi, Your best chance on this would be to reach out to support and have them enable DomoMetrics datasets in your instance. Some datasets in this feature may help you gather the information you need. Hope this helps.

Hi, You can try this in MySQL Dataflow: SELECT CASE WHEN `Segment_name` = ' Segment_1' THEN `Value` AS Segment_1, CASE WHEN `Segment_name` = ' Segment_2' THEN `Value` AS Segment_2, CASE WHEN `Segment_name` = ' Segment_3' THEN `Value` AS Segment_3, CASE WHEN `Segment_name` = ' Segment_4' THEN `Value` AS Segment_4 From…

Hi, Have you tried the PowerPoint Plugin? There is some good information on that in this link: http://knowledge.domo.com?cid=domopowerpoint Hope this helps.

Is it possible for you to send a sample of your data in excel?

Can you send a screenshot of it or explain it a little deeper... Regards,

The formula doesn't evaluate yet?

Hi, If you need to sum the totals of your Q1,Q2,Q3 and Q4 Actual spends, try it like this: SUM(`Q1 Actuals`)+SUM(`Q2 Actuals`)+SUM(`Q3 Actuals`)+SUM(`Q4 Actuals`) Hope this helps

Ok, Datetime can be a little tricky to check for null... Try it like this: CASE WHEN IFNULL(`Date/Time Opened`,'9999-12-31')='9999-12-31' THEN 1 ELSE ((DAYOFMONTH(LAST_DAY(`date_created`))*1440) -SUM(TIME_TO_SEC(TIMEDIFF(`time2`,`time1`)))/60) / (DAYOFMONTH(LAST_DAY(`date_created`))*1440) END I tried this on sample…

What is the time2 field data type? 

If you are sure that `time2` will be null when you have no values try this: CASE WHEN IFNULL(`time2`,0) = 0 THEN 1 ELSE ((DAYOFMONTH(LAST_DAY(`date_created`))*1440) -SUM(TIME_TO_SEC(TIMEDIFF(`time2`,`time1`)))/60) / (DAYOFMONTH(LAST_DAY(`date_created`))*1440) END Tell me how it goes.

Ok, So, for debugging sake, will it give you the same error if you lose the null part? Like this: ((DAYOFMONTH(LAST_DAY(`date_created`))*1440) -SUM(TIME_TO_SEC(TIMEDIFF(`time2`,`time1`)))/60) / (DAYOFMONTH(LAST_DAY(`date_created`))*1440) Regards

Hi Maybe your problem is not on the BeastMode I tried that in my account and it's returning the date 2017/12/31 for the current date. Are your "hiredate" and "dateOfTermination" DateTime fields? Regards,

Hi I think you don't have the same data type returning on both CASE branches, you are returning a string and a number. Try : CASE WHEN `time2` IS NULL THEN 1 ELSE ((DAYOFMONTH(LAST_DAY(`date_created`))*1440) -SUM(TIME_TO_SEC(TIMEDIFF(`time2`,`time1`)))/60) / (DAYOFMONTH(LAST_DAY(`date_created`))*1440) END Tell me how it…

Hi, Can you try this one out: Sum(CASE WHEN `hireDate` <= DATE_SUB(LAST_DAY(CURDATE()), interval 1 MONTH) AND `dateOfTermination`IS NULL THEN 1 ELSE 0 END + CASE WHEN `hireDate` <= DATE_SUB(LAST_DAY(CURDATE()), interval 1 MONTH) AND `dateOfTermination` >= DATE_SUB(LAST_DAY(CURDATE()), interval 1 MONTH) THEN 1 ELSE 0 END)…

Hi, I think this depends on the reason why the rows are appearing empty in the first place. Did you try filtering them out? Can you provide some more info on your data and beast modes? Regards,

Hi, If I correctly understood your problem this modification should help you: SUM(Case when (`hireDate`) <=DATE_SUB(LAST_DAY(STR_TO_DATE(CONCAT(YEAR(CURDATE()),'/',QUARTER(CURDATE())*3,'/01'),'%Y,%m,%d')), interval 2 QUARTER) And `dateOfTermination`is null Then 1 else 0 End + Case when…