GrantSmith Coach

@RichYute You can use the Open Exchange Connector to automatically pull the conversion rates so you won't have to make any manual changes. You can join your currency rates dataset with your dataset amount and then use the formula tile to multiple the Eruos by the conversion rate. It'll look something like this: I'm adding…

@Emma Try this: CASE WHEN `Plant`=1302 AND `Line of Business`='Cable' THEN 'QC Fibre' END

Hi @RichYute You can use a formula tile to multiple your Euros by your conversion rate to get USD. I'd recommend having a lookup table with your conversion rates in it so it's easier to update where you can join your currency and filter to what you're converting to. I'm not certain there's a specific Domo Connector which…

@User_32265 If you're simply wanting to do a translation stating they're authenticated you can use a Beast Mode on a card or a Formula Tile in a new Magic ETL dataflow to define a new column. I'm not certain what you logic would be to determine if they're "Pre-Authenticated" but assuming the user ID is populated means…

That’s it.

If you’re technical you could export your data from Domo and build your own excel spreadsheet using pydomo and a Python script. R might also be an option.

You'll need to talk with your CSM to get Window Functions turned on as it's a feature switch they need to do.

@DANIH Do you have some sample anonymized data I could play with?

I'd recommend reaching out to your CSM/Support in this case as this is a Domo architecture question at this point and they'd potentially have a better answer for you.

@nshively I'm not certain what all information you need displayed on your card but you could utilize the LAG window function assuming you don't have any missing months: Average Head Count (Beast Mode) ( SUM(SUM(`EmployeeCount`)) OVER (PARTITION BY `EOMDate`) + LAG(SUM(`EmployeeCount`), 1) OVER (ORDER BY `EOMDate`)) / 2

Unless you know each of those events are for the same user you won’t be able to tie different sessions together because each visitor to your website will get a new session ID if they haven’t visited your site within 30 minutes or whatever you have your Google analytics configured to. I am not certain if you can use googles…

I'd recommend using a custom date dimension with offsets so you can easily have this month and last month together based on your current month. I've done a more detailed writeup on it here: A more flexible way to do Period over Period comparisons You may need to tweak it if your data is on a monthly cadence instead of…

Hi @DANIH Have you tried a window function with a case statement since you're attempting to only look at data from today? Last Year: SUM(SUM(CASE WHEN DATE(`Timestamp`) = CURRENT_DATE - INTERVAL '1' YEAR THEN `Net Sales` END)) OVER (PARTITION BY HOUR(`Timestamp`)) Last Year (With day of week aligned) SUM(SUM(CASE WHEN…

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