jaeW_at_Onyx Coach

put a filter card to the left of the link so you can filter the table to a manageable number of rows.

use HTML wrapped in a CASE statement. CASE WHEN True then CONCAT( '<Div style ... >'... Note only works with HTML table cards not Mega Tables (therefore will not scroll).

@Culper_Jr , I appreciate that it is a little jarring to have 'read only' users be able to see a section called 'Admin.' But it's just a name. In terms of actions, the stuff they can do is very limited, and they'll only see content that has been shared with them. The Admin section is actually a really great way to see 'all…

i'm going to ask a dumb question. is there a reason why dataflows can't run at 8AM UTC year round? you can use the javacli to execute datasets and dataflows via command line. this way you'd have control over exactly when they triggered.…

i'm going to ask a dumb question. is there a reason why dataflows can't run at 8AM UTC year round? you can use the javacli to execute datasets and dataflows via command line. this way you'd have control over exactly when they triggered.…

ook... now it just sounds like you're doing an export of a MySQL dtaflow. I think we're back to @GrantSmith 's answer. In MySQL you can do two types of operations. Either you GenerateATable (which functionally converts your SELECT statement into CREATE TABLE AS ...) or you can write a SQL transform that can do any other…

@GrantSmith and @mberkeley have a look at pfilters.

@walker_page and @GrantSmith Both MySQL and Magic will have similar (but not necessarily the same) action definitions, but of course they run in different environments. @walker_page if you're trying to dynamically generate MAgic ETL, then just chain all the scripting tiles and take note of their name. The harder part will…

those may be private APIs. you can monitor network traffic from Chrome to see which APIs the browser is hitting. And you can watch the youtube video i linked to see how you authenticate against Domo. leveraging private APIs is not something Domo supports, so you have to sleuth a bit. There may be some wizards in the Domo…

@Culper_Jr ask your CSM. But also, I recommend you frame your question differently. Instead of "why can i see X in the admin section", reframe it as "i want to limit this behavior." You can't change the UI / UX, but you can alter what actions people can perform. So ... what actions do you want to control? Also if you don't…

@walker_page when you run a command via the Java cli it prints to screen which API it's hitting. If it's just sending a POST request, then recreating the request in python should be pretty straight forward. https://www.youtube.com/watch?v=oT5NipvWK1o&t=1309s

Also if you have beast modes that were NOT shared to the dataset A that you then copy to Dataset B, IF dataset b has beast modes with the same name, you can run into a collision. Beast Mode manager will be the most effective tool for handling collisions.

@stefanlambert , ... you can easily do what's available in the domo.js function. If you're building Dashboards that are filtered to subsets of data, consider creating a filtered Dataset View. Then point all your cards and app to the filtered DSV. You don't want to be setting up dashboards where the cards are filtered to a…

@cathynewton there is a default limit; however, if you contact support they can help you / lift the limit. That said, in my experience, you never need more than a hundred columns unless your data is structured poorly. If you data is structured poorly, then it probably makes sense to restructure it before you pull it into…

AFAIK embed Dashboard is a premium feature. Contact your CSM / Sales Rep.

@domo_sensei2 Domo cannot apply a CASE statement AFTER the aggregate. If you need to apply a CASE statement on the aggregate, then you have to pre-aggreagte the data in ETL or a Dataset View. (you could then JOIN the preaggregated data back onto the transactions to retain the granular detail.…

@HowDoIDomo 1) the OUTER JOIN is doing what it's supposed to do. just keep in mind, if you're doing an tableA.SalesRep OUTER JOIN tableB.SalesRep on A.SaleRep = B.SalesRep 50% of the time SalesRep will have data and 50% of the time the column will be NULL because THERE WAS NO MATCH IN TABLE A. In other words, when…

@StefanoG try to take the approach of building the 'interactions' experience you have with 'normal' Domo cards. take a look at domo.onFiltersUpdate

SQL is a great tool, but I recommend you consider building a date dimension and then just marking the days as isWeekend or not. Today they want week days, tomorrow they'll ask you to exclude holidays.

@walker_page and @GrantSmith I would test the assumption that the datat are in Company Time. Domo's presentation layer should present all times according to the Company settings (Analyzer, Dataflow last executed etc); however, AFAIK the data is actually stored in UTC (which makes sense for clients that opt to change…

@Mark thanks for the shoutout; but also, you can't apply CASE statements AFTER aggregation. You'll have to use a Dataset View or ETL to pre-calculate avg monthly revenue, then use a CASE statement to assign tiers. https://youtu.be/Esnu1PSxRjM?t=621

@kstaufferTek , what problem are you having? This is probably a question best directed at support@domo.com

@msharma be specific about WHERE you are conducting your ETL. It's imprecise to call anything "Domo SQL" and no one will know exactly where you are in the product. @MarkSnodgrass is correct MySQL dataflows do not support Window functions. It's not because it's a 'Domo flavor of SQL'. MySQL dataflows are running in MySQL…

is the entire row duplicated, or is there a slight change in one column value?

What you're describing is a window function. If you abstract your problem and google "percent of total" SQL, you'll find loads of solutions. You'll have to ask your CSM or support to enable "Window functions in Analyzer" but after that sum(sum(hours_worked)) over () will give you the 56…

I assume this is data where you took a payment table and JOINed it to a Employee Timesheet table. Don't JOIN the data. Append, UNION, the two sets of data together. I know it sounds like work to understand why UNION is a better solution than JOIN. But trust me. As you JOIN transaction tables together, you are going to try…

@AJ2020 , to phrase, your question in plain English, is the problem you're trying to solve "if the activity finished after 3pm THEN assign it to the next business day?" if so then you can break the question into 2x parts 1) does the activity occur after 3pm? CASE WHEN <activityOccursAfter3PM> Then <nextBusinessDay> ELSE…

@Stefano true. send a fetch or any other async method of querying APIs in JS.

... i didn't write domo.js :P why don't you just send curl requests?

@StefanoG who is sending the 400 error? Domo or AWS? are you saying you're unable to capture the response from domo.post? b/c it seems to me you would just async / await and console.log the response.