jaeW_at_Onyx Coach

consider adding a "is_closed_period" column. that way you can filter on transactions that are part of the closed period and functionally "freeze" the data. alternatively, if you label transactions as belonging to the nth period (1,2,3,4th etc.) you could filter on "all activity from the 3 closed period or earlier"

it's unclear what your output from (presumably) magic etl scripting tiles looks like. can you send intermediate screenshots?

i am lead to understand that this is something Domo Product is actively looking at developing.

@TC111 why? most users should not have edit rights to the card... there are apis that will allow you to loop over all the cards in an instance, and surely enable a lock, but in most cases if you're managing roles and groups appropriately, most users should not be able to edit content.

@ST_-Superman-_ and @datamatt , typically for anything like headcount data, you'd want data the granularity of one row per client_id per facility per day. if you don't, imagine i have a customer who was admitted last month and stays for 3 months. in my report, i would only show them on the first day they were admitted. you…

@tobypenn most beast mode functions just use MySQL syntax

@Godiepi that's a pretty obscure use case that you'd expect full-on row duplication. you could use MD5() hashing to concatenate all the values together and then use a RowNumber + rank_window tile then filter where rownumber = 1 this is a classic way of handling identifying slowly changing dimension rows.

@datamatt Admin is just the name of a role. each role can have different grants https://domohelp.domo.com/hc/en-us/articles/360043438973-Managing-Custom-Roles so no, you don't have to be an admin in order to engage with the admin section.

@Davery if you need a list of options, could you use a look up or webform to JOIN in a variable value. Maybe a Dataset View with a JOIN might be the way forward.

@akki given the nature of pivot tables, you will see a row for outcomes 5 and 4 since they exist for the month of september, but to your point there is no data there. even if you wrote coalesce( sum(`value`), 0 ) you wouldn't see a value in August because there literally is no data there. in order to show a value in…

@damen the learning lesson is you shouldn't have nested CASE statements AVG( case when (CASE WHEN (`instrument` = 'first home') THEN '1st Home' WHEN (`instrument` = 'fannie mae risk share') THEN 'NoMi' WHEN (`instrument` = 'fha streamline') THEN 'FSR' WHEN (`instrument` = 'first home tax exempt') THEN '1st Home' WHEN…

@damen more specifically you need the grant (defined by Roles) that allows you manage pages. https://domohelp.domo.com/hc/en-us/articles/360043438973-Managing-Custom-Roles#:~:text=You%20can%20create%20as%20many,enabled%20to%20access%20this%20tool. it's not specifically that you have to be an "admin" you just need the…

duplicate

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