Forum Discussion
Field Parameter (single select to filter two axises)
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?
3 Replies
- JorgePinho
Solution Sage
- AlmiworkFrequent Visitor
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
Solution Sage
That's great! Thank you for your feedback 🙂