jaeW_at_Onyx Coach

@MarkSnodgrass and @RocketMichael the risk with LAG() is that if you have a gap in your data (i.e. sales on 6 out of 7 days) that would throw off LAG because LAG 7 would actually be the 8th day back. instead you might consider trying to use Variables (beta feature maybe GA check with your CSM) to address the problem.…

@MichelleH -- yeah ... so they were devised as parity for a Tableau feature (level of detail expressions). which ... ironically if you read THAT documentation it helps Domo make a little more sense. I guess Domo is issuing multiple SQL queries instead of just one query (a'la the Segments feature). which is objectively very…

sorry i assumed you were using federated on-premise agent. this guy? https://domohelp.domo.com/hc/en-us/articles/360049429094 I really don't know the answer but I would try setting up a new connection JIC an invisible update deployed a new set of connection config params.

+1 with @MarkSnodgrass , except it's important to keep in mind that even the webhook connector executes (and therefore ingests data) in batches. despite it collects data from a webhook pipeline, it must follow the same rules constraints of any other connector in Domo's arsenal (i.e. you do have to execute it in Domo and…

blind guessing here, but looks like the datasource id got blanked out. it's unclear to me if that means the of the dataset in Adrenaline or the config information for your dataset on premise, but if it were me i'd open up the federated agent configuration tool and see if there was something going on. can you spin up…

@travorhouse is it possible for Domo to ingest data and store it in Domo in (almost) real time? ... theoretically yes. Domo does have IOT use cases but they are still updating Domo in batches (increasingly smaller batches but still not true streaming). It just costs money. and Domo's pricing for low latency pipelines…

@RocketMichael ( (CASE when `Period Type`='Current' then `Shipped CoGS`end) - (CASE when `Period Type`= 'Last Month' then `Shipped CoGS` end) ) / (CASE when `Period Type`='Last Month' then `Shipped CoGS`end) you are calculating your beast mode at the row level. in other words, take one row in isolation and then apply your…

@charles , typically we'll see users have Current Month and Previous Month as column titles. you could still adopt @MichelleH 's suggestion if you limit your dataset via filters to the "last x months" then you can still display months in your columns, and the data filter restricts you to the correct set of months.

I wish i knew who to AT Domo @justin-millheim ?? I believe when you render a card you can set the zoom size right? @pstrauss I would say that if your card exceeds a page it is probably less of a chart and more likely a table card. if that's the case, just export the data to excel where you have all the control over…

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…