jaeW_at_Onyx Coach

@user026529 , the IN argument works fine in a CASE statement in Magic 2.0 formula tile. just tested. Use MySQL syntax.

either use dataset views to construct filtered views of your dataset, or use the domo cli https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool#section_34, to query-data or export-data and create filtered exports.

@user09481 create a filtered dataset view and export the datasetview instead of the dataset. alternativly use the java cli, https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool#section_34 or the PyDomo SDK to construct filtered queries against the dataset.

@jgospel if you think this is a bug, submit a support ticket. information that may be of interest: was this a beast mode built on a dataset view or directly on the dataset, did you share the beast mode to the dataset or just create it at the card level?

Hey @Ian, sorry for the delayed response, do you have a query (fourth screen) are you able to validate connector settings? (second screen)

@MarkSnodgrass kudos for the mega patient answers! I love that. @user026529 , altthough Beast Modes ARE NOT executed in MySQL they do generally follow MySQL syntax. If you're encountering a Syntax error, just google your function + MySQL and it will generally accurately describe the syntax you're supposed to use. There are…

you would have to export from Jupyer dataset with those categories and values then build the card in analyzer. https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Other_Methods/Jupyter_Workspaces_(Beta)

@IanMaddrell this is probably a configuration issue. Please attach screenshots and check your settings closely.

@BrianBeau I think the certification process is intended to be used to support this requirement.

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