jaeW_at_Onyx Coach

is this for a custom connector or a standard connector? if it's a custom connector, you can define your own scope. if it's for a standard connector, message support.

... i don't think you understood my last response to your last question. https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Case-within-case-in-beast-mode/m-p/50010 you have the same problem. you're applying AVERAGE to an aggregated row. SUM and a COUNT both of which will contain one row each. so your result will be the same…

Unless they made changes AFAIK pivot tables don't have support for HTML formatting. But let me know!

... i mean... if you think about it, it makes sense. You have a card filtered that SHOULD span two years. But then you filter to ONE year. So ... your card only has half the data available. It sound like you're trying to create a historical analysis (i.e. compare 2019 with 2018). Domo doesn't support that with the built in…

no not at the moment. Initially, filter cards were designed as a 'one or the other' regarding page filters. either use a page filter. Or use filter cards, but things get weird when you use both. the problem is, expectation. when you use filter cards, you intuitively know to uncheck the box that's filtering your other…

I don't think it's fair to describe the solution as poor. It just doesn't align with your expectations (i assume Excel.) Keep in mind that Domo visualizations and their entire approach to dashboarding initially was not designed to target Excel Jockeys, data scientists or analysts. The target consumer of a Domo dashboard is…

@GrantSmith is correct. but the larger question is, in what context do you care if there's a hard or soft delete? IF the issue is a question of GPDR compliance b/c a client requested 'the right to be forgotten' or whatever that verbiage is, yes, Domo is contractually obligated (AFAIK) to support requests like this. Usually…

It would be super cool to have a global study group for custom app work! I'd love to participate.

you would have to have a row for each department for each month. You can create a template dataset that has one row for each department with a fixed amount of 0, then UNION that to your actual dataset.

@ezmac13 if the math works, don't change. To solve problems like this, I usually pop open Excel and figure it out there because it's super easy to find 'excel equivalent in mysql' alternatively, if you used an article…

I like @MarkSnodgrass recommendation! Flex Tables don't get enough love. But also in the consulting work i do, @GrantSmith's recommendation is the data model I use for situations like this. Built a tutorial video for you. https://www.youtube.com/watch?v=CDKNOmKClms

is it beating a dead horse to say that this type of calc should be executed in a date dimension? If it were me, 1, in ETL i'd add the 'Submit Date (Date + 21 days) to the fact table. 2 create a date dimension where for each day i indicate "isFirstHalfOfMonth" as a binary. AND add the concatenation of MonthName + 'H1' or…

Agree with Grant. By design the Pareto will do a cumulative sum of the data displayed. So even if you filter out 20% of the value, the remainder will be the new 100%. what you can do is the grouped bar and chart. for the line calc, "if pct of **bleep** sum / total > .8 then .8" if you want to do the same for order quantity…

this is actually a bug (i believe). and should be submitted to product feedback. in the supplied screenshots both settings indicate "total row / column" should be positioned BEFORE the data. In the second screenshot, the Total ROW moves to the top, but the Total COLUMN does not reposition.

i don't understand your question. in what context are you displaying 'a list'? a table card? a filter card? do you want your list to include all data with or without respect to the page filters?

There's a lot of ... not great things going on here. DAYNAME(WEEKDAY(DATE(`itm_snapshot_date`))) This is a really verbose way to get the name of the day. I recommend looking at the DATE_FORMAT function to simplify. Also DayName is functionally the same as Weekday, so use one or the other, but don't run your function…

sorry ... i might be missing context. what are you trying to build and where are you trying to build it? (your screenshot was incomplete.)

Alternatively, you can use pFilters to pass filters to a page via URL. So theoretically, you get to your lowest level of drilling, then click a URL that takes you back to the dashboard with filters applied.…

Drilldown cards do not necessarily have to use the same dataset. Between a Drill down from Lvl 1 to Lvl 2, you could theoretically switch from dataset A to dataset B. Just be advised, as you drilldown, Domo will try to pass all the filters that have been applied in each drilldown to the next dataset, so you'll want to have…

At the moment it's not possible to control margins. It is a feature in development AFAIK but no planned release date yet. Ask your CSM for details.

I assume you're trying to embed HTML into a table card. Have you tried: http://sites.cognitivescience.co/knowledgebase/resources/using-google-sites/creating-mouseover-text-with-html

https://www.youtube.com/watch?v=YgevJkjeFqw&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=26&t=0s here you go!

@user053351 you can pull in a webform as a dataset. From there you could cross apply the webform to your input datasets, or JOIN as necessary.

hello @user084060 , screenshots help! If i understand you correctly, you'll need 2x tiles. the JOIN tile will allow you to ... join the dataset. then use the SELECT tile to select the columns you want to keep.

You can use the Java CLI to 'get-certified-content' that includes both datasets and cards. From there you would import that data as a new dataset and then mash the data up with Domo Governance or Domo Stats.

which api? b/c afaik after authentication, you should only use access tokens ...

Sure... but Simon what's failing? var creds = "username=" + DOMO.b64EncodeUnicode(metadata.account.Username) + "&password="+ DOMO.b64EncodeUnicode(metadata.account.Password); when you DOMO.log() the resulting string what result do you get? when you DOMO.log() the individual parts from the metadata object, are you returning…

The Domo_Gov datasets don't analyze data values rather provide metadata about the domo object. DG_Datsets for example has one row per dataset and attributes of the dataset DG_DatasetSchema will have one row per dataset per column and the attributes of the column. (it will NOT tell you what's contained in the column). You…

what's not working? can you post your code, sample input, actual output, and expected output?

Sorry your question doesn't make sense to me. What's the parameter value? ETL pipelines in Domo are expected to run without user input ... so where do you want to get the parameter value from? Either way, you can use a webform or any other datasource to pass 'parameters' into your data flow.