Skip to Content
0

How to display percentage value in SAP design studio Chart if i have multiple filters?

Apr 30 at 11:32 AM

95

avatar image

Hi Experts,

We are building a Design Studio dashboard using a UNX as the backend. The version is 1.6SP2.

We have a requirement to display percentage in a chart.This chart should display data based on the dropdown value selected. I am calculating percentage value in IDT. but while doing Filtering in design studio these percentage is getting added up.

Is there any option to do custom calculation in edit initial view of design studio for unx as backend??

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

1 Answer

Todd Floyd Apr 30 at 07:21 PM
0

In the initial view change the totals display to Average. That should get you pretty close. Otherwise, you will have to change your universe.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Todd,

Thanks for the reply.

Can you please explain little details,what changes i need to do in universe?

I am already doing percentage calculation in Universe.But when trying to do drill-down these value in design studio these values are getting added up.So to remove these aggregation i think we need to do these calculation in design studio?if i wrong please clear me.

Thank you,

Jose Roy

0

Jose - I think Todd is suggesting to change Totals to average in edit initial view within Design Studio Application.

0

Hi Mohd,

The formula i need to use is (a-b)/b.If i use average it will not give me desired output.

Can u please put some light on this?

Thank you.

Jose Roy

0