Will This Not Work?
IF ATTR(.affiliate_id )=ATTR( t2.affiliate_id)
This Will Create a Column in Table 1
Then This Should Work
IF ATTR(achievement_type) ='APP_CREATED' and ATTR(achievement_type)='REFERRAL' Then COUNT (Number of Records) ENd
It may Work, not sure
I don't think this will work because there are not two separate tables that can be joined by affiliate_id. There is one table only. I guess I made that a little unclear when I pasted the query for PostGres, because in that service I can join the same table to itself, but in Tableau I can't.
THANK YOU! You pointed me in the right direction using LOD. Because I needed a graph over time instead of a table, I just put your "Eligible Row?" calculation inside a COUNTD() function.
Then I made a similar calculation for APP_FUNDED rows and put the date created field and Measure Values into the columns and rows of my view. The result is this:
You're welcome Drew. Glad you worked your way through it.