Billobi Contributor 
-
Re: Has anyone had success in reporting on the notes object in Salesforce?
Say you go into the Salesforce Advanced connector and pick Browse Objects and Fields...if you put in "note" in the object dropdown as the wildcard, does the 'Note' object and others appear …1 -
Re: Trying to Count the number of Appointments in my data
So if "Invoices marked 'No Code' in Appt Text, '0' in Bay Code, and 'No Bay' in Bay Text indicate that that invoice did not have an appointment", does that mean that all other invoices have…2 -
Re: Need help with beast modes to show yesterday's invoice total amount, and same day last year
Watch out for your second portion of the evaluation...easy typo but you're looking at YEAR() vs MONTH() so it's not going to yield any results. Same day last year: case when year(`INVOICE_DATE`)=YEAR…1 -
Re: How to solve this problem in Magic ETL - Link items to Header rows
Hi Skhatri, that certainly is a limited ad platform dataset. You can join header data to the daily ad rows even though they're only associated by row placement, but it's heavy on the assumption that …2
