jaeW_at_Onyx Coach

https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_File_Retrieval/Airtable_Connector that's super cool @user068035 !! how does this feature differ from the build-in connector that's part of the Domo library? Does it offer new functionality? I assume you can mass…

if i understand your question, to break it into pieces you should start with: "what percentage of the users does each domain account for" so you need a percent of total calculation. then you want to order your domains by percent of total ascending then you want to keep all domains where the cumulative sum of 'percent of…

sorry. your question without more context does not make sense. could you provide a sample of data, or a spreadsheet of what your data looks like and the math you're trying to approximate?

... this is bad sql. while you can 'make it work'. it will be prone to invisible errors. you can't SUM DISTINCT values. ... or at least... you shouldn't. you can COUNT(DISTINCT) values. I assume you're using sum(distinct) b/c you have multiple rows with the same value repeated. your hope is that if you sum(distinct) you'll…

you can embed video in the form of a document card (but you'd have to upload the video to Domo). you can build a custom app that will run an iframe of a video (like youtube or similar).

AFAIK, Mega tables do not support HTML formatting. HTML tables do, but they don't have all the functionality of Mega Tables (on the fly sorting or scrolling).

@GuitarMan2020 , I'm with @Ashleigh isnofar as your use case / requirement is a bit unclear. what i'm gleaning from here, to boil it down is that you want your report to trigger an alert if a task hasn't already been created. there is a domo_stats dataset called 'tasks' which i assume will give you a list of all your…

send in a quick support ticket and confirm that the connector is still being updated. some of the microsoft connectors floating around the domo library aren't always up to date / in use b/c of API changes. also just ping your question to support they may be able to point you toward a KB article. that said, i'd…

use a Dataset view (beta feature, ask your csm) to isolate the subset of data that you actually need in ETL.. are you running magic or SQL? Magic can start ETL before all the data is loaded into the ETL environment, with SQL you have to wait until all the data is loaded into a table (and indexed if you're using redshift)…

Domo by default does have a limit to how wide datasets can be when stored in Domo. if you're using datagrid you need to be careful how nested objects are treated because with datagrid they just get flattened into a very wide record. consider an array of airbnb_listing dataset. ideally your dataset should be just key value…

my question about how the data is structured is important to the solution to this problem. what is the granularity of the dataset. a window function would get you halfway there sum(sum(amount) over (order by year(date)) -- IF the granularity of the dataset was one row per judge. but if the granularity of the row is one row…

@GrantSmith this is so clever! i love it. but also, @user003454 this will make your data dangerous in untrained hands. maybe consider using drill through to show the chart by region and then when a user clicks it navigates to a chart that shows the data by segment. when you structure the data the way Grant is proposing if…

lol... so now you need to use parenthesis to group your booleans. right now your tests are for the result of ... date1 AND date2 AND prod1 OR prod2 what this means is ( date1 AND date2 AND prod1 ) OR prod2 in other words, you'll get the correct number if you're prod1 and between specific dates, OR if you're prod2 across…

in the original code you forgot an END. when formattting your code, take the time to spread it across lines. that way you can ask yourself, "how should this codeblock begin, how should it end? sum( CASE WHEN `Date` >= ( DATE_ADD(CURRENT_DATE(),interval -15 day) ) -- these parenthesis are superflous AND `Date` <= (…

@GrantSmith sorry, your code may be good, but your reason is innacurate. you absolutely CAN aggregate across ROWS with the SUM column and include NULLS. so SELECT SUM( 5 4 null 6 ) as myTotal FROM table will return the expected value of 15. you CANNOT aggregate across columns (on one row) and include nulls. SELECT 5 6 4 +…

I'm pretty confident that Dashboard embed is a premium feature. Please confirm with your CSM.

@hamza_123 not to be that guy ... but why do you want to do this? data stored in Domo is assumed to be in UTC by the viz layer. if you change the timezone in ETL to any other time zone, then the Viz layer will think that it's UTC AND THEN convert the timestamp to your company time ... which will be wrong b/c you adjusted…

a series of nested IFNULL statements will get the job done as per Grant's recommendation, but have a look at COALESCE() it will return the first non null value in a chain. if you want to write it as a case statement then do a series of null checks case when colA is not null then colA when colB is not null then colB when…

what is the shape of your data? what is the granularity? (one row per judge per year? one row per judge when they were made 'active?') if it's one row per judge, then just do count(distinct judge_id) as a beast mode, and then Active Date on the axis. if it's one row per year, then you want to filter where year(active_date)…

At Grant, I'm not an expert on the indexing thing but I believe MAX(SUM(X)) over () would be accurate for all use cases, whereas Max(Max(x)) would be wrong if you're not showing the data in the chart at the row level. Example if there were two or three transactions per date, Max(Max(() would show the maximum of the max…

@swagner in SQL parlance that's called a cumulative sum. Which I mention because eventually you'll want to use a PARTITON BY which will reset your counter based on an Item, Customer or Year.

I don't think it's SQL correct syntax to subtract dates using date - date. you should use date_diff(end_date, start_date) OR convert your dates to unix_timestamp() and then subtract. see if that impacts the output.

Chris, I don't know the UI is behaving the way it is. As a work around could you just create beast mode to give you hours : minutes ...

Domo doesn't really support data in a ragged hierarchy (i assume your table structure is employee_id, emp_name, supervisor_id). You'd have to flatten your hierarchy into columns. L1 = CEO L2 = C-suite L3 = Managers L4 = Reports. Then you can create PDP policies based on those columns. it's a pain. At that point, instead of…

how many rows is 1gb. if we're talking in the low Millions, I would test out building a Date dimension before i invested the effort into building a custom app. also it's a bit of a hack, but you could create a beastmode on just the subset of cards you want the filter to apply to called Date_2 then filter on Date_2, it…

define "huge" @user037924 what you're asking for is not possible in base product without the redesigned I described. there is a beta feature called "Filter Views" (talk to your CSM) which adds the ability to change the date grain of your visualizations as a Page Level Feature cc @GrantSmith 

You could restructure your data such that you have the same data duplicated for days years months etc, you could theoretically filter on a column called 'period type' and then filter for day, month, year ... what exactly do you want to accomplish.

sounds like you're trying to do a category subtotal. you can implement that with a windowed function sum(sum(amount)) over (partition by category) you need to have the feature switch enabled. talk to your csm. If you've never worked with them before they can be super powerful but also have some pretty stringent caveats.…

I don't think there's an easy way per-se to accomplish this. 1) create a rownumber called row_id using the Rank & Window Tile. 2) split your data using 2x SELECT tiles, with Row_ID in both SELECTS. such that SELECT 1 contains all the 'other metrics' and SELECT 2 contains the months of 'projected quanitty.' 3) in SELECT 2,…

No. You can implement in a DSV (dataset view) but there is no native way in analyzer. https://www.youtube.com/watch?v=eifSYZIcPzg&t=465s