GrantSmith Coach

It’s a GA issue / limitation. Nothing you can do about it at this time.

@user027926 I'm getting an error message stating they can't be queried together: Domo is ready, but Domo received an error requesting the data. (Bad/Malformed Request). Selected dimensions and metrics cannot be queried together. Which is odd because the dimension explorer states they should be able to be queried together.…

@WorldWarHulk It looks like you're using the DomoStats connector and not the Domo Governance connector. If you follow the like I posted above and change [INSTANCE] to your instance name then it should take you to the correct connector you can use to then be able to pull the beast modes

Can you post a screen shot of your connector and which report you have selected?

Hi @user007345 You'll want to reformat your data to be in the format of: Date | Product | Count Put the Date field on your x-axis, product as your series and Count as your y-axis. You should be able to use the Unpivot or Dynamic Unpivot on a new magic etl dataflow to restructure your data.…

Hi @enricopirazzini Currently you can't set a refresh interval for your cards as they automatically update when the underlying dataset is updated. You could set your datasets as inputs into a dataflow which runs every 15 minutes (or another interval) and just have them write to separate outputs. Then use those output…

Hi @eriena You can use the DataSet via Email Connector (KB Article: https://domohelp.domo.com/hc/en-us/articles/360042931954-DataSet-via-Email-Connector). You can either search for DataSet via Email in the connector search or you can go to: https://[INSTANCE].domo.com/appstore/connectors/com.domo.connector.emailer Replace…

@user027926 How much data are you attempting to pull? Do you happen to have GA360 or just basic GA (there's a lower limit on the amount of data you can pull)? Have you also tried using a custom report to pull in your data? Audience Affinity Category Age Gender In-Market Segment Other Category Ecommerce Section:…

https://domohelp.domo.com/hc/en-us/articles/360056318074-Domo-Governance-Datasets-Connector is the KB article about it. It should be just the Domo Governance Connector. It was called the Domo Governance Thirdy Party Connector at one point.…

I used the Domo Governance Third Part Connector to pull the Beast Modes report and then utilized a filter, groupby and another filter in magic ETL 2.0 to determine if there were any that occurred more than once. You can click anywhere in your ETL canvas and then use CMD+V or CTRL+V to past in the code I used below to…

Glad you got it working, make sure to accept his answer so it's easier for others to find the solution in the future.

Mark wants his points for accepted answers... oh wait, I do too! 😁

In that case regular expressions and a formula tile are your friend. Put the following code into a formula tile in the New Magic ETL to strip out anything after the colon if the text after the colon contains a GUID: (replace text with your field) REGEXP_REPLACE(`text`, '^([^:]+): [^…

Hi @cjsmith718 It appears you're wanting the first part of the text before your colon. If that's the case you can use a Split Column tile in a magic ETL dataflow to get the first part of your string before the colon.

You'd group by the new timestamp field and SUM / aggregate your Sales column

Alternatively you can truncate a timestamp to a part of the timestamp like hour with the TRUNC function: TRUNC(`dt`, 'HOUR')

Hi @DANIH You can use a formula tile to calculate the hour by converting your timestamp to a date (defaults to a time of 00:00:00) and then adding the number of hours in the timestamp. DATE(`dt`) + INTERVAL HOUR(`dt`) HOUR

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.