I have a report with OrderIDs and related boolean dimensions for each order. I want to create a calculated dimension counting the boolean results for each dimension/object. Is this even possible in webi or do I need to modify the Universe?
I have a table with OrderID in rows and three columns that each give 0 or 1:
Table with rows per OrderID
and I want to calculate it so that the columns give three rows and the columns count the number of OrderIDs with 0 and 1 for each:
Aggregated table
Because the end users want it to look like this in the report:
Diagram
Any suggestions how to do this?
Regards,
Sofie H
I’ve tried running count but it doesn’t work.