Best Of
Re: Count that accomodates NULL
@PJG You will need to add IFNULL around every value in your beast mode to force nulls to zero like this: IFNULL(Value1,0) + IFNULL(Value2,0) + …
Re: Filtering a card
Filtering on multiple keywords can be tricky. You can set a column on the dataset to match the condition(s) you require. Or create a filter formula:
CASE
WHEN `column_name` LIKE '%keyword1%' OR
`column_name` LIKE '%keyword2%' OR
`column_name` LIKE '%keyword3%' THEN 1
ELSE 0
END
Re: Search results to show unique values
not all of your data is being pulled into the card due to the size of your dataset so it’s not finding your exact match. In analyzer under the filter section you can put in a number larger than 50000 to pull in all of your data. Alternatively if your ids are not unique you could aggregate your data in the card to get a smaller list is ids
Re: Date Filter to Omit Last 45 Days
You can use a beast mode to denote if the date is within the last 45 days and if so ignore it in the filter
CASE WHEN `date` > CURDATE() - INTERVAL 45 DAY THEN 'EXCLUDE' ELSE 'INCLUDE' END
then use that beast mode as a filler and only include the INCLUDE value
Re: Triggering "full screen" through URL
Hey @UncleLeoTheDad,
I'd recommend posting this in the Ideas Exchange. It is a great way to possibly get your ideas implemented into Domo.
Re: Target line
So my recommendation would be to use the built in Fiscal Year feature offered by Domo. You can set this up by emailing your CSM and Domo Support. See the below linked support article that details the information you will need to supply.
Alternatively, you could also use a date dimension dataset joined up to your base dataset in an ETL. This date dimension dataset would define the FY months.
If you set up the FY feature, you can use the built in date grain functionality offered by Domo.
If you are set on using a beast mode, you could accomplish it using something like this. Remember to either set your aggregation of FY goal as an average, or split the total into monthly amounts if you are evaluating by month and want to sum.
CASE
when MONTH(date) in (4,5,6,7,8,9,10,11,12) then CONCAT('FY ',YEAR(date))
when MONTH(date) in (1,2,3) then CONCAT('FY ',YEAR(date)-1)
end
Re: Target line
@Patricia_Zavisky - here is how you would need to set this up to achieve 2 distinct lines.
You would need to define a series for each FY goal. You could do this in either your base dataset, an ETL, or in a Beast Mode. Example below.
Example output.
Alternatively, you could make use of a bullet chart to avoid having to map the FY series.
With both of these options you can adjust the date grain to show by month, quarter, year, etc. If you choose to show by year, make sure you have your FY settings enabled with Domo to choose the "Fiscal Year" option.
Re: Multiple line chart and data labels
I think you can do this by creating a beast mode that outputs only for the line you want, and outputs a blank string ('') for all the other lines in the series. You can drop the beast mode into the tooltip slot, and then choose the tooltip as your label in data label settings. This worked for me when I tested it on a chart with two lines.
Re: Group By Tile to JOIN Tile Produces Unexpected Result. Using an Output Tile as an Input Fixes It
Previews operate on a limited number of rows from their inputs, by default just 10k rows:
This can cause Group By aggregates to look incomplete, Joins to miss when they should hit, and Filters to produce zero rows when they should produce some.
rco
Re: Stop DOMO SSO user creation
Under Admin > Authentication > SSO there's an advanced section where you can check "Only invited people can access Domo". This will prevent new users from being created and require you to manually add them to the instance.