Comments
-
@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.
