JacobFolsom Contributor

A dynamic solution at card level can be to use a window function. It's not currently documented and may be subject to change, but I've found it to work for basic aggregates: SUM, AVG, MIN, MAX In your case, you could get the grand total: SUM(SUM(value)) OVER () And for % Total: SUM(value) / SUM(SUM(value)) OVER ()

The code below will produce negative fractional hours if Start Date > End Date and positive fractional hours if End Date > Start Date. (UNIX_TIMESTAMP(`End Date`) - UNIX_TIMESTAMP(`Start Date`)) / 3600 NOTE: UNIX_TIMESTAMP() returns the number of seconds since 1970 and will therefore only work on dates after that time.

@John-Peddle I can't see anything wrong myself. Is "Current" in your Summary Number set to Last? It may be that the 29.94 is the First.. What happens in the Summary Number if you only have the line for Unscheduled Breaks instead of adding them together...will it show 8?

@user02364, You can accomplish this using a SQL Dataflow with two steps: 1) Summarize the Won/Lost counts as column values at a monthly level by Employee 2) JOIN the Summary data to the Sales data on the Employee and Date. (These steps are combined in the statement below) -- Aggregate all to Monthly Level and Pivot out Won…

@Wenling_Zhen, There are some inherit limitations with each connector, depending on many factors from Vendor API limitations like a date-range limitation or a usage throttling imposed to prevent you from querying too much data from them. It could also be an issue in the Domo connector code that needs to be investigated. I…

@Wenling_Zhen, There are three upload options in Domo: * Workbench * Connector Framework * Dataset API and Stream API Within the connector framework, there are some limited options, such as the standard File Upload connector which is limited to 256MB files from a local file connection. For larger files, you would use the…

@user02364, Ok, great. I understand what you are trying to do.. So let's remove DateA from the equation. Solution 1 - Append Datasets In your Magic ETL job where you append data, rename your Date Columns so they have the same name, this will allow you to retain the granularity of the closed/won activity and also the…

@user02364, I am happy to help with this and can see how it's been a challenge. Can you clarify for me on the top row of dataset1, what is DateA vs DateB and how do they relate to the Sales Stage... DateA:DateB:Employee:Sales Stage:3/3/20183/5/2018John DoeClosed Won I want to make sure I understand how to attribute the Ops…

@user03941, Thanks for sharing this question. I wasn't aware of this issue, but I can replicate this with a custom app on my side as well. From what I can see, the custom app is rendered as a rasterized image which doesn't preview or scale cleanly in the slideshow mode. My app was only showing the top portion, for example,…

@John-Peddle, I have a solution for you using Window Functions in beastmode. This is not a documented product feature and as-of today is to be used at your own caution as it comes with some limitations, but it does work well in some scenarios. NOTE: This aggregates the daily data up to the MONTH in the PARTITION clause.…

@smaiolo, I think the issue may be that the email attachment expression is not being recognized. Does this attachment name change with each email? If it always starts with PdTagIaXXXX.csv, then try inputing PdTagIa* in the 'Attachment Name Expression' field.

@tleong, Sumo cards are the primary method for replicating pivot like views, but you are correct they aren't supported currently on iOS app. One solution to consider would be creating a Magic ETL job using the Uncollapse Columns component which will group rows into columns...so essentially you could munge the data into…

@swagner, I recommend testing a slight change to the beastmode to remove the ELSE 0 statement in the numerator because the COUNT DISTINCT will actually count the 0 as a distinct value and thus inflate your top number by 1. COUNT (DISTINCT CASE WHEN `Ship Via Group` LIKE '%Counter%' THEN `Order Number` END) / COUNT…

@ptran, In my experience, you can't set user defined variables like a typical MySQL script with a SET statement upfront, but you can initialize them inline in a subquery and then reference in an outer select statement. For example, the statement below will initialize @row = 0 and increment +1 for each row in the select…

@danielj, I have also run into this issue. The dataflow will not reset or kick-off a second time upon completion if another input updates while the dataflow is running. Using a datafusion is one solution, as each input is automatically updated in the output.