Comments
-
@SameerSarnad , i don't know for sure, but i suspect Domo would not refresh the federated dataset unless someone asked for the data. so i i'm guessing you just need to interact with a card or dashboard in order to validate that the data is updated.
-
@Ellibot has a video on this topic with texted messages.
-
@akeating you can materialize a view. work with your CSM + product, there's feature switches that can probably make that happen. it would be intriguing to know if adrenaline dataflows supports etl with federated datasets. might be a question worth asking.
-
@damen beast modes are built using functions with MySQL syntax. so basically any question you have you can just google the search phrase + sql and you should get there.
-
rank() OVER (PARTITION BY `Plant Department` ORDER BY sum( `AMOUNT TOTAL` ) DESC ) if you don't order by sum of amount total, you'll only have the largest sale event.
-
+1 @trafalger window function max() would be good except the window doesn't have an unlimited end of window. so group by would be the best.
-
use COALESCE() function
-
https://domohelp.domo.com/hc/en-us/articles/4408174643607-Beast-Mode-FIXED-Functions#2.0.2. i believe REMOVE should help.
-
I'm sorry i don't understand. @PRC whta does having data in BigQuery have to do with anything? Just pull it into domo and transform it. It doesn't matter if the data is mutually exclusive or not. You can have Sales Data and Budget Data, that information is mutually exclusive. To present the data in a card / table, you…
-
oh +1 @buzz_boom just to be clear you do mean domo stats? do we know what the current behavior is for the drillpath cards? cc @jace_at_domo
-
@sbz87 Make your cohort_id the start of the week for the sign_up_date. Before you apply that to a large dataset, you might want to use a RANK_WINDOW function to find the "first row when a user signed up" (row_number order by date asc partition by user) or "first row when a user signed up with this product_type" Then filter…
-
@PRC you can't take something that you built (i assume) as a spreadsheet (not an actual pivot table) in excel and then expect a 1:1 match in Domo. In order to have one row for each metric, you'd have to have a column that contains the different values "All, "avg. duration", "transferred", "engaged"... etc. with the…
-
Account Management best practices, any tooling to manage accounts. How to manage POCs, DEV, and Prod pipelines in Domo.
-
Still a problem over one year later :(
-
Don't partition a table of customers. that is the perfect use case for UPSERT if you use the customer_id as the upsert key. "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." Yes, the ideal case for…
-
how do you know which row you want to exclude?
-
i wonder if you could get that from the layouts API. just edit your dashboard, right click and enable monitor network traffic in your browser, then save your dashboard, search for layouts in the resulting list of API calls, I'll be the type of interaction is captured in there somewhere.
-
you could materialize your FIXED function as a column on your dataset by implementing it in DatasetViews. It seems like you need MAX(MAX() ) because you're trying to ascertain "current_week_num" , that's static and probably doesn't have to respond to filter criteria, so just add it as a column.
-
@Jmoreno you can install workbench on your desktop
-
@klifford make a date dimension table that has one row per day and a column for all the fields you'd want to pre-aggregate on. @GrantSmith did a nice writeup here https://dojo.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest
-
@MarkSnodgrass i was flipping through your tutorial. in your proposed solution the DateFilter is set to This Year + a couple extra years via YOY comparison option. as best you can tell, is Domo actually applying the DateFilter filter? I'm guessing not b/c Domo ought to be limiting you to either just this year, or the last…
-
surely this is a bug. not an intentional design choice.
-
This request has been a known missing feature in Domo for years. It would be amazing to see headway on this.
-
Some videos on Domo Everywhere from my conference and channel. https://www.youtube.com/watch?v=jcJ3xSCzbdQ
-
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