jaeW_at_Onyx Coach

@Jessemauser the MYSQL solution will work just fine provided you have a date dimension (just make sure your start date and end date are actually DATE columns not DateTime AND make sure the start and end date have default values if they were left as NULL. Alternatively you can try to see if the Gantt chart will work for…

@Karim, Domo does sell the 'inline form editor' i believe it's called which will do what you're describing. (they also have a product for designing surveys ... which is again... similar to what you're describing, but i don't know the cost). @MarkSnodgrass , unfortunately since it is a premium feature ... lol... i can't…

@dmurgit1 unfortunately what you're asking for is not reliably acchievable in Magic 2.0 You must use MySQL (user defined variables) or Redshift (LISTAGG) to accomplish what you're describing.

https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/KPI_Card_Building_Part_2%3A_The_Analyzer/Creating_a_Map_with_Regions

this is a connector-specific question, @user030230, ask support.

@user13374 , problem with recursives is that it will take snapshots when the data updates. so usually you'd do an "End of Day" or "Start of Day" snapshot. If the task changed multiple times throughout the day you'd only get one row per day. Frame your requirements in terms of the business question. It could be "what was…

@user16872 Data pipeline orchestration with PyDomo or JavaCLI are your best bets. http://www.onyxreporting.com/blog/domo-python-tutorial-execute-datasets-and-dataflows-via-api-and-pydomo

you have to alter dataset_a to include a column, min_units and max_units then you JOIN dataset_a to dataset_b on a BETWEEN clause in MySQL

you can use a TRIM function in ETL or analyzer beast modes.

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