jaeW_at_Onyx Coach

i'm not sure ... i think a better practice would be to manage and share content with a group and then just be good about assigning admins to groups. for my projects, I actually like it that I can't see ALL the dashboards when I sign into an instance just b/c I'm an Admin. instead I have a group for each project and just…

so like the Lineage diagram? would you want this to be a dataset? on paper I can see wanting to know dataflow_execution (domo stats) was triggered by "schedule" or "manual" but I think that already exists.

@IvanSavii can you drop a screenshot of what you're referring to? i know in the checkbox filters there's an unselect / select all option. is that what you mean?

yeah that's frustrating. but probably an issue best left to Support as they can actually access the error logs.

only addendum I'd add to @MichelleH 's post would be to not filter out rows. just add your row_number for nth-most-recent visit. in one card you can filter on "nth-most-recent-visit = 1" and on the other card just filter by patient.

https://domohelp.domo.com/hc/en-us/articles/360043428253-Managing-Pages

@zcameron here's a recent compelling use of FIXED!

sorry GA = "general availability". as in "not a beta feature". just check in w/ your CSM.

@jkami talk to your CSM about the Variables beta, that would be the easiest path forward for this problem and if you have Partitions in ETL then it seems like that shouldn't be a big ask. If your data goes back super far, you can filter your data using Dataset Views before pulling them in ETL, so if you know you only need…

sorry for showing up late to the party. the problem isn't that you can't aggregate a window function as @GrantSmith suggests. I believe the issue is that you're trying to perform math on an aggregation and an unaggregated value (column11) in your example. you SHOULD be able to write lag(sum(col_11), 1) over( order by date…

blank post for the points :P sorry can't delete it.

@zcameron "This is one of those times that I wish Domo's documentation kept up with Domo's updates. There is no SPLIT_PART() function listed in the beastmode function list" @MarkSnodgrass and @ST_-Superman-_ while Domo does try to maintain parity between what we can do in formula tiles and what we can do in Beast Modes,…

@gbrown i like @RobSomers approach, but might extend it. it sounds like you work on each item multiple times in a day, year, month. so i might create a counter that tracks "this is the n'th time" somoene worked on this part. ideally i'd have an order_id, but in the absence of that i'd just ask if there's a new person…

@Jones01 i know i'm coming late to the party, but the long and short of it is, you can't use any date_part functions (year, month week) etc with a fiscal calendar, because as you've figured out, there is no way for the YEAR() function to know the span of your year. if you wanted to be able to do FY_Year and FY_Month…

@jkami you would want to take a look at the Variables beta (or is it GA? who knows??) The Variables feature would allow you to pass a value "num_rolling_days" into your beast mode. Case when `Invoice Date` >= SUBDATE(CURRENT_DATE(),interval num_rolling_days day) then 'Rolling Days' End until that time comes, you do have to…

@n____l____ i urge you to reconsider this model. if you build a dataset with an indeterminate number of columns (it would be based on the contents of the data collected that day) then you can't really build cards off of it. right, today you might have item_a, tomorrow you might not. so then your card in analyzer breaks.…

@Canioagain , if you build the date the data was collected into the dataset, maybe you can use a smart text, https://domohelp.domo.com/hc/en-us/articles/4529227357975-Using-Smart-Text i would strongly urge you to avoid trying to use today() in your card title because IF there was a hiccup in your pipeline and the data…

@Tclark07 it seems like connector usage would be an attribute of DomoStats which Domo Engineering should have access to for all customers right? I know we wish everyone would log in to Dojo, but we know that's not the case. Hopefully Domo Support could partner with CSMs to push an email to the Major Domos of each impacted…

@JunkDoom given that you are describing ingesting Transactions into Domo, I would strongly recommend you investigate using Partitions instead of UPSERT. UPSERT works well when you're uploading a massive Customer, Product (or similar) table where you have no idea when a particular Customer_ID or SKU might be updated.…

@zcameron this might be something for your team? @James_Dougherty Domo has ... a handful of quiet releases and sometimes doesn't update the documentation to reflect updated language in the product. I think it's important to consider how Beast Modes can be created / duplicated (and then test and you'll figure it out!) 1) a…

@ricsanders and @Jose_Rojas Domo does not really have the concept of stored procedures or functions available for execution in Magic dataflows. You can create stored procedures in MySql dataflows but i strongly recommend you avoid them because MySQL (v5.6) is significantly more effort to optimize and maintain if you're…

thanks for the shoutout @mhouston Strong agree to the UNION approach instead of JOIN. @utkarsh it looks like your dataset 2 needs some sort of date column. if each month everyone has the same budget, then duplicate the rows of Input 2 once for each month and add the end_of_month_date column as @GrantSmith describes before…

@swagner why didn't you @ mention me? sorry so late to the party! sum(sum(1)) over ( partition by branch, item order by receipt date desc) shoudl work i believe.

Product Feedback / IDEA added here -- https://dojo.domo.com/main/discussion/55706/join-on-like-and-between-in-magic-2-0/p1?new=1

Product Feedback / IDEA added here -- https://dojo.domo.com/main/discussion/55706/join-on-like-and-between-in-magic-2-0/p1?new=1

@jmmc @GrantSmith is spot on with his advice with one small addendum. If you can perform your JOIN in a Dataset View (which is basically Fusions 2.0 so ... ignore fusions) then, assuming your VIEW can return a result within 1 minute (processing requirement imposed on VIEWS / Adrenaline) then you should see significant…

In DP22 Domo released the ability to schedule Jupyter Notebooks just like any other dataflow. Definitely worth checking out! https://domohelp.domo.com/hc/en-us/articles/360047400753-Jupyter-Workspaces#4.4.

UPDATE -- @user09644 this feature was released at DP22. It's now possible (and frankly IMHO there's no reason to use Python or R tiles in Magic Dataflows anymore! https://domohelp.domo.com/hc/en-us/articles/360047400753-Jupyter-Workspaces#4.4.

@Jmoreno I'm going to create product feedback for this here: https://dojo.domo.com/main/discussion/55701/domo-certification-progress-and-community-engagement-datasets/p1?new=1 feel freet o upvote. I know my org needs it.

@JunkDoom have a close look at Partitioning. Many Domo connectors are starting to support partition schemes based on Date. If your data is not partitioned by Date you can use the CLI to create your own partition tags as you upload data. the in-Domo ETL version of "Partitioning" can be recreated with Recursive Dataflows.…