Skip to Content
0
Dec 07, 2011 at 07:32 PM

Data Range for Dashboards

34 Views

Hello Forum

Am quite new to Xcelcius and have been assigned a task to create a DASHboard that would display the KPI's in the form of a line chart based on the data of an Excel file.

Based on the business we have four major product groups on which the management is expecting to see the turnover across the months in a cal year.

Now we gathered all relevant data in excel file in the following format :

Product Group Calmonth Turnover Profit

For four product across the year we had 48 data records in file which became the base of our line chart.

While preparing charts we defined four series in chart that represents each product group and determined the transaction value against each series in excel file manually after sorting data records based on Product group and Calmonth.

This manual selection of data ranges for a series worked fine.

Thus based on above fact the thing that wonders me is do we have to manually select the data range and sort the data according to the characters everytime as it was ok to do it for 48 records but how to control this if we integrate Xcelcius with BPC datasource or any XML file.

Can anyone please guide if there is any way to dynamically define the data range for series or if I am missing any basic thing while defining data ranges for a particular series ?

Thanks

Ashish