jaeW_at_Onyx Coach

OOF. Brillinat solution @GrantSmith I would push back on the customer. if you apply formatting to the currency it will convert type to text. By converting it to text, you can no longer take advantage of Total and Subtotal columns.

ask your CSM if there's a newer link. https://app-domo-com-prod.s3.amazonaws.com/labs/PDP/PDPUtil-2.22.jar.zip

@danidiaz are you asking for the name of the table in Snowflake? or the name of the dataset as represented in Domo? The name of the dataset in Domo will be in the UI. You will not see the name of the source table. (that would defeat the whole concept of federated query :P) You won't get the name of source table in…

'Domo SQL' is not a thing. Your query is running in a MySQL 5.6 database. just type SELECT VERSION() Your preview is doing exactly what your Query says... SELECT 3 columns. What are you expecting?

@bdavis with query-data in the CLI you can send properly formatted SQL (use MySQL syntax)... not sure it gets much easier than that ;) Also you can apply a LIMIT clause to paginate over large results. I will say, if you're expecting larger than 1M rows should probably consider another egress method (writeback connector --…

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