RGranada

Comments

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

in Color setting on Scatter Plot Comment by RGranada February 2018
Ok, So you have multiple series... Each Serie corresponds to posts from a determined country, is that it? Regards,

in Color setting on Scatter Plot Comment by RGranada February 2018
Hi Is the country the only series in your chart? Regards,

in Color setting on Scatter Plot Comment by RGranada February 2018
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…

in Case statement with multiple field conditions Comment by RGranada February 2018
Hi, Try this : SUM(IFNULL(`cash`,0) ) + SUM(IFNULL(`credit`,0) ) Hope this helps, tell me how it goes.

in New User: Calculated Field Sum Error; Cannot find resolution documentation Comment by RGranada February 2018
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…

in Case Statement (dividing by specific conditions) Comment by RGranada February 2018
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,

in Case Statement (dividing by specific conditions) Comment by RGranada February 2018
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…

in error in documentation of weekday beast mode function Comment by RGranada February 2018
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…

in Case Statement (dividing by specific conditions) Comment by RGranada February 2018
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.

in Is a Case Statement using COUNT / SUM possible? Comment by RGranada February 2018
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…

in Why do some cards have different summary number rules? Comment by RGranada January 2018
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.

in Can we copy Magic ETL actions from one data flow to other data flow? Comment by RGranada January 2018
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.

in Can we have different goal for different category in the same card? Comment by RGranada January 2018
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…

in Beast mode calculations with multiple conditions Comment by RGranada January 2018
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.

in Reports on datasets and dataflows Comment by RGranada January 2018
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…

in Combining 4 rows into 1 on a dataset Comment by RGranada January 2018
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.

in PPT template when exporting Comment by RGranada January 2018
Is it possible for you to send a sample of your data in excel?

in Using case statement to make a value if null and run a calculation if not Comment by RGranada January 2018
Can you send a screenshot of it or explain it a little deeper... Regards,

in Using case statement to make a value if null and run a calculation if not Comment by RGranada January 2018
The formula doesn't evaluate yet?

in Using case statement to make a value if null and run a calculation if not Comment by RGranada January 2018
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

in "Invalid Formula" when trying to sum columns Comment by RGranada January 2018
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…

in Using case statement to make a value if null and run a calculation if not Comment by RGranada January 2018
What is the time2 field data type?

in Using case statement to make a value if null and run a calculation if not Comment by RGranada January 2018
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.

in Using case statement to make a value if null and run a calculation if not Comment by RGranada January 2018
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

in Using case statement to make a value if null and run a calculation if not Comment by RGranada January 2018
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,

in Record count for prior month or prior quarter at start of the year Comment by RGranada January 2018
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…

in Using case statement to make a value if null and run a calculation if not Comment by RGranada January 2018
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)…

in Record count for prior month or prior quarter at start of the year Comment by RGranada January 2018
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,

in Delete Blank Rows in Table Chart with columns built with BeastModes Comment by RGranada January 2018
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…

in Sum of Value based on specific date parameters Comment by RGranada December 2017

More Comments

RGranada Contributor

Comments