jaeW_at_Onyx Coach

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

you don't delete records with partitioning so much as replace a volume. This is a google-able topic, but this might give an idea: https://www.tutorialgateway.org/table-partitioning-in-sql-server/ Flags / Options in the javaCLI when you upload data will allow you to define partition column and values. so just use 'help' in…

@user00563 ... please reread previous comments and revisit the previously linked KB article. https://knowledge.domo.com/Administer/Controlling_Access_in_Domo/04Security_Role_Reference#:~:text=The%20various%20default%20security%20roles,security%20roles%20available%20in%20Domo. Construct your grants based on what you want…

https://www.youtube.com/watch?v=Xb4QgKYgaqg&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn This tutorial outlines the concept!

@MosesWynn , I'm interested to know what you were expecting to get out of a certification. (I'm not trolling, it's defo information that should get passed back to Domo and Carolynn and team). I think the idea is to build up a community as well as have a verifiable credential that makes you a bit more marketable as you go…

@Joe_M always test to be sure. but if functionality changes, without a documented reason, then it's worth reporting to support.

@SLam reread my responses. The items to check are all there.

'you can APPEND New_Data and Historical_Data, then use WINDOW&RANK to ROW_NUMBER your data, PARTITION BY phoneCall_ID and Order by TimeStamp.' Make your partition at the granularity of the data (dateTime it sounds like) order by timestamp.

I think you need to be clear about what you're trying to restrict. Assume EVERYONE can access a tab called 'admin.' But not everyone can see the same options / do the same things in the admin tab. So, what exactly are you trying to limit? You describe several unrelated things...

I know i'm late to the party, but @MartinB it's just basic math. CONCAT(ROUND(1-(COUNT(DISTINCT `nc_list`) / COUNT(DISTINCT `lot_number`)),2)*100, '%') If you have 1/3 ( = .33333333) and you wrap that in round( 2) you'd get .33 so when you multiply by 100 you'd get 33. if you wanted 33.33 then you do round(4).