jaeW_at_Onyx Coach

@clloyd01 my pleasure! If you run into more problems feel free to AT mention me or DM me at jae@onyxreporting.com. I create content based on problems in the Dojo, so message me if you run into a good brain teaser. sorry for the plug. Since producing those videos, I've gone freelance, so if you need direct support in…

if this is a production dataset, absolutely you should do everything possible to minimize the strain on the system. content management activities like minimizing beast modes, removing unnecessary columns, removing unused cards etc. will all help. additionally, follow best practices a DBA would implement to improve query…

a CASE statement is not the optimal solution for this problem. For maximum dataset reusability, you should implement a Window / Rank function in MagicETL to calculate row_number. In this case you'll Partition by Check_ID and then ORDER BY date desc or however you identify the 'correct' version of the check. Then in your…

@Sweep_The_Leg , Data volume can be a contributing factor. Filtering on DateTime instead of Date doesn't help either. If a dataset was updated recently, performance can feel sluggish until the cache / query history warms up. Are you working with a Fusion? Maybe build cards on a 'Dev dataset' that has a subset of the data,…

@riley_finn and @user10986 , tthe median() function can be enabled via feature switch. Ask your CSM to enable it. I believe the feature was added more recently, so the documentation and or UI may not have been updated to include it. Defo feedback for the "product feedback" button.

@user003911 , it's really hard to help you. can you post a sample dataset? or some screenshots? "same invoice number" as what? another row? or another column? do you actually have duplicate rows of data in your dataset? "pull one of the amounts" ?

@riley_finn , there isn't documentation on the set of functions available. you can see the list in the beast mode editor / creator. and most days of the week the functions will follow MySQL syntax. Median can be enabled using a feature switch (talk to your CSM) but that may be why the function isn't appearing in the UI.…

@JeffDaySJP i hate to say it, but I don't think you're going to get this one across the line without pre-aggregating your data. with the new Data Views beta, you'll be able to generate the aggregation in a VIEW, a la. CREATE VIEW new_domo_dataset as SELECT count( distinct customer, date) as visit_count, customer, date from…

@HelenHimmelman , at the moment, no i don't believe it's built into product. There is a beta feature that will enable a default filter. (I believe). create a BIG, conditionally formatted text box that said case when count(distinct currency_code) > 1 then 'HUGE ERROR' else 'currency code end). ... in reality I think they…

you can use the JavaCLI to get list-dataflow and get the details of a dataflow. This will give you a JSON definition of the entire dataflow which you could then send to a github repository. you can also alter the JSON blob and send it back to Domo via API to update a dataflow ... but that can get tricky fast. go to Admin…

