Forum Discussion

AweMaggie's avatar
AweMaggie
Qrew Trainee
3 years ago
Solved

How to add more rows for Group by for a summary report?

I want to add more rows.  Any idea on how to do it?  ------------------------------ Aweke (DACL) Wudineh ------------------------------
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    3 years ago

    Np,
    The limit is 6 group bys.  But just make some concatenated formula fields to combines some fields. That will free up some more levels.

    Like 


    List(" ", [Field 1], [Field 2])




    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion

Np,
The limit is 6 group bys.  But just make some concatenated formula fields to combines some fields. That will free up some more levels.

Like 


List(" ", [Field 1], [Field 2])




------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
AweMaggie's avatar
AweMaggie
Qrew Trainee
3 years ago
Sorry Mark, is it possible to get the field name on the report instead of the response?  What I am trying to say is
For example I have a Yes/No question, so on the report can I get the actual question then with the number of Yes/No response?

------------------------------
Awe Maggie
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    I think it would help to see what a record looks like and have an explanation of what you are trying to do with this report.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------