Best Of
Re: SQL DataFlow vs API access
The MySQL dataflow runs slower because it must transfer 16MM rows to the MySQL server process it and then transfer the data back. Queuing via the api doesn’t need to transfer the data across systems so it’ll be much faster
Re: Issue in creating pivot table
@PRC Both of the issues you pointed out seem to be related to the beast modes you are using in the rows and columns of your pivot table, specifically "Completion" and "year_val". I suggest reviewing the formulas for both of these fields and validating that they are producing the correct output.
Re: Need help with beast modes to show yesterday's invoice total amount, and previous year, current date
Looks like you're missing "END" in the second formula
Re: Can't add an existing card
@bkdadomo The card search function can often be slow. I recommend starting from the card you want to add, clicking the card options wrench, and choosing the "Move / Copy" function. From there, you can search for the dashboards where you want the card to reside. Once you click "Save" the card will appear in the Appendix of the dashboard.
Re: how to split up column based on string of charecters
We don't have the ability to delete the posts but an admin might be able to.
I'd recommend leaving them up but posting how you ended up solving your own question so others can also learn who may be having the same or similar questions.
Re: removing last 5 characters of a value
Get the left characters up to the length of the last 5 characters.
LEFT(`Field`, LENGTH(`Field`)-5)
Re: Is it possible to recreate the SUMIFS formula in DOMO?
You can use a case statement within your SUM aggregation:
SUM(CASE WHEN [CONDITION HERE] THEN `Quantity` END)
Re: New Customers/
Ok, you can utilize a Magic ETL and the Rank & Window tile to calculate the customer's order number. Make sure you sort on the order date and partition based on the customer identifier and calculate the row number. This will then get you a number for each customer's order with their first order having a value of 1. You can call it Order Count.
Then you can utilize the Order Count field in your visualization and filter for Order Count = 1 to only show the first orders for customers. Then you can also utilize a PoP chart to display the last year vs this year comparison.
Re: Pivot Table Subtotal Control
YES - this can be super frustrating. I've had to exclude columns from subtotaling because the beast mode aggregation isn't appropriate for the subtotal aggregation!
