emmanuel_fabre Member

Comments

  • @MichelleH. I just updated the beast mode to include all [7] possible combos— Eng Rate CTR Views Eng Rate + CTR Eng Rate + Views Eng Rate + CTR + Views Views + CTR It still errors out only when selecting checkbox
  • @MichelleH In a recent iteration of my beast mode, I included a CASE WHEN Campaign Metrics = "Clicks - CTR" AND Campaign Metrics = "Engagement Rate" THEN(… I believe I created a case statement for each possible 'combo', but I am doubting myself as I type this. I am going to try to recreate every combo in a new beast calc,…
  • I am using it to display one percentage value in a 'Filled Guage' chart. It works fine as a dropdown, but not as a checkbox @MichelleH Thanks, by the way!
  • Beast Mode —> `CASE WHEN Campaign Metrics = 'Clicks - CTR' THEN( (SUM(CASE WHEN Post Date IS NOT NULL THEN 1 ELSE 0 END) SUM(CASE WHEN a IS NOT NULL THEN 1 ELSE 0 END) SUM(CASE WHEN b IS NOT NULL THEN 1 ELSE 0 END) SUM(CASE WHEN Total c IS NOT NULL THEN 1 ELSE 0 END) SUM(CASE WHEN CONCAT( d ,' ', e) !='string' AND CONCAT(…
  • @jaeW_at_Onyx Thanks for the input. This is a special case due to incomplete/inaccurate data. In short, the number of conversions, clicks, etc does not always get inputted, so we have nulls or zeros, which the people doing the data entry seem to think is interchangeable. As a result, we have a few metrics like Views:…
  • @GrantSmith @jaeW_at_Onyx I figured it out!! Thank you SO MUCH for your help. The issue was that Domo was utilizing a count of users that included rows where user views were NULL and rows where user views were 0. It worked correctly once I created this calculation: CASE when `Total Views` IS NOT NULL AND `Total Views` > 0…
  • @GrantSmith Hi Grant Smith, I am genuinely perplexed. This is very similar (if not identical) to a beast mode I previously tried. The good news is it doesn't return a blank. The bad news, it is still giving incorrect averages. I QA'd against a few different groups, exporting the domo table result to Excel, making sure to…
  • @jaeW_at_Onyx Certainly. I assume you mean in an Excel doc? The sample dataset includes the mydesiredCalcfield, which is not in the original dataset. This column is the beast mode I create in domo, which is a simple division --> SUM(`Total Views`) / SUM(`Total Conversions`). I need to find the average of Group A's…
  • @jaeW_at_Onyx Total is not an average, it's a simple calculation/division (views/conversions -- 29,993,987.5/16,529 = 1,814.63). My dataset is made up of different groups. I want the average for that group. Each row has a ColA/ColB (views/conversions). However, I want the average of all rows. Ex: Here, I need the average…
  • @jaeW_at_Onyx With regards to converting the denominator, I incorrectly thought I was converting NULL to 0, but I understand now I was converting 0 to NULL. I'll fix that. As I mentioned above, when I use avg(total_a/total_b), it returns a blank I may need to explain myself more. The row above is an 'aggregate' of a group.…
  • @jaeW_at_Onyx With regards to the first issue, I incorrectly thought I was converting NULL to 0. I understand now that I am converting 0 to NULL. I've fixed that. It sounds like you're telling me to use --> avg( total_a / total_b ) However, that does not return any value in my 'aggregate' row. The 'aggregate' row is the…
  • @GrantSmith The conversion rate is NULL when there aren't any conversions for that row. Right now, I am not getting any average, so I cannot tell you whether it's higher or lower than the excel value. The average from AVG(Total Views / Total Conversions) returns blank in domo. The 'average' from SUM(Total Views) /…
  • Wow, what a quick response @GrantSmith ! I would like an average of the entire dataset. When I try AVG(Total Views / Total Conversions): It does not provide any result (stays blank) for the overall group/dataset. If I add each user to the table, then it provides the 'average' for that row, which is the same as the total.…