BusinessObjects Board

Convert Master Data for Bar and Line Chart

other Xcelsius - Crystal Dashboard Design
#1

Hi

I am using Xclesius 2008. My data in database is stored in Rows and columns like any RDBMS data. But when I have to built a Bar chart with Alerts, I have to convert it in a different format… Similarly when making a Line chart I have to convert the data again in a different format. Thats what my understanding is…May be I am wrong…

Is there a better way to make both the bar and line chart on the same data format.
enclosing a sample dashboard for reference.

Thanks
DataTest.zip (9.0 KB)

rajx72 (BOB member since 2006-08-02)

#2

Hopefully you can open this file, as I’m a version ahead of you.

You don’t need your pushbuttons on the barchart, You can simply use the drilldown functionality.

-tkt
DataTest2.zip (13.0 KB)

theknowtank (BOB member since 2011-04-20)

#3

Hi

Thanks for the reply… The reason I went for Push btns is that i was having issues on pop up charts… Please check this post

Thanks

rajx72 (BOB member since 2006-08-02)

#4

Gotcha.

Hope it works out!

theknowtank (BOB member since 2011-04-20)

#5

Hi

My original question still remains… How can I convert the data so that I can use the same data for Bar and Line chart. This is a sample data… In actual I have more data.

Thanks

rajx72 (BOB member since 2006-08-02)

#6

You should have one row for each product, and one column for each month. Then use the excel formulas along with drilldown or pushbuttons to get the data in the format you need, like the sample in Sheet 2 of what I sent.

-tkt

theknowtank (BOB member since 2011-04-20)

#7

Hi theknowtank

Thanks for the sample and the excel formula…

“You should have one row for each product, and one column for each month”

How do i convert my data into Crosstab.

Thanks

rajx72 (BOB member since 2006-08-02)

#8

That depends on your data source, and whether your number of columns is dynamic or not.

If you’re using WEBI, it’s trivial, but if you have to write a query, then may be a bit more difficult. Check ORACLE’s PIVOT functions as a start if you’re on a recent version.

-tkt

theknowtank (BOB member since 2011-04-20)