Table Transpose Columns To Rows On Datapage

[ChrisCarlson]

I have a table where i am capturing question results. There are question fields Q1-Q50. I would like to build a report that shows question ranking results (for example, question 1 was answered 98% yes, etc). I know this function is available in SQL using Transpose but am not sure how to achieve in Caspio. On top of transposing column data to rows, I need to sum those results. Any suggestions on how to proceed? I think displaying a datapage with calculated fields set to sql query each question would work?

[Jan]

Hello ccarls3,

 

If I understand correctly, you have a table with 50 (or more) fields, every row contains answers from one user.

Does "answered" mean "Not blank"? If yes, maybe you can use an Aggregation field?

You can use the formula like

(COUNT_NON_BLANK*100)/COUNT

Does it work for you?

[ChrisCarlson]

I am looking to transpose columns to rows, as the formula above is limited to counting all responses. All responses either have Yes, No, or N/A. I need to count the Yeses, the Sum of Yes and No, and divide against eachother. Once completed, I need to sort all questions from highest to lowest %.