GrantSmith Coach

It appears to be an issue with the connector itself not sending the API token properly. You'll need to log a ticket with Domo support to have them look into it. You could attempt to leverage the JSON No Code connector and configure it yourself.

Yes, Admins can go under More > Admin > Dashboards, select the dashboard and then click the wrench and select Move to move the dashboard to another location or make it a subpage of another dashboard.

You've got a few potential options Use the JSON No Code connector if the API data you're using is straightforward Write your own Domo Connector Utilize the pydomo Python package and write your own python script to pull, process and upload the data into Domo.

You can look into using a FIXED function to get the overall total. CASE WHEN SUM(COUNT(DISTINCT `ID`) FIXED ()) > 10 THEN 1 ELSE 0 END

Typically when I'm doing period over period analysis I'll restructure my data to make things like this easier. I've outlined how to do this here:

You can simplify your beast mode. If either of your fields are NULL then the entire subtraction will be NULL. (UNIX_TIMESTAMP(`Hospital Ready Time (UTC)`) - UNIX_TIMESTAMP(`Video Start Time (UTC)`)) / 60

You can do this in the Chart Properties under Grid Lines:

You'd need to log a ticket with Domo Support as this sounds like a backend issue with the permissions on the view.

Using magic ETL, take the date dimension dataset (Domo Dimensions connector) and feed it into a Add Constant tile to create a new field called "join column" with a value of 1. Do the same for your input dataset. Feed both of those into the join based on the join column. Then you feed that into a filter field with your…

Alternatively I’d look into unpivoting your data so it’s structured with a year column and the actual year value for each row then you don’t need the massive case statement to update every year and it’d be a simple CONCAT function with the year column and your virtual in person column

you only need the first CASE statement all the others should just be WHEN and only a single else at the end and one END at the very end

Something like this should work for you: CASE WHEN `2015`=1 THEN CONCAT('2015-', `Virtual vs In-Person`) ELSE '' END

Are you wanting to make sure a single filter has been selected or all of the applicable filters have been selected? If you have more than one filter that you want to make sure has a single value selected you can add additional beast modes in your filter to count the distinct values in each of those fields.

Have a distinct count beast mode on your card and filter where that is one. Then set the no data message to be “Select a single value”

use a group by tile to combine your field with commas as your aggregation

Currently this isn't an option with the HTML table, I'd recommend adding this as an idea to the idea exchange.

You can do this with a Magic ETL Group By tile to combine the values with a comma separator.

You can use a formula tile and a case statement to set the value: CASE WHEN REPLACE(`City`, '.', '') ILIKE '%st george%' THEN 'St. George' ELSE `City` END You can have multiple different WHEN clauses to handle other scenarios. ILIKE is the case-insensitive version of LIKE where you're matching based on a string with the %…

You can’t get access to the current page URL within a beast mode so there isn’t an easy way to dynamically pull it

You can write your own connector in Python with the pydomo package to upload data into your Domo instance which gives you more control over how the data is processed but will be a much more technical route. You’ll need to work directly with the Comscore APIs

It's treating your 'Repeat' clause in your logical expression as TRUE as it's not 0 value. You need to compare the value again to your field: CASE WHEN `PRODUCTSTATUS` = 'R' OR `PRODUCTSTATUS` = 'Repeat' THEN 'Repeat' ELSE 'New' END

The Domo App is used in conjunction with the NetSuite App TBA Connector to utilize saved searches to get your data out of NetSuite.

Ad Hoc groups don't have an owner. It's more a kin to an open group where others can add users to the group. You can edit the group type and convert it to either Open, Dynamic or Closed from Ad Hoc but can't change it back.

A very unsupported method would be to create a dataflow where you have your input and output with the transformations you want to clean up the data. This will write out to a new dataset as you suggested but this is good for validation purposes. If the output dataset now meets your criteria you can hack the JSON powering…

This is a limitation with the Xero API that Domo is utilizing. You need to reach out to Domo Support to have their development team address this.

Your format string isn't quite correct. You need something like DATE_FORMAT(`Month of the year`, '%Y%m%d') One concern though is that the months are set to a specific year - is this intended or will other years have the same month?

You can use a case statement in a beast mode to conditionally bucket your values CASE WHEN `Compsny` IN ('A','B','C') THEN 'B2B' WHEN `Compsny` IN ('D','E','F') THEN 'B2C' END

Domo doesn't have a direct connector for those however you could attempt to utilize the JSON No Code type connector to see if you can get the data that way. Alternatively you can write your own custom connector:

Agree with @MarkSnodgrass, FILTER NONE option on a FIXED function will allow you to filter your original data but keep the entire dataset as part of the calculation.

Currently the Histogram graph doesn't support this. You could attempt to define your own categories/buckets within a beast mode and use that as your x-axis on a standard bar chart and another beast mode to calculate the overall percentage.