Jump to content
Software FX Community

Stacked Chart and CrossTab provider


User (Legacy)
 Share

Recommended Posts

I have a data set from a SQL Database (shown below) that I am trying to 

display in strips from Start Date to End Date on a stacked chart

Transaction StartDate EndDate Percentage

100000063 2004-11-30 2014-12-02 6.250000

100000064 2004-11-30 2014-11-30 6.000000

100000065 2004-11-30 2014-11-30 12.000000

100000066 2004-11-30 2014-11-30 18.700000

100000067 2004-11-30 2014-11-30 14.000000

Using the CrossTab provider with

DataType[0] = ColumnHeading

DataType[1] = RowHeading

DataType[2] = RowHeading

DataType[3] = Value

doesn't achieve the desired results...

I have tried seperating the data above to get something like

Transaction Date Percentage

100000063 2004-11-30 6.250000

100000063 2014-12-02 6.250000

100000064 2004-11-30 6.000000

100000064 2014-11-30 6.000000

100000065 2004-11-30 12.000000

100000065 2014-11-30 12.000000

100000066 2004-11-30 18.700000

100000066 2014-11-30 18.700000

100000067 2004-11-30 14.000000

100000067 2014-11-30 14.000000

Using the CrossTab provider with

DataType[0] = ColumnHeading

DataType[1] = RowHeading

DataType[2] = Value

doesn't achieve the desired results... I have tried ordering by column 1, 2

or 3 with mixed (incorrect) results

Any help appreciated

Thanks

John

Link to comment
Share on other sites

  • 2 weeks later...

The Crosstab Provider in Chart FX Client Server 5.1 doesn't support 

IniValues, so you will not be able to use it to plot data between two points

(this functionality is available in the 6.2 version, though). In any case,

it's important to mention the way the columns are handled in the Crosstab

provider:

The values in the column identified as Column Heading will be translated

into Series of the chart.

The values in the column(s) identified as Row Heading will be translated

into Points of the chart.

The values in the column identified as Value will be plotted in the Y axis.

On the other hand, the Crosstab provider requires the dataset to be sorted

by the column identified as Row Heading.

With that said, if you pass the data in your second data sample, correctly

sorted, you will get a chart with three points (2004-11-30, 2014-11-30 and

2014-12-02) and 5 series (100000063, 100000064, 100000065, 100000066 and

100000067).

---

IG

Software FX

"John Parker" <john.parker@granvilleassociates.co.uk> wrote in message

news:FIN3qlFCFHA.388@webserver3.softwarefx.com...

>I have a data set from a SQL Database (shown below) that I am trying to

>display in strips from Start Date to End Date on a stacked chart

>

> Transaction StartDate EndDate Percentage

> 100000063 2004-11-30 2014-12-02 6.250000

> 100000064 2004-11-30 2014-11-30 6.000000

> 100000065 2004-11-30 2014-11-30 12.000000

> 100000066 2004-11-30 2014-11-30 18.700000

> 100000067 2004-11-30 2014-11-30 14.000000

>

>

> Using the CrossTab provider with

> DataType[0] = ColumnHeading

> DataType[1] = RowHeading

> DataType[2] = RowHeading

> DataType[3] = Value

>

> doesn't achieve the desired results...

>

> I have tried seperating the data above to get something like

>

> Transaction Date Percentage

> 100000063 2004-11-30 6.250000

> 100000063 2014-12-02 6.250000

> 100000064 2004-11-30 6.000000

> 100000064 2014-11-30 6.000000

> 100000065 2004-11-30 12.000000

> 100000065 2014-11-30 12.000000

> 100000066 2004-11-30 18.700000

> 100000066 2014-11-30 18.700000

> 100000067 2004-11-30 14.000000

> 100000067 2014-11-30 14.000000

>

> Using the CrossTab provider with

> DataType[0] = ColumnHeading

> DataType[1] = RowHeading

> DataType[2] = Value

>

> doesn't achieve the desired results... I have tried ordering by column 1,

> 2 or 3 with mixed (incorrect) results

>

> Any help appreciated

>

>

> Thanks

> John

>

>

>

>

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...