ST_Superman Domo Employee

I think that you would need to create a beastmode calcualtion for each time frame you wanted to compare. For example, to compare 2012 to 2010: (SUM(`2012 population`)-SUM(`2010 population`)) / SUM(`2010 population`) You would then want to format the chart to display as a percent.

You can accomplish this in several places from the card analyzer: From the Total Row Properties Under the Subtotal/Total field options

1. Year to Date and Current Year will be the same results if your data set does not have any future dates in it. If you have data points from July and August, etc. and you select "Current Year" they will show up in the results. If you select "Year to Date" they will not be in the results. 2. Moving Annual Total - We…

Do you have any null values in your data? You might want to try: (Case when ifnull(`Amount`,0) >= -1.49 AND ifnull(`Amount`,0) <= 1.49 THEN 0 ELSE `Amount` END )

you can add .svg files from the admin section now:

What kind of card are you using? Would you mind sending a screenshot of the analyzer for the card?

You could always add a row to the data flow that would contain the release date (and maybe any other key milestones prior to release)

yes

Sportrader but I believe you need to pay for a subscription to access their data.

Are you getting 0 results in the preview? ETL does strange things with large data sets when you are trying to preview. I would reccomend making an output dataset and clicking on save/run. Let me know if your output data set still doesn't show any results.

Here is an option to get this done in MySQL. This will take several transforms. This will allow up to 30 selling seasons. If you need more, you can add more to the first select statement. 1.) SELECT `Style #`, @num_seasons := 1 + LENGTH(`Selling Seasons`) - LENGTH(REPLACE(`Selling Seasons`, ' ,', ' ')) AS num_seasons,…

I would suggest venturing down the MySQL or Redshift dataflow options then. ETL is a great tool for quick dataflows, but it can get pretty intense the more you try to do with it.

I have run into similar issues as this, although I have not tried to build a cohort. I'm referring to requests to recreate a specific report in Domo. I would tackle this by first asking what information the user wants to get from this data? What business question is being asked and how do you measure success? While Domo…

Have you tried using CONVERT_TZ as part of a dataflow rather than in a beastmode? I don't think that funciton is available in beast mode.

As long as the field for the x-axis is a Date format, you should be able to add date annotations to your card.

I guess that I would first want to investigate if there were any way to automate that process. If you want visibility of the derlivery status in Domo, then you will need to get that information to Domo as part of a new data source (either an uploaded spreadsheet or new connection). Domo does not have an out of the box way…

This depends on how you are getting your data on the delivery confirmation. Do you have this dataset in Domo already? If so then it is a simple join to connect the two datasets. How are you tracking the delivery of products?

Another reason that you may be getting zeros is that you are using an aggregate function Count(). This means that you need to use group by at the end of your select statement or the MySQL dataflow will simply look at the first row of data that it encounters EDIT **sorry, just read the code from your original post and it…

This was a bit of a learning experience for me, so thank you for asking the question. There is a REGEX() expression in MySQL, but that does not appear to be available in the version that DOMO is using. However, if you are willing to change your data flow to a redshift data flow you can accomplish something like this:…

I have one more question: What output would you expect to see in this scenario: Date Value 5/20 2.2 5/21 2.1 5/22 2.2 5/23 2.3 5/24 2.7 5/25 2.0 My assumption would be a null value? When there is no growth after the minimum value in a timeperiod, do you want an output of zero or null?

CONCAT('<div style="line-height:1.5">', '<div style="font-size: 12px"><b>Month: ', Monthname(max(`Post Month`)))

Try using the Scale Marker Property with the Stacked bar graph instead of a line for the Budget Limit

Try creating a new summary number: CONCAT(MAX(MONTH(`Post Month`)))

You mean that you only want to see the Post Month? CONCAT('<div style="line-height:1.5">', '<div style="font-size: 12px"><b>Month: ', Monthname(`Post Month`)) Should do it. If you are looking for something else, please elaborate or provide an example of what you are looking for.

If you are always looking at the top performer over a static time frame (last 365 days, previous quarter, previous year, etc.) then I would recommend creating a rank column in a data flow. Your summary number could then be: concat(case when `rank`=1 then `Name` end, ': Top Sales over the Last 12 Months') This would get a…

Can you share a bit of your data set? Would like to play with different chart types, etc. to see if I can find a way to do this. Also, is the Budget Limit calculated? Or is it a static number?

Here is a knowledge article that will run you through this process in much greater detail then I'll be able to do here. Let me know if you have questions after reading and I'll try to fill in any gaps. http://knowledge.domo.com?cid=recursivesql

When using DATE_FORMAT, the result is not a value, but a string. You need to use single quotes and they need to be two characters long. Something like this: sum(case when DATE_FORMAT(`Date of Invoice`,'%d')='01' and DATE_FORMAT(`Date of Invoice`,'%m')='02' then `Sales at constant Exchange Rate` end)

You can create a "Date Annotation" on the card:

try using the back tick ` `ConvertedOpportunity.Name`