Best Of

Re: Can we save / export the projection data as a dataset in Domo Analyzer Cards?

Sounds like a great feature if I could make it work. I selected the options but the button's don't appear. Was thinking though that when you have the card full screen, do you still have the table option under the wrench, maybe the projection values are visible there?

Jessica

1

Can we save / export the projection data as a dataset in Domo Analyzer Cards?

We have created a Domo Analyzer Card using "Multi-Period Projection" from the chart properties. It uses Linear Regression Recent Weighted and shows the projection in the UI. We need a dataset where all these projected datapoints will be saved. Any idea how to create this dataset or export it from the card?

arnabm

1

Re: Help with beast mode formula - "case when" with date ranges

Hi @cbreen, a couple edits to your formula:

When you have multiple conditions you need to check, you can simply contain them with a single CASE...END. Instead of repeating "CASE", you can specify each new condition with WHEN
You are correct that your current formula does not account for September. You can add this as an additional condition

Try something like this:

case 
when month(`date_purchased`) = 8 and DAYOFMONTH(`date_purchased`) >= 11 then 1
when month(`date_purchased`) = 9  then 1
when month(`date_purchased`) = 10 and DAYOFMONTH(`date_purchased`) <= 10 then 1
else 0 
end

MichelleH

3

Re: How can I count occurrences grouped by a given field?

Ok I think I understand. You want the count of the IDs on each line of the ID.

For that you can utilize a window function

 SUM(SUM(1)) OVER (PARTITION BY `ID#`)

GrantSmith

1

Re: Ability to Set Default Value for Filter Chart Types

I really need this feature, please! :)

Gionniz

1

Re: Correlation analysis in Domo?

Hi @svetlana ,

Yes! Very possible. ETLs actually have a hidden section called Data Science where you can do a bunch of analysis like forecasting, clustering, etc. If you don't have it, you may need to talk to your AE about it.

I think it's an upcharge, but if you're using the Consumption Model for billing it should be included

John Le

You're only one dashboard away.

More video solutions at: https://www.dashboarddudes.com/pantry

DashboardDude

1

Re: Automatic Record Matching - Customers

@kpmwinston Unfortunately, since the Customer Name or Customer Address aren't exactly the same, you won't be able to join them together. In Magic ETL, you could use some formulas to modify names and addresses so they match, but I'd imagine you'd have a lot of records to change so it wouldn't be feasible.

RobSomers

1

Re: CONCAT function not working, any reasons?

Hi @Tommy ,

Is this still an issue? If so, can you share a screenshot of what the concat formula looks like and the error?

John Le

You're only one dashboard away.

More video solutions at: https://www.dashboarddudes.com/pantry

DashboardDude

1