Skip to Content

Data Range for Dashboards

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 08, 2011 at 01:52 AM

    General recommendation is to reduce the complication on the Excel side of the dashboard and use as many as queries possible to get the data in the way you want that could be directly mapped to the Dashboard components.

    I recommend you to perform the sorting in the Query Panel and get the data as close as possible that could be directly used. If you want to get one result set and work around with it, try to break this data by internal reference to other cells that can be mapped with components.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2011 at 09:41 AM

    use pivot table concept in excel it will automate your process

    If this is not the correct answer,Please explain me in detail and show how data coming and data how you arranged.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Ashish K

      Hi

      Make data range maximum (recommended 512 rows) and use ignore blank cell option

      Ignore blank cell option is available for most of the components in xcelsius in Behavior tab

      then no need to worry how many records will come and sit in excel of xcelsius

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.