BusinessObjects Board

Xclesius Bar Chart With Dynamic Y axis Lables

other Xcelsius - Crystal Dashboard Design
#1

Dear Experts,

I need to combine two bex querys in Xcelsius.

My Requirement.

I have two bex querys in my Xcelcius.

First Query Contains objects like KPA ID, KPA Name

second querys contains KPI ID,KPI Name,KPA ID,Sales,Profit.

I have a combobox(KPA Name)

KPA Name ( New york, California,Alabama)

If I Select New york in my combobox i need to display KPI Name in my Bar chart Y axis Lable and profit in X axis lable.

here tricky is in New york we can have multiple KPI Name which are not same as California and alabama.

Supose if ii select California in my combobox I need to Display Different KPI names In My Bar Chart Y axis Lable.

I don’t want to create multiple bar charts in single chart i need to solve this requirement.

we have almost 20 to 30 records in KPI Name.

I hope my requirement is clear for you.

Please assist me to solve this issue.

Thanks.

Praveenshepuri (BOB member since 2017-04-29)

#2

No problem… sounds like you need another level of selection for some KPAs. Why not create a KPI Name combobox and use dynamic vis to only show the secondary selector when a KPA Name is selected that has multiple KPI Names?

datawizard (BOB member since 2015-01-20)

#3

Thank you for Response.

Can you please explain me some what detailed way.

Thanks.

Praveenshepuri (BOB member since 2017-04-29)

#4

what about your parameters.
u only metioned result , but not parameters.

Mophi :cn: (BOB member since 2009-11-10)

#5

Well, it is a little hard to explain in a text box. Use an array like

KPA select | Seq | Multi-KPI Names
Texas 1 X
New York 2 X
California 3
Alabama 4 X
…

then vlookup that returns Seq # and if Multi = X then display KPI combo selector.

then have a second array setup to provide

Seq | KPI1 | KPI2 | KPI3 | KPI4 | and so on…
1 Dallas San Antonio Ft Worth Houston
2 Albany New York Buffalo Syracuse
4 Mobile Birmingham Huntsville Montgomery

Then another Vlookup to pull the KPI list for the selector labels…

Then connect the selector outputs to pull the chart data and to feed the selected KPI label to the Y axis…

A little quick and sloppy but may give you an idea…

datawizard (BOB member since 2015-01-20)

#6

that’s not what i was talking about.

u have to trasfer some parameters to a query before u get the result.
that’s the parameters i metioned.

unless , your query doesn’t have any parameter.

Mophi :cn: (BOB member since 2009-11-10)

#7

@Mophi - sorry for the confusion. My last post was answering Praveenshepuri request for more details.

datawizard (BOB member since 2015-01-20)

#8

my point is , how u design your dashboard , sometimes depends on how u design your data source. they r related.

as i see your requirement, it is a little like a cascading style, witch u can do it with some tricks on data source.

Mophi :cn: (BOB member since 2009-11-10)