I always advise my clients to build a date dimension (one row for every day since the dawn of time, with the columns for all the date attributes of interest (ex. end of month, end of week, end of quarter) etc. This gives users a graceful way to handle Calendar Years and Fiscal Calendars (which may have an offset year…

@Cartergan and @Joe_M , you can use HTML in summary numbers to create a ... formatted summary number: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/HTML-in-Summary-Number/m-p/22473#M2517 try creating a beast mode that shows two metrics on two lines by inserting a line break, <BR> tag. once you figure that out, then to…

wow no, I've never heard of that. The beast mode manager (is still in beta, ask your CSM for details) will help you identify problematic beast modes. In the immediate term, you can deploy the beast mode governance dataset to your instance. It will then allow you to search the 'code' text of all your beast modes, as well as…

Raise the question to Support@domo.com, there are best practices for building that historical dataset (I believe they'll direct you toward the feature called backfill?) If I reword your question, it sounds like you're trying to collect metrics for 'all your videos' ever. I am no social media analyst, but I believe the…

Of, tough! I would collapse the data to the granularity of 1 row per user response to a question. You'd have columns: UserID Topic Question Answer. Then I'd add a column AnswerNumeric as a 0 or 1. From there you'd be able to analyze the surveys. From there, you can just SORT DESC by survey response.

https://www.youtube.com/watch?v=cnc6gMKZ9R8 You could use the LAG() window function in beast modes (you may need to ask your CSM to enable the feature switch). Alternatively, see if you can get a hold of the Domo Data View beta, it can be optimized for performance which may be necessary given that your data is updating…

@user11651 ask your CSM about the Data View beta (which was previewed at Domopalooza) it will allow users to create filtered views of Datasets. Those views will have a dataset ID which can be access / exported via API (including Excel addon or as a CSV.)

https://www.youtube.com/watch?v=wmMrnPO9ivY&t=56s @user11651 here's a video that shows the design pattern @GrantSmith is referring to! @GrantSmith wrote:Typically the way to to parameterize a dataflow is to utilize a separate webform dataset with your value you want to filter on. You'll also include a second column in your…

If I were you, I would create a Date Dimension that has one row per day, and includes, 'End Of Quarter' as a date. Then JOIN that dataset to your transactions using a FUSION. Then in Beast mode you can calculate datediff(ActivityDate, EndofQuarter) You could wrap all that in a CASE statement to calculate if Activity Date…

@jstan , i think you're asking a bit of a dev ops question right? Like "I have a 'Sales Dashboard v1' and then I do development and create a Sales Dashboard v2, how do I get everyone to see it?" @MarkSnodgrass is correct, you could migrate cards between v2 and v1 version of the Dashboard. Alternatively, instead of having…

I believe the design of the system is so that you can gracefully accumulate history. As I understand it, with youtube (and all / most social media data) there is a seasoning period where metrics will fluctuate as systems update. So that lag window let's you capture any changes to data that occurred in the last n days. To…

@MarkSnodgrass nailed it on the head. build a lookup table that has one row for each failure code and how you want them remapped. (cols. FailReason, FailReason_CustomGroup) then Magic + Collapse columns will be the easiest way to collapse your data. then JOIN the lookup and the MagicETL column to avoid inflating your…

@WizardOz , so to clarify you created a view... a FUSION? or a Data View (the new beta?) or a View via the JavaCLI? and you're saying you unable to take an existing card and switch the dataset to another dataset. Sounds like a weird bug. Can you confirm that you can switch your card's dataset to any other dataset (even one…

i tried really hard to break my table card ... it still worked. does the BM work as a table card? is there any chance of dated being NULL? -- my BM works even with nulls in the dated column. @GrantSmith 

Hey @user04775 , Instead of hard coding this into a dataset, consider building a beastmode that creates these Balance Labels and then visualize this data in a card as @MarkSnodgrass recommended. The beast mode would just be the CASE statement. CASE WHEN SUM("MonthAverageUSD") < 100000 THEN 'TIER V' WHEN…

@Hey @WorldWarHulk , It sounds like you're describing two distinct things. UPSERT is UPSERT. Taking a monthly snapshot is a separate activity that you could implement with ETL, Data Assembler or Scripting. Does your SFDC data require UPSERT? If yes, you can implement UPSERT using the Java CLI if it's not natively available…

No it is currently not possible to have different landing pages per users. You could however set up a table on the default page that has URL links to the different places you want people to navigate to. Then apply PDP so users only see the 'correct links'.

It sounds like you want to compare weeks not months. Can you take advantage of any of the week comparison options? You may want to look at the fiscal calendar implementation. Keep in mind, months based on a calendar year versus months based on weeks are very different. (Because week-based months typically operate on a…

"But if no value (as like null), I want to accumlate up to the previouse month and don't want to accumlate after that month." OH. So you have the exact opposite problem I described. Create a FILTER WHERE Amount is not NULL. Calculate the cumulative SUM. then APPEND that data back to the rows where Amount IS NULL.…

@eriena , i'm sorry, google translate is doing a horrible job translating your question. I'm assuming you're trying to create a cumulative sum and want to include one row per month even in months where there is no data. The cumulative sum (WINDOW & RANK) tile cannot generate months for you if there is no data, so you…