Forum Discussion

Rizza's avatar
Rizza
Frequent Visitor
9 years ago

Creating a Matrix with Q&A?

I am trying to create a Matrix with Q&A. I want States in the rows and Products in the columns and Profit in the cells. When I try to create this in Q&A with something like "profit by state by product as matrix" it puts all 3 data fields into the Rows of a Matrix. If I add an aggregation (eg. "sum of profit" or "total profit"), I can get Profit into Values. How do I get Products into Columns? I can manual drag it there from a web browser, but I can't find any way to create this from the mobile app.

Need Help

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    Hi Rizza

     

    I am not sure if you are aware, but when you go into Q&A, on the right hand side there are options to open the "Visualizations, Filters and Fields"

     

     

    If you click on the Visualiations and Fields, you then have the options to change your visual, which in your example you could change it to a Matrix and then put in the Products into the Columns.

     

    As you can then see with my image I then put in the values where I wanted them to be for my Matrix