jaeW_at_Onyx Coach

@user060355 , it sounds simple, but i'm not sure i follow your data structure. can you upload a sample? what happens when you break your beast mode into separate parts (i.e. which part is breaking? the numerator or the denominator?)

@user003349 , if you're looking for information about a dataflow use the domo goverance_dataflow dataset. to get lineage, you'd have to pull a dataflow information, extract the output dataset id and then find the next dataflow that uses that dataset as an input.

@CR-eSobylak , can you upload a sample dataset? I don't think I've experienced that and I use Magic flows daily.

+1 on @GrantSmith, use Magic 2.0 it'll be much easier and faster over large datasets. But if you're hell bent on it, you can use variables. SELECT col, day @running_total:=@running_total + amount as running_total FROM table t, (SELECT @running_total:=0) r ORDER BY t.day;

@user047019 , to be able to select your currency from a filter, you'd have to structure your data so that you have one row per transaction PER CURRENCY TYPE. Then you can just add a filter for "currency type" In other words, instead of having Amount_dollar, Amount_Yet, Amout_Euro, you'd just have one column, Amount, and…

@user04646 , maybe it'd help if you upload a sample of the data or a few screenshots.

@user048760 , FYI Beast modes are case sensitive, so check that you have case correct. SUM(CASE WHEN `lead_source` = 'Walk_In' AND `unit_rented_c` = 1 THEN 1 END) / SUM(CASE WHEN `lead_source` = 'Walk_In' THEN 1 END) also tilda, `, is used to differentiate columns whereas single ticks, ' , are used to differentiate…

When using Window Functions anything that's part of the ORDER BY or PARTITION BY clause must be included on an axis (or SORT BY) clause in analyzer. uh... this looks a bit janky to my eyes and certainly you have to be careful how you use this CASE statement. case when MAX(MAX(`Year`)) OVER () = `Year` then sum(`Gross…

If you care about layout, long term it makes sense to implement using the Dashboard / Stories layout feature. You'll have advantages like being able to LOCK a page so that people cannot alter the layout. If you want alternate views of the page users can create a copy of the dashboard and reorganize it to their content, but…

... oof are you trying to figure out on which day of the week people tend to visit your site? if yes, then you should definitely bake day of week into your dataset via ETL, different implementations of dayofweek will shift Monday from 1 to 0, and that's not the sort of thing you want to guess about. meanwhile, it's…

Salina, without writing code / hacking workbench, there isn't really an easy way to change which dataset in Domo your workbench job updates. Unfortunately, the easiest thing to do may be to remap your ETLs to the new workbench dataset.

If i'm understanding you correctly you want the week on the axis and then the day of the max total. this is tough / not reallllllllly possible the way you want to without doing ETL (i don't think). what you can do is SORT by RANK() -- such that the top ranked days of each week appear first, then the second best day of each…

Lol .... federated makes everything harder. but that's fine. build your date_dimension dataset in your database, and federate your JOIN'ed date + transaction table. then you can do it all in simple beast modes. you can't count distinct with the LAG() function method. I explained why in my first response. "if you need COUNT…

next time just copy paste your SQL ... it's hard to help troubleshoot b/c first thing i want to do is reformat your code and remove parenthesis, but i'm not gonna type it out. I would recommend taking each section of code and putting it in it's own beast mode and see where it breaks. be careful with your ELSE 0. you are…

Instead of doing your multiplication, *1.25 AFTER aggregation do it before aggregation. avg_5_adj score = sum(actual score * 1.25) // this returns adjusted score on a scale of 1 to 5. / sum( 5) // this returns the maximum number of points per survey taken. Don't use a CASE statement at all for filtering your values ...…

The two different methods are use LAG() in windowed functions (previously linked tutorial) OR this one https://www.youtube.com/watch?v=CDKNOmKClms instead of current year / previous year, you'd build offsets for 90 day buckets. -- Also, it would be ideal if this could be dynamic with variables. if you watch the videos,…

ummm... it might be important to define what you want more specifically... Auto ML can only take you so far right? THink about what it would take if you had to do this by hand ... what would it look like? Let's break your problem down into plain Enlgish. Let's say we were looking at brands of makeup and i want to know, if…

High level there are two ways of approaching this. 1) for each period on your X axis (month), you want to force your dataset to include ALL THE DATA of interest (i.e. the last 90 days) for that period. (so Rpt_Month Oct, would include Activity from Oct, Sept, Aug) that way your beast mode is nice and simple CASE WHEN…

... there's nothing wrong with Window Functions AFAIK. It's either enabled or it's not. From there users usually havea problem in their code. I've covered tons of window functions on my YouTube channel, https://www.youtube.com/watch?v=eifSYZIcPzg

ooof that's not as easy as it sounds... IF you know you can always trim the first n characters you and the last n characters, you could use LEFT(), RIGHT(), and SUBSTRING or INSTRING() to just keep the middle, https://dojo.domo.com/t5/Dataflows/Fun-with-string-functions/td-p/32507 If the length of the tags you want to…

@GuitarMan2020So much going on here ... but the root of your problem / question is unclear because mathematically speaking, mean and average are the same thing... https://www.mathsisfun.com/mean.html#:~:text=The%20mean%20is%20the%20average,sum%20divided%20by%20the%20count. Your boss is correct. generally you don't want to…

@pl_Luke Domo are working on a beta feature that will give you this idea of a 'baseline group' that is unaffected by a specific (set of) filters. In your case the Reason Code. this feature is in beta and I'm completely unsure when it's going to release for GA or how stable the implementation is, but definitely check in…

@MarkSnodgrass is correct. if you check version you're on MySQL 5.6 doesn't support window functions. Magic 2.0 is amazing, get it enabled (talk to your CSM) if you don't already. It will be more performant. That said, If it were me, 1) I'd convert Year and quarter into a date type column (probably the last day of the…

When data gets loaded into Domo it's assumed data is being sent in UTC. Then when Domo displays the data to you, it is translated into the timezone of your "Company Settings." so if the your company was in EST the data should be 'automatically converted'. places where people fall over is in not transmitting the data in UTC…

You don't have to specify where the email is coming from, as long as you send an email to a specific inbox, by default it will get added to that dataset. specifying email addresses to accept data from is a security feature to limit the risk of spam. but you could define "email must have a specific subject" instead of…

Use a dataflow to convert your text column into a date column. In Magic 2.0 you can convert date types using the INPUT tile, or you can use the equivalent in STRING_TO_DATE using date tiles. This extra effort will allow you to use date functions in Beast Modes.

? can you be more specific about the error? Window Functions require feature enablement, contact your CSM and ask them for "Window functions in Beast Modes"

There's a bunch going on here ... 1) why are you building a CASE statement that returns text when your ELSE clause will return a number? 2) if I had to guess you have Date on the axis hence why you're seeing repeated dates. swap it with the math in your order by clause, DATE_FORMAT(`last_activity_at`,'%Y-%m-%d') 3) if you…

you could use the domo_governance dataset or the DomoStats_DataflowHistory (i believe) dataset to see how long it's taking dataflows to execute, but they would have to be updated periodically ... usually Domo prefers the governance datasets to only update daily. are you running this ETL multiple times a day? you could…

https://pypi.org/project/pydomo/ https://developer.domo.com/docs/dataset-api-reference/dataset @imelendez you have a couple options. 1) use pydomo + request commands in a python library to develop a script that executes periodically (controlled locally on a VM or your desktop) that then pushes the data into domo via Domo's…