Question Re: Calculated dimensions based on several objects in Technology Q&A

Calculated dimensions based on several objects

SofieH — Tue, 03 Sep 2024 08:55:12 GMT

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 we need to modify the Universe?
I have this:

and I want to calculate it like this:

Because the end users want it to look like this in the report:

Any suggestions how to do this?
Regards,
Sofie H

Re: Calculated dimensions based on several objects

SofieH — Wed, 04 Sep 2024 07:08:35 GMT

Really?! Is this simple logical dilemma not possible in webi?

Re: Calculated dimensions based on several objects

LGCA — Fri, 06 Sep 2024 17:33:16 GMT

Hi, Sofie.

With a little creativity, this is possible in Webi.

If you needed only a simple table (no charts), then you could do a crosstab with simple text labels and variables for each of the counts in the body. The structure would look like this:

And the first two formulas would be (with the others following the same model):
[Scanned Bracelet - Yes]=Sum(If [Scanned bracelet] = "1" Then 1)
[Scanned Bracelet - No]=Sum(If [Scanned bracelet] = "0" Then 1)

But because you want charts in the report, you must define more variables and create three crosstabs, which you can juxtapose in the report to make them look like a single crosstab (by hiding the top row of the lower crosstabs). Their structures would look like:

And the first few formulas would be:
[vScanned Bracelet]="Scanned Bracelet"
[vScanned Bracelet YN]=If [Scanned bracelet] = "1" Then "Yes" Else "No"
[Count ID]=Count([Ordinations-ID])

You then copy each of the blocks, turn them into column charts, and place them in the report, customizing the display of axes and legends to get to your final display:

Good luck!
Luis