jaeW_at_Onyx Coach

@user055735 , this is a VERY broad topic / question. do you have some sample data you can upload? do you have a final dash board in mind that you want to build? a way to think about getting started would be 1) pick 4 or 5 categories for each free text answer 2) decide HOW you'll identify if the text answers the question.…

https://knowledge.domo.com/Prepare/Magic_Transforms/DomoR_Plugin/DomoR_Usage I assume you're using a fetch() and just dataset_ID ... dumb question, the access token you're using, have you confirmed that it has access to that dataset?

hey @user053351 , you can use FUSIONS + Webforms to create parameterized queries. check out this video for an example. https://www.youtube.com/watch?v=wmMrnPO9ivY&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=7&t=59s

There's a lot to unpack here! 1) don't JOIN your date dimension to your transactions to get the day count. instead APPEND the two sets of tables and conform columns so the Transaction Date and CalendarDim_Date line up. Then assign an activity type "Transaction" and "Calendar Count" to differentiate the two datasets. Why?…

@Billobi you can also use the border element too subdivide your dashboard. Domo will assume that content between borders are supposed to fit on one page, so if your content exceeds one page, it'll throw an error message in the Dashboard Design mode.

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