shaanarora Member

Unfortunately you'll need to get that value in a dataflow to populate one of those design studio apps.

There used to be a setting in SFDC imports where you could Replace or Append new data. Looks like that has been removed. Here's a link to an article on how to do so in an ETL: http://knowledge.domo.com?cid=recursiveetl You could also use the UNION command in MySQL.

So I do have a county + zip code + lat/lon spreadsheet (attached). You should be able to do a join on county names. Unfortunately it will only a show one point per row instead of filling the whole county with a color though. Since the midwest has way fewer counties/cities, it's much more sparse than the coasts. Here's an…

Your best bet is to use the Last... date grain filter and set it to Last 2 Years. That will include all of last year and this year up to the current date.

No problem! How are the territories set up? By state?

This may not work unless you have a way to translate their regions into latitute/longitude, but those maps have more than 18 colors. Here's a quick example image I made using latitute and longitude.

The easiest way would probably be to temporarily replace that conditional field with the same calculation without the HTML added, export, and then change the column back to the formatted one.

@DomoBeaver Can you provide a sample of the column you're trying to convert to a number? Is it possible that there are nulls in it?

Your best bet is probably just to add a Beast Mode column that includes only those two dates. Example: CASE WHEN DATEDIFF(CURRENT_DATE(),`Date Field`) = 0 OR DATEDIFF(CURRENT_DATE(),`Date Field`) = 7 THEN 'Include' ELSE 'Exclude' END Then filter that field to 'Include' rows.

Yes that is probably the issue. You can try this but I have not verified that it will work. SUM(REPLACE(`number_column`,',','')) This replaces all commas with an empty string, which essentially removes all commas. The SUM function should then be able to parse your column as a number instead of a string.

If there are definitely no non-number values in the column, then using SUM(`Column Name`) should convert all the rows in that column to numbers.

Thanks for the update @ilikenno and @kshah008. The issue I'm seeing here is that the current or most recent month will always say account closed. I forgot to update earlier but I used the LAG function in Redshift to accomplish what I needed. It may not be applicable in this situation but might be worth checking out…

Was anyone able to find a solution to this problem? Running into the same thing right now.

For anyone interested - I had to create a new beast mode that collected the data I want by month. Not ideal, because I can now only view by month and would need to create a new beast mode if I wanted to view by week, year, etc.