You don't typically need to use complex SQL like PARTITION. But, can you share a bit more detail about your underlying data and what you are trying to do with it? If possible, can you share a sample of your data. If it's sensitive data, then take a look at the following for tips on how to anonymize it: Anonymize your Tableau Package Data for Sharing
I have joined 4 tables viz. sale transaction, home, location and instances of govt ruling to build that view I mentioned.
The view also contains the price difference between 2 homes of similar attributes including city, and the transaction date differences of both homes against each of the ruling instances.
My objective is to show the average price differentials in various cities, where in Tableau I could allow the interactive nature of allowing the adjustment of valid date differences eg. transactions before and after the ruling instances.
Yes, I think it could be possible to achieve this _as_ I build the db view before presented to Tableau, but I thought I could do it after.
Let's see if this makes enough sense. I can try to share a sample later, but no guarantee as yet.
Thanx & Rgds,