jaeW_at_Onyx Coach

Domo will frequently take it's "best guess" on the data type as you import it. unless you're importing it with Workbench I don't believe you can explicitly set the data type. what you can do in MySQL or Magic 2.0 is use an LPAD() function to Left Pad the data. https://www.w3schools.com/mysql/func_mysql_lpad.asp

in magic etl add a constant, 1, called temp add a rank and window tile. rownumber order by temp no partition. in a dataset view rownumber() over ()

@walker_page Domo support would be the best person to direct that question to as they do have access to error logs. that said, it looks like you're pushing 9.3M rows of data with each push. Is that a full replace or an APPEND? if it's a replace, can you adopt an incremental load strategy?…

@estelle531 you would need to build the universe of template rows at the granularity you want to be able to filter / pivot your data on. in this video I describe it as "building the universe" of options https://youtu.be/Xb4QgKYgaqg?t=168

@estelle531 , @MarkSnodgrass is correct, you can fill NULLs with 0 ; however, that only works if there is a row in the dataset for Type B on that date (or whatever the rest of your criteria are). Domo cannot generate data for an axis if the data doesn't exist. If Type B doesn't exist in your data, there's nothing to fill.…

@Salmas how do you expect this to behave? Look at the inside WHEN MAX(`Day`) = DAY(MAX(`Day`))-1 THEN... that can NEVER be the same ... because MAX(DAY) can NEVER equal MAX(DAY) -1 . Try putting your data into EXCEL and figure out how you'd construct the answer... You could use a Period over Period Chart For greater…

side note... rewrite your metric CASE WHEN `Metric` = 'C' THEN sum(sum(`Value`)) over(partition by YEAR(`Date`), `Metric` order by `Date`) ELSE 0 END Avoid putting aggregations inside of a CASE statement. usually leads to heartache. Given that it looks like you only want your aggregation to work IF the metric type is C.…

Hey @JustinB Did a little tutorial for you on YouTube. If you're in the Domo-dojo instance, here's a link to the Dataflow https://domo-dojo.domo.com/datacenter/dataflows/53/graph Link to DataCrew post https://datacrew.circle.so/c/articles-and-knowledge-base/tutorial-buildaverageofanaverage

If i had to guess, when Domo previews your data (it scans the first N-thousand rows) it determined your data type to be type Number. When it got to N-thousand +1 row it came across the text 'nan' which obviously is not a number. hence why it failed. Can you reupload your data? If you have Magic 2.0 you can explicitly tell…

@MarkSnodgrass is correct. Formula tile with: CASE WHEN `Req status`='Open' AND (`Offer to be Extended`<>'' OR `Offer Extended` <>'') THEN '1 - G' WHEN `Req status`='Open' AND (`HM applicant review`= 'Is null' AND `Days open`>10) then '2 - R1' WHEN `Req status`='Open' AND (`Interview`= '' AND `Days open`>15) THEN '3- R2'…

@artywah it takes time for the information to get to the correct team. Consider emailing your CSM the issue, make sure to include the ticket number, they may be able to go direct to the connectors team. I recently wrote an article in the DataCrew community that might help you understand your range of options if you can't…

Yes, Domo is using MySQL v5.6 to process MySQL dataflows. Good job with Magic! Regex data cleansing will be much faster than any SQL implementation.

@ravimohan911 i would also recommend checking in with your CSM. UPSERT is a feature switch that has to be enabled. Depending on the age of your instance, it may or may not automatically be enabled.

open a support ticket. create a new card with a different dataset?

@grimmers have you tried explicitly sharing those cards with yourself? I wonder if sharing / security is creating a minor hiccup.

Bug? try picking a different chart type and come back to it. I show an input option for "Series"

This is MySQL v 5.6 which didn't include many of the regex functions. if you're trying to do regex replace, consider this article. https://datacrew.circle.so/c/articles-and-knowledge-base/removing-non-alphanumeric-characters-from-strings-in-domo

If you just open the ETL if there's an obvious error, the tile will be red. It is unlikely that the dataflow failed b/c the datset is too large unless the dataflow takes 24 hours to run (in which case Domo will force kill it).

@AnwarBham please don't throw my consultancy's name around. You do not have several contractors who have agreed with anything. Thanks.

@gespindola , @GrantSmith 's idea is solid. only thing to be sure of is that there actually are start and end dates. if one column isn't populated it could cause a row to drop. consider adding a default start or end date if null.

@loganherzog , thinking it through, is there a strong reason to set up 4 new jobs for one store? could you not just append more data to an existing dataset?

No. Beast Modes do not support modification with javascript.

Whoop this is amazing @DuncanDomo

Gij try to get-schema of the dataset and see if the schema includes the beastMode and also if the column actually has a different alias. I don't know the answer, but that's where i'd start.

Use a CASE statement. CASE when <dayOfWeek> = 'Monday' then 1 else 0 end. You could alternatively do crazy math where you do the Number of days in a month %% 7 and then do math on the remainder to figure out if the remainder would include another Monday.

Domo by default does just in time user creation when someone logs in in an SSO or similar environment. if you want to make someone pre-emptively, you could use Bulk Add Users provided you have the right email (i believe) https://knowledge.domo.com/Administer/Managing_Users_and_Groups/01Adding_Users_to_Domo

Andy Beyer talked about a ton of different ways to start pulling data into Domo. https://www.youtube.com/watch?v=lF4VG8lmEVM&list=PLUy_qbtzH0S6-5oDbx3BsIv2Xk-JxJxWi&index=9 you should definitely consider the No Code connectors. But tried and true options like emailed reports or SFTP are pretty solid too. also if you have…

Pretty much any tile that allows you to add columns one at a time should have an add all columns button. Seems weird to have it in inconsistent places.

@RobynLinden , just wondering, how would you see this behaving if there were MANY unique values? or if i had two or three quick filters?

@Sweep_The_Leg For 32M rows (especially with Magic 2.0 I would expect this to take in the ballpark of 10 to 20 minutes. If you set it up with a Dataset View it should be virtually instantaneous.