Best Of
Re: MySQL Workflow
@ArborRose Yes, the 500k limit is just referring to previewing the data. According to this best practices article, MySQL dataflows are best suited for transformations where the inputs are under 100 million rows. It's not out of ordinary to have MySQL run times beyond 30 minutes, but you should be able to optimize the dataflow by using indexes, reducing the number of joins, and only selecting the necessary rows and columns in each transform step.
Re: Custom User Profile Fields and be able to use them as Trusted Attributes for PDP
I will share this, it is always helpful to have the community submit the feedback as well directly (under "More ->FEEDBACK). This feedback is reviewed by the Domo team.
Re: Custom User Profile Fields and be able to use them as Trusted Attributes for PDP
This has come up in our workflow again and would drastically improve Domo for our end users. Please, work on this as soon as you can.
Re: Custom User Profile Fields and be able to use them as Trusted Attributes for PDP
we're currently in a situation where this would greatly improve our governance. please make this a thing, Domo!
Re: Count Unique IDs by Month-Year
Hi @tmerchant in that case you would want to remove Unique ID from your Group By fields. Then you can join back to previous tile on the year/month field.
Re: Syntax Error
@Stucker The formula should already account for both of those criteria.
This checks whether the Session_Date_c field has the same month and year as today's date:
case when MONTH(Session_Date_c) = MONTH(CURRENT_DATE()) and YEAR(Session_Date_c) = YEAR(CURRENT_DATE())
For each row that meets the above condition (having a session date this month), it returns the X12_Month_Scheduled_Review__c field. Rows that do not meet the condition return a null value.
then X12_Month_Scheduled_Review__c end
Rows where X12_Month_Scheduled_Review__cis null are NOT counted in the COUNT() function, so the result of the entire formula should only include rows where both criteria are met.
If you formula is not calculating as expected, then it's possible that the X12_Month_Scheduled_Review__c field contains empty strings instead of null values, in which case you can add an additional condition to your formula:
count(case when MONTH(Session_Date_c) = MONTH(CURRENT_DATE()) and YEAR(Session_Date_c) = YEAR(CURRENT_DATE()) and X12_Month_Scheduled_Review__c <> ''then X12_Month_Scheduled_Review__c end)




