-
MongoDB Query Dynamic Date Range?
Is anyone aware of a method to write a MongoDB query for a dynamic date-range? I found this link online, and tried the code below, but it does NOT work in the connector: ... "order_date" : { $lt: new Date(), $gte: new Date(new Date().setDate(new Date().getDate()-1)) } Any thoughts on how we can do something like this in…
-
How can I use the MATCH() function with a declared variable string in a MySQL dataflow?
I am looking for assistance in determining how to use the value of a string variable to DECLARE a persistent variable AS a STRING that can be passed into the MATCH() function in MySQL transform.
-
Formatting Multiple Summary Numbers with Commas
Problem To build summary numbers with multiple metrics, one needs to use the CONCAT operator, which converts the entire output to a string. This means that numbers won’t contain comma’s. In this case, a solution is needed to dynamically add comma’s to these numbers based on their length. For example, in the Summary Number…
-
Domo Rounds Decimal Precision when using Nested Dataflows
I am building out financial calculations with Foreign Exchange Rates in a dataflow. These rates require accurate precision because they are used as multipliers against billions of dollars, so rounding the precision causes variances in the tens of thousands of dollars. Scenario: Domo is rounding the precision of numbers to…
