Best Of
Re: Period over Period Visual, YTD, 2 Day Delay with Current Date Data
Create a beast mode like this might work for you to exclude the prior year entries are excluded if they are from the 2 days that aren't yet in the current year data.
CASE WHEN DAYOFYEAR(yourdatefield) > DAYOFYEAR(DATE_SUB(CURRENT_DATE(), INTERVAL 2 day)) THEN 'Exclude'
ELSE 'Include'
END
You would drag this beast mode into your filter and filter to Include.
Re: Is it possible to define a color rule for data point 1 based on its value relative to data point 2?
@bjavery87 How I have done this in the past is almost identical to the suggestion from ArborRose, but here is more detail. I created two beast modes.
beast mode 1:case when value>=(target value) then value else 0 end
beast mode 2: case when value<(target value) then value else 0 end
use a line stacked bar chart. set color of beast mode 1 to red, beast mode 2 to blue. The chart will stack the red and blue but you will only see one or the other because the result of one beast mode should always be 0.
Re: Is it possible to define a color rule for data point 1 based on its value relative to data point 2?
I would look into creating a custom column {formula} with the condition you need. The resulting column can then be used as the color condition. Thus, the new column would show when it dips below or rises above, and the color settings would react to that.
Re: using Regex with email connector
@NathanDorsch Try this: .*RMP.*
For future reference is a great resource to test whether your Regex works as expected
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:



