-
How to Have different Groupings for avg Score
In this instance, I am getting Google Reviews 0-5 stars and averaging them overall time. But this is the all-time average ending in that quarter. I know I can group by quarter and year but that would only give me the reviews in that time frame. I want to have it calculate the all-time score up until that quarter. For…
-
Not in formula filter on ETL
Hey, I am attempting to use the not-in function to filter out reversal charges. I have a reference column and a memo column. The reference column has a transaction ID and I want to filter out the charge and the reversal. I am writing a filter Memo Number not IN(Reference Number) but it only outputs the reversal only. see…
-
Qualtrics Connector
I am working on getting data out of a Qualtrics survey that we send out for our company but I feel like I am missing data that the Connector should be sending back. I am having it get the Response Answers but I am wondering if there is a way to have embedded data included in the output of the Connector. I don't need data…
-
How to input identifiers using identifiers
I have a data flow that has multiple properties and competitors. I was looking for a way to label all of the records that are in between into one property. In the example sheet that i uploaded, I was wondering if a beast mode formula could be used to rows 3-16 are labeled as the property Brandon crossroads in this case.…
-
Question of how to mark or pass data for certain amount of records
so I have a table that looks similar to the following below. What I want to do is to label each activity in each record for each property. Only 5 different activity types don't change, but the number of records changes, so I cant count rows.
-
Question about using recursive reports but only reclusive until post month
I am working on setting up some recursive data structures to capture the data I need for this instance it charges in a period. We can call this resident's charges. Charges are accumulated until a post date which is most of the time the 21's day of the month with some exceptions. I have a small web form that lists these…
-
Case Syntax
I am having difficulty understanding the case syntax while using magic ETL. In the current Example, I have a list of properties and coded them to display a text column of the region for each specific property. Unfortunately, there is no address line to be able to parse and use to make the regions so I'm hard-coding the…
