GrantSmith Coach

Do you have any filters in place? Will the data show up without that beast mode?

Hi @rishi_patel301 Have you looked into the DataSet Copy connector to copy your datasets and set the update method to Append? https://domohelp.domo.com/hc/en-us/articles/360043436533-DataSet-Copy-DataSet-Connector You can copy the dataset to the same instance and set the update method to append so you'd remove the append…

You can use a Beast Mode to calculate if it's complete or not and then return a string value for it: Name: Documentation Completed CASE WHEN SUM(`Numerator: Score`) / SUM(`Denominator: Score`) < 1 THEN 'No' ELSE 'Yes' END

Hi @Hiraayub You can set your column format to be a percentage to multiply the number by 100. Click on the Column and select Format then choose Percentage.

@pstrand2 Do you have a screen shot to help me better understand your issue or your desired end state? Are you saying the total number of working days should be 21 or 210? It shouldn't be adding all of the working days together but it's adding the daily calls per working day (fractions) and adding those up.

Hi @pstrand2 Could you just add the fractions together? SUM(CASE WHEN `Activity` = 'Call' THEN 1 ELSE 0 END / `Total Working Days in Month`)

Hi @jorgy There isn't really a way you can dynamically calculate the rank and then graph by the week because of how Domo interprets aggregations. You may need to pre-aggregate your data using an ETL but you won't be able to filter at this level dynamically based on your card filters.

@Shuhei Try this: { "dimensionFilterClauses": [ { "operator": "AND", "filters": [ { "dimensionName": "ga: dimensionA", "operator": "EXACT", "expressions": ["X"] }, { "dimensionName": "ga: dimensionB", "operator": "EXACT", "expressions": ["Y"] } ] } ] }…

@Shuhei Try this: { "dimensionFilterClauses": [ { "operator": "AND", "filters": [ { "dimensionName": "ga: dimensionA", "operator": "EXACT", "expressions": ["X"] }, { "dimensionName": "ga: dimensionB", "operator": "EXACT", "expressions": ["Y"] } ] } ] }…

Hi @user095063 You need to join your two tables together since you have one table for all your revenue and another for your HDM revenue. Try something like this: select `a`.`Date`, SUM(`b`.`HDM Revenue`) / SUM(`a`.`All Revenue`) FROM `a` LEFT JOIN `b` ON `a`.`Date` = `b`.`Date` GROUP BY `a`.`Date`

Hi @Ashwin_SG Have you looked into using a recursive dataflow? You can also utilize a date tile or a formula tile to insert the current date and time when the dataflow ran. Here's a link to creating recursive dataflows using Magic ETL 2.0:…

@Tow Have you changed the ownership of the DataFlow generating your dataflow dataset to Dev1? What about any input datasets for that dataflow? Have you made Dev1 the owner of those? Another option would be to make Dev2 a co-owner assuming you want both dev1 and dev2 to be able to edit your cards and dataflows?

dt was the date field I was using. You’ll need to tweak the ETL to replace dt with your hire date field and term_dt with your termination date field.

Hi @at326 I'd recommend reaching out to Domo Support as they'd likely have more information on this error and would be better able to help diagnose your problem.

Here's some code you can copy and paste into a Magic ETL 2.0 which I think highlights Mark's solution: {"contentType":"domo/dataflow-actions","data":[{"name":"Sample…

Dang @MarkSnodgrass I thought I was faster than you! His solution is the better one since you're wanting to calculate the difference and don't always want 0 displayed for your null values. You will need to come up with a cross product to determine all possible year + client + state combinations, left join your original…

Hi @MattLynn It's because there's no data for Domo to evaluate in your pivot table to even apply a coalesce on. What you can do is under the General Properties of your pivot table you can check the "Fill Empty Data Cells With 0" option to tell Domo to display 0 instead of blanks in your pivot table.

One option is to utilize the lag window functions to calculate the difference between the current year and last year. The caveat to this is you can't have missing years between each salesperson and state (going from 2019 -> 2021 missing 2020 for example) A pivot table would end up looking something like this which isn't…

@amehdad Your beast mode won't work correctly as count(0) is still 1. You'd need to drop your else clause if you're using count (how many non-null values are there?) COUNT( CASE WHEN status = 'A' AND 'Hire Date' <= DATE_FORMAT(CURRENT_DATE(),'%d/%m/%Y') AND 'Termination Date' IS NULL THEN 'ID Number' END) @Abhijith Here's…

Hi @Adrien You can use partitions in your window function: SUM(`TOS`) / SUM(SUM(`TOS`)) OVER (PARTITION BY `Sales Leader`, `Month`)

You wouldn't need the /4 and your total shipped should be surrounded in a parenthesis. (LAG(SUM(`OT Shipped`)) OVER (PARTITION BY `Customer` ORDER BY WEEK(`Date`,2)) +LAG(SUM(`OT Shipped`),2) OVER (PARTITION BY `Customer` ORDER BY WEEK(`Date`,2))+LAG(SUM(`OT Shipped`),3) OVER (PARTITION BY `Customer` ORDER BY…

This methods assumes you have no missing weeks. If you miss a week it will cause your calculations to be incorrect. Are you attempting to calculate the rolling average across all your customers or within each customer? Also with your SUM function the way you're calculating it now is an average of the average which isn't…

Hi @Ashleigh Are you wanting to the City DC to show up or have data for DC to show up? Showing the city name can be done with the Cities > Show Cities option and turning it on. If you're wanting to show the data you can make sure you're using the ZIP to FIPS connector (or the Domo Dimension connector with the…

Hi @Derreck You can just add a day to the date: DATE_ADD(DATE_SUB(`dt`, INTERVAL (DAYOFWEEK(`dt`) - 1) DAY), INTERVAL 1 DAY) End of the week: DATE_ADD(`dt`, INTERVAL (7- DAYOFWEEK(`dt`) + 1) DAY)

@Madz_A I'd also recommend logging an idea in the idea exchange to allow the removal of the dotted line on the notebook cards.

Hi @Ainash I've tried using the Google Sheets method but it's hard to know if / when the data is finished importing into google sheets to then have Domo pick up the correct data. I ended up utilizing the pydomo SDK and the Google Ads python SDK to query Google Ads, process my data and then upload it into Domo via their API…

@jaeW_at_Onyx I believe the issue is that the Glue process happens on AWS's end so the CLI wouldn't be able to kick it off and know when that job has finished.

Looks like I need to wake up earlier get my answers in before @amehdad :) I agree with @amehdad but wanted to add some clarification - The MagicETL or MySQL recursive dataflows will allow you to filter possible duplicate records however the larger your dataset becomes the slower / less performant it becomes because there's…

Hi @Tow Typically when I have a more complex scheduling pipeline like this with data outside of Domo I’ll use a Python script to kick off each of the jobs serially in a single script so I know it’ll run each step in order.

Hi @Hiraayub You can utilize a beast mode LAG and LEAD functions to determine if it's in a 3+ day run. LAG 1 and LEAD 1 = Day with one before and after LAG 2 = Day with two before LEAD2 = Day with two after CASE WHEN (LAG(MAX(`Date`)) OVER (ORDER BY `Date`) = `Date` - INTERVAL '1' DAY AND LEAD(MAX(`Date`)) OVER (ORDER BY…