jaeW_at_Onyx Coach

@user02790, Super important. Can you please update your username handle so it's easier to AT_Mention you? it helps guarantee you get timely notifications... and also helps respondents get an idea of who we're talking to! This will start by sounding snide but lead to a solution that i've implemented at companies with multi…

@user048760 could you update your profile handle so it's easier to AT mention you? can you give us a sample of your data. it sounds like it should be pretty straight forward. split numerator and denominator into separate beast modes and pop it into a table card. if your denominator is zero then you know hwat the problem is…

@User_32489 , hey, Just FYI with Dojo's new system it's much more difficult to AT_mention people so they get notified. If you change your profile name it makes sure you get repsonses quickly. Anyway, this looks like a bug (which you should raise to support@domo.com) But, have you confirmed that if you apply filters there's…

+1 @GrantSmith except it sounds like you need to add a partition. @Bwaalsh, sum(Sales) / sum(sum(sales)) over (partition by colors) I actually just posted a video involving window functions (https://www.youtube.com/watch?v=Esnu1PSxRjM&t=35s)

@Mark 100% agree. Also, @Anna Yardley , I made this video with a list of bullets I always try to check. One of the Resources referenced in the video: https://www.darkhorseanalytics.com/blog/salvaging-the-pie // legtit one of my favorite resources for visualization design.

oof @Brandon i don't know the answer. that would be a great question for support, and if you were thinking of going the custom role route, ask them, they probably get this question all the time (b/c custom roles is a popular topic with customers).

@Brandon , I think i'd frame it a different way. What behavior are you trying to control? If i had to guess, you're trying to prevent people from accessing data outside of Domo. that's a bit tricky because because theoretically if i can read data in domo there's no reason i shouldn't be able to read data outside of domo.…

@Sandis , can you relink the image?

@user047019 , it's a common design pattern in Domo for features like this. CROSS apply is relatively easy in Magic to do a CROSS APPLY just add a fixed constant of 1 on the left and right side of the dataset and JOIN on 1 = 1 https://youtu.be/Xb4QgKYgaqg?t=295

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