Comments
-
@MarkSnodgrass Last question and this should bring it full circle. How could I aggregate 2 values in the same column. Say in the status columns i wanted to add up all the 'Converted' and 'Future Dated Rental' values then divide them by id?
-
aaahhh, no I made a gaffe with that data. You wouldn't see any FDR's with a 'true' . My bad, all FDR's will be 'False' because they have not converted to a rental yet, I want to treat them like they have and be added to the count of those that have been converted that are labeled 'true'.
-
@MarkSnodgrass that 'or' is kind of throwing me off. basically all I want to do is take the count of FDR's and add them to the count of unit_rented_c then divide them by the 'id' for a new conversion % FDR is a status inquiries go in that I want to count as already being converted to a rental, even though the status hasn't…
-
@MarkSnodgrass Thank you it's starting to make a little sense. @jaeW_at_Onyx is too smart! 😂I am starting to go through this and getting the 2 datasets joined together. Where it's still a little cloudy is the 'every campaign has a value of zero instead of null for each date.; Cause right now the campaign ads dataset itself…
-
@MarkSnodgrass is it the Domo Dimension Connector? If so, I am looking at the files available to pull when setting up the connection, and the only one's I am seeing that are related to 'Date' is AUcalendar.csv and calendar.csv.
-
@GrantSmith That's good info. Thank you. One more question, is there a primary key that gets pulled in through the different performance reports in the google connector that can make it easy to join those reports? I was able to pull in all the reports needed and the data looks good but the next step would be able to…
-
@nbrx I came across your question likely in search of a similar answer you were looking for. I have tried to use the Google ads connector, and trying to pull in the Campaign report, but when I run it it fails and says it cannot pull in the selected metrics from the campaign report. Did you find a better way to pull in…
-
@GrantSmith Worked like a dream. Thank you!
-
@GrantSmith Yeah that was plan B the filters on the page are also found in this second dataset, so I will now create an individual card from that dataset then add it to the page. I just wanted to be as sure as possible that it wasn't possible to add it to an existing card. Thank you @jaeW_at_Onyx and @Lady_KMac as well
-
@Lady_KMac I will take a look at this. Thank you for passing this along.
-
@jaeW_at_Onyx both these reports will refresh on a daily basis. Transactions take place, people move in, and move out daily, so each day will be a fresh update. I will give this a try. Thanks for the guide line!
-
@GrantSmith @jaeW_at_Onyx I attached what the table currently looks like. Showing the calculated columns for YOY and MOM values both the % and the net difference, along with the table date setting reflecting the past 13 months, which is what is interacting with the 2 period over period calculated columns. We are really…
-
@jaeW_at_Onyx Ok now I can see. I am on the right path. So this data is meant to be in a table so that why there were custom calculated column for YOY and MOM and now the MTD amounts. sorry if I missed something but where is 'amount' coming from?
-
@MarkSnodgrass Lesson Learned! Thank you.
-
This is the first time I have posted a question and accepted an answer. Can you direct me on how exactly to close this out? I just keep clicking around and I am getting nowhere.
-
@jaeW_at_Onyx SMH, I figured it out, it was a dumb oversite on my end. I appreciate your help. You helped point me in the right direction to discover this tedious mistake.
-
@jaeW_at_Onyx I tried both the single ticks and tilda around the columns, and the result was the same.
-
@GrantSmith I attempted include the ELSE 0 END, and it did return values that were able to be displayed on the card, but it just returned 0% for everything. @jaeW_at_Onyx I went through and I am fairly certain I have typed it correctly. I have written beast mode calculation previously for the overall conversion rate for…