Best Of
Re: Unknown Domo Governance datasets run error
This is an issue with the connector itself as it's expecting that property in the JSON to be returned by the API call but it doesn't exist. You'll need to reach out to Domo Support to have them look into the connector.
Re: How do we use the AWS assume role functionality with the upload-s3 Domo CLI command?
To use the AWS Role and AWS Profile that you have set up to connect to an S3 bucket when using the upload-s3 Domo CLI command, you can follow these steps:
- Ensure that the AWS CLI is installed on your machine.
- Configure the AWS CLI by running the command
aws configure --profile <your-profile-name>. This will prompt you to enter your AWS Access Key ID, Secret Access Key, Default region name, and Default output format. Make sure to enter the Access Key ID and Secret Access Key for the AWS Role that you want to assume. - In the Domo CLI command, use the
--aws-profileflag to specify the name of the AWS Profile that you configured in step 2. For example:domo upload-s3 --aws-profile <your-profile-name> <your-file-path> s3://<your-bucket-name>/<your-object-key>
When you use the --aws-profile flag, the Domo CLI will use the credentials stored in the AWS Profile to assume the AWS Role that you have set up, rather than passing a static Access Key ID and Secret Access Key in the command line.
Let me know if this helps.
LWalker
Re: Is there a way to map more than 2 lat/long points for a route?
@ActivelyLearning123 I don't believe there is a chart type that allows for multiple points, but I've been able to accomplish something similar by structuring my data so that each row represents a "leg" of the route and using a route name as the series for coloring. Here is an example of how to structure the data:
Re: Anna Yardley -- Community Manager at Domo
Good to meet you Anna… looking forward to what the community forum can do.
Re: Anna Yardley -- Community Manager at Domo
Hi Anna, one day we'll have to get a Domo Euchre game going!
Re: How can I identify all the users who have looked at/viewed a DOMO card in the last year?
Thank you very much.
charles
Re: How do I count Not null values in beast mode
COUNT function will count the number of non null records
if you’re wanting to compare to not NULL then it’s the same as SQL
CASE WHEN `Name` IS NOT NULL THEN 'Not Null' ELSE 'Null' END
Re: Showing some values based on SUM, other values based on the most recent date available for the week?
@Stemiller Do you have a field in your dataset that flags the most recent date or would the most recent date always be today/yesterday/etc.? If so you could aggregate your snapshot data in a beast mode like this:
max(case whenDate= CURRENT_DATE() thenInventory on Handend)
or
max(case whenLast Date Flag= 1 thenInventory on Handend)
Re: Documentation needed for using Parameters in SQL Server Connector
The documentation is a bit buried but this may be of help to you to explain how the lastvalue parameters work in Workbench: