BusinessObjects Board

calculate percentages in desin studio

other Xcelsius - Crystal Dashboard Design
#1

I have 2 measures in universe and I am trying to show bar chart in design studio to show percentages of Y and N. And I am following the below approach.

M1=count(ID)
where status=y

M2=count(ID)
where status=N

I need to calculate percentage and I am doing
M1%=M1/(M1+M2)
M21%=M2/(M1+M2)

But I get 100% for both and not getting accurate percentages.If it was a web I report I would create a calculated column in the web I report. Is there a way to do this in universe and pull it in design studio?

Any ideas?

Thanks!!

hourigan (BOB member since 2007-04-06)

#2

Hi,

If you are using a unx universe source, you can calculate the percentage in the query itself.
For instance in oracle I would play with a decode or a case:
sum ( case when status=y then 1 else 0 end)

The problem comes when you drill up or down, as I am not sure how can you get the right percentage (you can’t just aggregate on average).

Hope it helps,

drserguey (BOB member since 2010-03-01)