Field Parameter (single select to filter two axises)

[Almiwork]

Hi All,

Not sure if this is possible, but would be a cool if it is.

I basically have a cohort table comparing when a customer first appears and how often they continue to purchase from us.

The problem is i would like to multiple possible cohort dimensions, say by week, by month, by quarter, by year etc. 

I created a field parameter to allow the user to select which dimension of cohort they want to compare. My issue is I need two field parameters, one for each axis of the table (when the customer first appears and when the customer buys), since these are two complete seperate.

Is there a way to "link" these to field parameters, so you would only need to select Quarters in one selection and not in both? 

[JorgePinho · Accepted solution]

Hello @Almiwork !

I read an article by @Jihwan_Kim this week that might help you. 

https://jihwankimcscp.wixsite.com/supplychainflow/post/relationships-between-field-parameters-in-pow...

[Almiwork]

Worked like a charm with a one-to-many relationship only filtering one way. Added an additional column on each table with names (year,quarter,month,week etc.), not sure if that was required though 🙂

[JorgePinho]

That's great! Thank you for your feedback 🙂