Skip to Content
0

Creating a Webi Report Question

Oct 24, 2016 at 06:39 PM

31

avatar image

I have the following fields on a report:

Institution
Personal_ID
Caption
Caption_Value

My report looks like the following:

Institution Personal_ID Caption Caption_Value
1 1 Tickets Yes
1 1 Refereed Yes
1 1 Bike No
1 2 Tickets Yes
1 2 Refereed Yes
1 2 Bike Yes

Is it possible to create a report that looks like the following:

Institution Personal_ID Tickets Refereed Bike
1 1 Yes Yes No
1 2 Yes Yes Yes

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Jeff Crisp Oct 24, 2016 at 06:58 PM
0

As a side note, I am trying to do this without having to create Variables.

Share
10 |10000 characters needed characters left characters exceeded
Ravi Reddy Nov 23, 2016 at 03:23 PM
0

Use the below formulae in each column

=If([ Caption ]="Tickets";"Yes";"No")

=If([ Caption ]="Refereed";"Yes";"No")

=If([ Caption ]="Bike";"Yes";"No")

Share
10 |10000 characters needed characters left characters exceeded
Sai Prasad Nov 28, 2016 at 09:38 PM
0

Hi Jeff,

Did you try to create something like in below link formula?

http://bi.srivatsakr.com/2011/08/converting-rows-into-single-cell-comma.html

Thanks,

Durga

Share
10 |10000 characters needed characters left characters exceeded