jaeW_at_Onyx Coach

Imagine you had C-Suite , VP, Director | 19 | Enterprise, Supply Chain You'd need to duplicate the row a total of 6 times. take the first column and duplicate each row by the number of Commas +1 (because that's how many respondents there are In this example ,you'd want to duplicate that row 3 times. then use split-part()…

i'm not sure if i understand what you're trying to accomplish. it sounds like you're trying to create a sum across rows. that's easy with a formula or beast mode (col1+col2+col3+col4). if you want to use the past n rows, you might look at using the LAG() function in the RANK and WINDOW tile. it's a google-able operation…

You could look at customizing user experience with different arrays of feature switches in multiple instances of Domo. if domo ever gets an instance switching feature kind of like Buzz on Desktop, it could create a seamless experience for having different views with different feature switches. either way this sounds like a…

@Mychele you want ... everyone to be able to edit the beast mode? or you just want them to see the definition? b/c you can accomplish "seeing the calculation" with domo_governance + BeastModes report. if you were building a card, that could be accomplished with pfilters.

+100 It'd be a great sanity test to know, "no you're not crazy", especially when Domo makes silent product updates that have unexpected impact on other areas of the platform.

it's not in product yet, but you can do this with scripting. https://www.youtube.com/watch?v=v-8HYp6b4KU

i hear what you're saying, but tagging a dataset is the same number of clicks as moving something into a different folder... in many ways tagging structures are more powerful than folders because a dataset could be attributed to multiple tags (whereas a dataset couldn't live in multiple folders). why not just use Tags +…

build a fiscal calendar where for each day you assign the week the date belongs to. if you can imagine, every company would have a slightly different take on what the week number should be, so having an artifact in a table 1) guarantees that you can see it 2) creates a column you can filter any dataset with.

if you wanted to just export the transform steps you can do that VIA API. since just knowing the transform steps can be obtuse, typically we'll recommend users generate documentation in lucid chart or similar to document the dataflow. why would you give such an intimate view of the ETL without also giving edit rights?

you could build a table card from domo_governance_pages report that accumulates history and captures last_updated_date over time. So if a card didn't previously exist or was updated since the last report run, you could build in logic for a flag and how it gets displayed / alerted in the card. but yes... it's a shame that…

@louiswatson you could have significantly simplified your ETL by using a FORMULA tile with a CASE statement. The reason why this approach is cleaner is the CASE statement allows you to use an ELSE clause. When you split out your data using FILTER tiles as you have, if you miss a new filter value you exclude it from your…

@Jose_Rojas yes, you would need to work with your AE to get the Jupyter Notebook addon. If it was me, i would be VERY explicit and adamant that you do NOT need the Data Science Package. IMHO with the improvements in the Jupyter Data Science Notebook there is no reason to use the Scripting tiles. But also i think you're…

@utkarsh please articulate in business language what you are trying to accomplish. @MichelleH is correct, you can probably accomplish what you need using Window functions (the LAG() function) in particular, but to assess whether it would always be appropriate to use LAG it's important to understand your use case.

build a date dimension where you have one row for each day of the year. then assign the week_of_year to each date. then it'll be easier to make these comparisons. "build a date dimension" in SQL is a google-able term, so you should be able to implement that using MySQL dataflows.

@julia_wang it would be helpful to know what columns you have on the axis of your pivot table. (post a screen shot). also please post the beast mode you've written and include data structure... makes it easier to guess where you're going wrong.

@AdamC Domo predominately uses MySQL syntax.

if this is a bug, probably should open a support ticket. if it's a product feedback, make sure to put it under the IDEAS exchange board. if you leave it here i am concerned you won't get a response.

@chapman just write a CASE statement. SUM(SUM(case when company = 'abc' then `totalSales` end ) FIXED (FILTER DENY company))

Maybe an "include / exclude current_date" option.

consider using window functions to get the desired result. if you UNION your data (Consumption UNION to Inventory with a column activity_type = "consumption" or "inventory" so you can tell them apart) as @MarkSnodgrass recommended and structure your data such that you have Activity_Date and Activity_YearMonth, you could…

@mHejl if it were me i would unpivot the data (Magic ETL) to collapse the values in columns 2, 3, and 4 into one column then do a windowed MIN function with the Rank and Window tile. If you don't want to restructure your data, you could see if Magic or Beast Modes have an implementation of the LEAST() function…

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