jaeW_at_Onyx Coach

thanks for the mention @GrantSmith

@Adrien most days of the week if you're doing SUM(DISTINCT) you've designed your data ... poorly. usually this happens b/c people JOIN their Actuals to Daily_Forecast and then use SUM(DISTINCT) to avoid double counting targets. Don't. UNION your datasets. If you continue the road you're on, if you had two separate products…

@user095063 if you can't write SQL, i strongly recommend you learn your way around Magic 2.0. The more SQL you write, the fewer people at your org can support you as your queries become more complex. If it were me, i would 1) Trans_Table = union all my data together with a column for 'Activity Type' 2) Date_DimByType =…

I don't quite understand what you're trying to accomplish, but this is syntactically incorrect (for analyzer) ... it's fine for standard SQL. But this window function MIN(AOP) will not aggregate as expected. SUM(CASE WHEN LEFT(`Stage`, 1) IN ('3','4','5','6') THEN `Pipeline` END) / MIN(`AOP`) OVER (PARTITION BY `Selling…

@MichelleH Domo Publish would probably be the safest way to make sure you don't accidentally share content with users. Tell your AE you want to talk to Dan Hendriksen and then tell Dan, Jae W sent you ;) But also, there are commercial implications for Publish. You can also take a look at Publication Groups which is an…

you cannot do a count distinct across all your cities even with a window function. the window function would calculate count distinct for EACH city, and then take the average, min or max as you've tried already. unfortunately (as i'm sure you've figured out) if i have the same retailer code in multiple cities, it would…

sorry i meant Mega Table

There is a setting under General settings that will allow you flip how your Pivot Table displays metrics ... not sure if that meets your requirements. EDIT -- Lies. you can do it with a HTML table card. "transpose"

@user01109 it's the exact same code / solution. just JOIN on customer instead of order.

@DomoNewbie /@MarkSnodgrass you generally shouldn't put an aggregate function inside a CASE statement. the reason why your final solution works is b/c by using the aggregate functions in Analyzer, functionally you're moving the aggregate out of the CASE statement. you could write your beast mode as: sum( CASE WHEN `LOB` =…

@Liliana i strongly recommend against using Magic to uncollapse the data. if a new payer shows up your dataaflow will exclude them, b/c you haven't enumerated them. Pivot Table is a safe solution but becomes unwieldy as you get more and more payers. What's the question you're trying to answer?

@user018766 , Form Builder stores the data in a noSQL database (AppDB, https://developer.domo.com/docs/dev-studio-references/appdb). If you've heard of MongDB they are very similar. you don't have a document, like a word doc that you can access. what's the rest of your question? why do you want to access 'a CSV'? (it's not…

yes. use the Java CLI , https://domohelp.domo.com/hc/en-us/articles/360043437733-Command-Line-Interface-CLI-Tool , query-data will allow you to form your query using SQL-esque language. OR consider using DataSetViews to create subsets of your data (and apply dynamic date filters).

@Ashleigh , @MarkSnodgrass and @GrantSmith are on the money for very different reasons. 1) as your query get's larger, workbench execution times are 99% subject to the performance of your source database (how long does it take to retrieve your data from SQL). If you're parsing 82million rows on your source database you are…

@melyeo are you confident that the 'title' column never contains NULLs or blanks? I suspect Domo's code may not have good error handling built into it. So make sure your table, hazard, does not include rows where title is not populated. this video walks you through how you could calculate this from scratch step at a time.…

@leeann_flowers and @Nick_Bertz there currently is no way to set a default value on a filter card. you can set a "Default Filter," but no, you cannot stop people from un-filtering a column. If necessary, consider adding text to your dashboard that provides instructions for use.

@Khan and @GrantSmith there are features for Median() and NTile() in Analyzer, just ask your CSM to "turn on Median in Analyzer"

@Jbrorby make sure to check your results on edge cases with numbers that you know the answer to. You're doing alot of JOINs and GROUP BYs... sounds pretty dangerous because you might be allocating rows to unrelated data or double counting in some cases.

@MarkSnodgrass on paper you're probably right, but i think i would try to ascertain the granularity (what one row in each table represents) of @pangeran_zuko 's dataset. IF the granularity of Credit Limit Usage is one row per day per customer IF the credit limit has been used, then yes, the LAG() approach would absolutely…

Try other chart types. From what you're displaying Domo is working as expected.

glad you figured it out! "IF colB sometimes contains 0 or NULL you need to implement error handling because you will have errors." CASE when `Total Views` IS NOT NULL AND `Total Views` > 0 AND `Total Conversions` IS NOT NULL and `Total Conversions` > 0 THEN `Total Views`/`Total Conversions` END SIMPLIFY YOUR MATH. The root…

@jmcgurl , why are you hard coding all these filters into your beast modes? would it not make sense to use Quick Filters or Filter Cards to pass Region filter context to your viz? (this allows you to avoid single use beast modes. @GrantSmith good beast mode but careful -- this won't work ... `REGION CODE`= 'NA' AND `REGION…

What's the requirement? you described technical solutions. but why do you need what you're asking for? if you use HTML tags to control images sizes in a table card, yes you can pass styling in the HTML. Domo has limited support for that in table cards. I don't believe that's possibe in image cards. You can upload files to…

typically Domo can't show data in analyzer if it doesn't exist (i.e. if there is no data for last week it can't just make stuff up.) What is the 'right' baseline? In this videoe, https://www.youtube.com/watch?v=Xb4QgKYgaqg&t=261s, I describe it as defining the 'universe of options'. In your case, it sounds like you need a…

emm.... not entirely accurate @GrantSmith 1) Domo stores app related data in AppDB which is a NoSQL database (so operates on collections of documents, similar to MongoDB) 2) you CAN sync an AppDB to Domo's Vault as a dataset (see link below), it does create and update (via UPSERT) a dataset in Domo.…

Sorry, I don't.

handful of questions. why 16 to 28? is that b'c you're specifically interested in that point of time or is the timeframe dependent on today()'s date? (in which case build your filters and axis on a variant of the current_date() function. if it were me I would build an offset date dimension table so I can use other chart…

https://youtu.be/hRwrZABP8RE?t=107 Daren and Ken talk about it a little in this video.

@Afolabi that data does not exist in a dataset. You could sniff network traffic to uncover Domo's APIs and then create a dataset using tools outside of Domo like Powershell or Python.

Post a sample dataset. I'm not convinced the data is actually shaped the way you described, otherwise you should get a result.