jaeW_at_Onyx Coach

@Crisocir don't do it in ETL. If you calculate running totals in ETL you can't filter show all your months on the axis. and then use a CASE statement to only accumulate data in the current month (case when month = current_month then amount) ... this is very puedo code.

... what have you tried? sum(a) + sum(b) what's the problem?

If your pipeline is built on dataset views then no execution is necessary.

You can't JOIN in a Beast Mode. If you limit how far back people can look (i.e. just 7 days, OR limit yourself to the end of a week) then your data becomes more manageable. The following approach MIGHT work, but the idea would be to build your Dataset on VIEWS instead of ETL so you get instant results. User Input: a…

@Theodore_Mwangi , @GrantSmith 's method will work. I wouldn't do it in Magic though, I'd probably use a Webform JOINED to the FACT table ON a constant 1 = 1 in a Fusion or DatasetView, this way you don't have to wait for the ETL to reprocess. But this is the only solution until the Dynamic Variable beta goes live OR…

send a support ticket. looks like it's an old build of Pandas? Tutorial on how to do the thing in MySQL To do it in MySQL 2.0 1) count the number of times <br> occurs. use a formula tile. 2) duplicate each row the number of times <br> occurs + 1 (use the countdown table described here,…

@msharma if i had to bet, i'm putting money on the fact that you JOINED the budget onto the Transaction Fact, and that's why you're using the Average. Don't. Use a UNION to append the budget rows to your dataset. That way you can avoid having to use Avg. See my tutorial video: Re, your beast mode, remove the = sign. Use…

there is an HTLM table card. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Sample_Beast_Mode_Calculations%3A_Card_Element_Transforms

Initially, @ravimohan911 sounds like you're describing a simple RIGHT JOIN. (keep all the locations from Table B and only rows from Table A if there's a match). But that won't let you know that for that date, there were no evaluations at that location (b/c the date column is in Table A, and would be NULL if there was no…

In Domo a Dashboard is synonmous with a Page. A Card is synonymous with a chart / object on a page. Pre 2019, Pages were organized into Collections of Cards. In 2019, Domo developed a new feature called "Stories" and "Layouts" simultaneously in two different departments. They took the best of both features and created the…

@user084060 keep in mind that the user has dates on the axis. So if my GROUP BY clause is Date and Search Query, then the number of rows I want to keep is Number of Dates x 10. Course ... if your number of dates fluctuates you get weird results. I know i'm not offering solutions ... I would say Domo doesn't have a good…

well... ok. to put more nuance on the answer if you read NULL as "I don't know" and you imagine that in your hand you have the value NULL. If you asked "does my hand NOT contain 7" you assume the answer is FALSE. because you don't know what's in your hand. it works the same way if you say "does my hand = 7" similarly the…

When you run the dataflow do you get the desired results? Also, fundamentally your result / query doesn't make sense that you posted. in your JOIN clause you're saying a.debtor = b.debtor. If that's the case a.debtor can never be populated IF b.debtor is null. also if you expected b.debtor to be null (WHERE clause) then it…

:P That's why you're not getting results. // try filtering on IS Not NULL just to confirm.

does your WHERE clause say debtor is null?

Interesting @Crisocir to make sure you're doing apples to apples in your screenshot, please next time make sure we're looking at the same customer_id in each screenshot. i notice that your data type of Level_0 appears to be numeric instead of integer... or at least that's what the UI suggests. Try changing the type to…

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.