Forum Discussion

learner03's avatar
learner03
Post Partisan
2 years ago

Matrix visual order

I have a matrix visual and when I put the values, it  comes up as (rows and column headers)- But I need it to show the arrangement as this-      
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Try this approach.  DIY.

  1. Create a 2 column table with People count bucket in the first column and numbers starting from 1 indicating the order of the particular bucket.  Sort the first column by the second column
  2. Create a 2 column table with Time bucket in the first column and numbers starting from 1 indicating the order of the particular bucket.  Sort the first column by the second column.
  3. Create a relationship (many to One and Single) from your Table to the tables created in 1 and 2 above
  4. To your visual, drag People count bucket and Time bucket from the new tables ceated in 1 and 2 above
  5.