GrantSmith Coach

@Jean_McDonald Yes, the Domo Dimensions Calendar Dataset has dates through 2030 in it so you can view future dates.

Domo doesn't have a way to display a vertical line as you're wanting. You could utilize a beast mode to check to see if it's today, if it is return the value. CASE WHEN `dt` = CURDATE() THEN `random_number` END You can utilize a symbol line to display your values and then have Today being displayed on top of it like this:…

Currently this isn't an option. You're not able to dynamically set the column labels like you're wanting to do. Have you looked into utilizing data labels and tool tips in your visualizations?

Here's a link to an existing Idea Exchange post to create something like a block tile which may be similar: https://community-forums.domo.com/main/discussion/60079/block-tiles-in-magic-etl-to-simplify-complex-dataflows

https://www.domo.com/blog/improving-supply-chain-logistics-with-geographic-proximity-matching/ @MichelleH has written up a great article on the community blog you can reference on how she did geospatial distance calculations using a Redshift dataflow.

You can't aggregate your data three times. Try taking out the SUM(`Loads`) in favor of just `Loads`. Same thing for the carrier pay field. Also another alternative to DATE_FORMAT(CURRENT_DATE(), '%Y') is just YEAR(CURRENT_DATE())

You could configure a beast mode to return the opposite and then do a NOT IN CASE WHEN Target Go-Live Date` IS NULL THEN 'Blank' ELSE 'Not-Blank' END Alternatively if you're wanting to do that exact value then set the Blank value for when it's populated. Do your filtering then change your beast mode back.

It appears you're using the Last_Production_Date as the date field in your date picker but you're filtering in your ETL based on Order_Completion_Date. Do these end up being the same data or are they different? If they're different you can try and drag the Order_Completion_Date field into your analyzer to force the date…

It's attempting to connect to the database but running into connection issues. Are you able to get a response from the server that's hosting the data source? Are you behind a firewall that would restrict access?

Do you have some sample data to see what your dataset looks like?

When you're evaluating this beast mode it's going record by record so one part of your equation will always be null, you'd need to calculate the max BatchTimestamp date. Are you keying based off a specific identifier field in your chart? Something along the lines of may work depending on how you're displaying your data:…

Create a beast mode which returns YEAR(`CreatedOn`) to return the year and save it to the dataset. Alternatively you can calculate this within a dataflow. Then use this new field in your slicer filter to allow users to filter for a specific year.

Perhaps it may be an issue. I'd recommend reaching out to Domo Support to engage them as they own the connector code.

Domo has released a Domo Brick "Searchable Filter App (Multiple Columns)" which may be helpful for your user case. I'd recommend searching for it in your app store.

Are you using a date field in the graph? Does your data have different date values or are they all the same date? Can you post a redacted screenshot of your analyzer with the date picker expanded?

There's a 30 second timeout for adrenaline dataflows. You'll need to either improve your query performance by rewriting it or attempt to process less data so that the execution time is less than the 30 seconds.

Have you tried using the limit and offset parameters in your GET request to extract the data from Domo paginated? https://developer.domo.com/portal/8s3y9eldnjq8d-data-api#limit--offset

Not with the out of the box HTML table. You can leverage a Domo Brick and some javascript to perhaps display the pie chart within the graph itself.

It's a permissions based issue. You need to make sure the user is part of the Windows group "Domo Workbench Users" on the actual windows machine where workbench is hosted.

@jgRugby_123098 Since your invoice number field is a string you need to use strings in your IN clause. You can do this by putting them in single quotes SELECT * FROM CHARGE_DETAIL WHERE INVOICE_NUMBER IN ('217653436', '217668183', '819802440', '820092602')

Currently no but I'd recommend adding this to the Idea Exchange

because you’re filtering on price differences and valid and invalid it’s filtering out all downstream data which is why you get what you’re seeing. If you’re wanting to filter on the top level then you’d need to calculate the top level value and included that on all you records so you can filter on that value instead

Seems like an error with your id and secret. Can you create a new pair and try with those?

When you created your Client ID and Secret at developer.domo.com did you select any of the boxes to define the roles?

Have you created a Client ID and Client Secret from developer.domo.com and are you passing those value into your Domo constructor?

Hi @pauljames Are your campaigns going across iOS and non-iOS devices? Facebook recently changed how their aggregate inline-conversion metrics are done across both platforms. Essentially conversions are missing if going across platforms. https://developers.facebook.com/docs/marketing-api/insights/parameters/v18.0 From…

That's an odd error. You'd need to contact Support to have them help diagnose the issue.

CASE WHEN SUM(revenue) > 1000 AND SUM(CASE WHEN (`date` - DAYOFMONTH(`date`) + 1) = STR_TO_DATE(CONCAT(YEAR(NOW())-1,'-',MONTH(NOW()),'-01', '%Y-%m-%d') THEN `revenue` END) WHEN . . . END You can try something like this to check if date is equal to 12 months ago and has 100 or more in revenue and the overall revenue is…

Due to how Marketo returns the Program information it doesn't return the tags and you'd need a specific ID or Name to get the tags associated with that program. This currently isn't available in Domo's connector. To get all the program tags you'd need to likely write your own script to query all of the programs then call…

Google typically has a really good Python packages which help to connect to their APIs. Has your dev team looked into using https://github.com/googleads/googleads-python-lib? You could pair it with pydomo to upload the data into Domo.