jaeW_at_Onyx Coach

Use PyDomo https://github.com/domoinc/domo-python-sdk https://www.youtube.com/watch?v=oT5NipvWK1o

Angela, Store your budget in a Webform or Google Sheets (two columns, amount and region name) then append (UNION) that data to your transactions. This way when the Budget amount needs to change you can just alter a webform. Very easy. 2) I want to see the total $ amount spent and % of usage MTD for each region inside the…

if you have different marketing sources blended into the same column then you need sum( case when marekting_source = 'value' then `amount` end ) i would recommend that you not calculate YOY or MOM as separate columns in your dataset. it makes it difficult to apply filters. instead just use either window functions in…

my favorite feature include code blocks. type three tildas, `, and then you get a nice code block. CASE WHEN ... Code goes here also you can just paste in images like screenshots using Copy / Paste or embed videos via URL links https://www.youtube.com/watch?v=eKOLhsfl10Q&t=3s

@user048760 glad you got there in the end! can you pls mark this ticket as closed / answered closed?

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