Forum Discussion
Matrix aggregation and filtering
Hi, I need to group values in the matrix by Source and Destination columns. How can I achive this? Thanks for any advice Previous Segment = Source Currenct Segment = Destination ...
yes, ok I should explain it better . I am not sure if this is technically achivable but according to date range on slicer I want to take first (soruce) and last (destination) segment_name for each persona_identifier and then group this by source and destination with count on persona_identifier
tamerj1
Community Champion
Community ChampionAnonymous
I can think of two possibilities. We have a good chance to do that by concatenation and a smaller chance by filter measure. Please share a sample data to work with and let me see if I can produce somthing.
Thank you
Hi tamerj1
sorry for late reply. here is a sample dataset
- tamerj1
Anonymous
I don't see any link?
Hi tamerj1
yes, sorry. here is the link https://drive.google.com/file/d/1Bx18wxlMb-JFrtZIE-l-BU3OdCtdvkAg/view?usp=sharing