jaeW_at_Onyx Coach

@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.

@AnwarBham i think the important thing to keep in mind is that you're not working in a SQL environment. so while it helps to understand how sql works and know where the overlaps are, it's not a 1:1 match. can you update a dataset in ETL without creating a new dataset. yes. add a filter that's always false. should you do…

@AnwarBham you probably shouldn't delete intermediate tables and dataflows. It'll be impossible to reconstruct your pipeline without rebuilding the dataflows all over again. 1) you could refactor and consolidate your intermediate steps 2) do nothing. if row limits are not a problem, it doesn't really matter. bigger…

or a window function in data set views.

If you're using this to adjust for closing activities in a financial use case, you should just create a table of months and when the month was closed and work that into your data. Just blanket filtering to exclude the current month is ... a solution that may lead to heartache down t he road.

@DuncanDomo kindly recreated his solution here: https://domo-dojo.domo.com/datacenter/dataflows/44/author

@ChristianW , a Bullet Chart would work but there's also a Bar and Line chart type too.

Both @MarkSnodgrass and @Giacomo are correct, you cannot nest Count Unique inside a Window Function. ... well.... you can, but the answer will be 1. What's your use case? What question are you trying to answer?

Domo HTML Charts will display content that's been encoded with HTML tags. Mega Charts support some HTML encoding. I believe Pivot Tables support the least amount of HTML encoding.

@msharma , @rahul93 is partially correct, if you put a '' in your ELSE clause you will convert your beastmode into a string. It therefore wouldn't format or behave like a number after that point. probably not desireable. To get 'nothing' as Rahul is recommending, you can however use ELSE NULL sum(case when…