GrantSmith Coach

In order to track the weekly stats you'd need to either use a dataflow to add in the timestamp and schedule it to run once a week and have it append on the output or alternatively use a dataset copy connector and set it to append to automatically copy the original dataset with the _BATCH_LAST_RUN_ timestamp field. As for…

You need to wrap your entire case statement in SUM instead of having your condition be the sum. It's evaluating each row at a time and then aggregating when you want to aggregate after evaluating all the rows. SUM(CASE WHEN … … THEN `INVOICE_AMT` END )

You’d need to explode your data so that you have a record for each month. You can do this with magicETL and filter where day = 1 to only get the first of each month. Then using a formula tile on your data you’d need to calculate the first of the month with something like `Subscriotion Start Date` - INTERVAL…

You'd need a ROUND function to reduce the amount of decimal places. Once you're adding in the HTML coding the data becomes a string and you're unable to utilize Domo's built-in formatting options so you need to format your number yourself. If you want to format it as a currency you can do something like this post:

Domo isn't really designed to be an ODS but more a reporting data store. Typically connectors will run at a minimum of 15-minute intervals but some have longer intervals between runs. At best you might be able to get a 15 minute latency.

You can't do this within Vanilla Domo itself however Domo Embed does allow for you to switch datasets with Dataset Switching. You can read more on it here:

Hi @NathanDorsch Typically when I'm doing PoP analysis I'll use a custom date dimension to add more flexibility for what I want to do. I'd recommend reading this article that I've written up in the past on how to get this configured and used.

You should be able to get the page URL to get a more exact match from GA4 / UA.

This is just a warning message when attempting to do something that won't be supported in later versions of the pandas package that Domo is utilizing. You can ignore this warning for now assuming your dataset is being written properly. Domo will need to update their domo package to properly fix this warning in their future…

What does your data structure look like? Do you have separate columns for bought and sold based on each day or do you have one row for each sold and purchased along with the date? Do you have a starting inventory number?

Congrats @trafalger !

You’re limited to 3 tooltips however you can create new beast modes and combine several fields together with a CONCAT and then use that beast mode as a tooltip.

Likely what's happening is that one of your B2, B3 or B4 calculations is returning a NULL which will make your entire calculation NULL when using +, -, * or / operations thus not returning any data to your chart. You can try and wrap each in a COALESCE(formula, 0) call to make sure you're not adding NULLs together.…

You can't do a dynamic pivot with Magic ETL however you can leverage prepared statements and SQL in a MySQL dataflow to do dynamic pivoting. You can follow the SQL with something like

Cards aren't considered "viewed" by the DomoStats unless the detail view is looked at. When looking at a card on a page it doesn't count that as a card view. As @MichelleH mentioned you can utilize the Domo Governance or Domo Stats connectors for pull the last viewed information for pages and join each card on that page…

The activity log doesn't capture if someone plays the video, only if they look at the doc card details as a view. I think this would be beneficial to know and I'd recommend logging a new Idea in the Idea Exchange.

@ademahad If you pass in the existing dataset ID it will update that dataset, otherwise if it's not included or None is passed in it'll create a new dataset.

Technically you could use the view as an input into a Magic ETL dataflow and just directly output the dataset to materialize it and then use that output dataset in your adrenaline data flow.

Thanks for sharing @DHo. That is another way to get the first of the month. Either one will work, I think it’s just a matter of preference. Yours is probably more clear than how I wrote mine. I was in a more arithmetic mindset when I wrote my version. Appreciate the input!

Contains should function similarly to SQL LIKE command. What is the syntax you’re using? Are you URL encoding your pfilter value?

You'd likely need to create a custom app or Domo Brick and leverage JavaScript to create a wrapping table as you're requesting. You can get more information on custom apps at developer.domo.com

This isn't a part of the current Facebook Ads connector. It should be part of the Ads Action stats GraphQL endpoint ( As Domo owns this connector you'll need to reach out to them to get the connector updated.

This isn't a part of the current Facebook Ads connector. It should be part of the Ads Action stats GraphQL endpoint ( As Domo owns this connector you'll need to reach out to them to get the connector updated.

You can try and use a beast mode with a fixed function and filter on that beast mode: CASE WHEN `dt` = MAX(MAX(`dt`)) FIXED () THEN 'Latest' ELSE 'Not' END This example uses a dt date field but you can then put this into the filter and filter for "Latest"

You can calculate the beginning day of the week using a beast mode: `date` - INTERVAL (DAYOFWEEK(`date`)-1) DAY Alternatively though I recommend using a date dimension table with custom offsets to make this easier so you can see how many you have from the prior week and calculate week over week differences. I've written on…

@TC1199A Have you tried looking into doing a dataset alert on your dataset where you're calculating the days?

Are you experiencing a syntax error or a logical error where you're not getting the results you're expecting?

In the properties under Hover Legend you can check the box to hide the legend to remove the totals on the right hand side. Unhidden: Hidden:

It's attempting to connect to Clarizen. Have you confirmed your Clarizen username and password are correct and you can log in with them?

Domo is having an Innovation Summit about its AI offerings at the end of this month on the 29th or 31st. It may be beneficial to attend to see what they offer: