Feature #407

Create an interface for populating the columns in a LineChartTool so we can have year values on the X axis.

Added by Andy Dufilie over 6 years ago. Updated about 6 years ago.

Status:ResolvedStart date:08/19/2011
Priority:UrgentDue date:
Assignee:Krithika Manohar% Done:

0%

Category:Visualization Interface
Target version:1.0
Complexity:Medium OIC Priority:
Required by:

Description

We want to be able to create a line chart where the x axis is year and the y is some data value, where the data is formatted like the obesity-cube data table.
Each row has a record ID as its key, and then two other columns determine year and some other measure.
This can be done by adding a simple GUI where you select a column and it will build a list of EquationColumns and add them to the line chart columns.
You just have to loop over all the year values in the year column and add an EquationColumn to the line chart column list for each one.

Using the obesity-cube data table example:

For this to work, the keys in the line chart would have to be fips codes, which can be gotten like fipsCol.getValueFromKey(cubeKey, IQualifiedKey) in ActionScript.

We then need a function to do a reverse-lookup (put this in in EquationColumnLib.as for now):
getKeysFromValue(column:IAttributeColumn, value:Object, dataType:*):Array
which would return a list of IQualifiedKey objects.

Then using fips keys from the line chart plotter, this equation would work:

fipsKey = getKey(),
cubeKey = getKeysFromValue(fipsCol, fipsKey, QKey)[0],
(getValueFromKey(yearCol, cubeKey) == '1995')
    ? getValueFromKey(dataCol, cubeKey, Number)
    : NaN


Related issues

Related to Weave - Feature #501: Allow a grouped bar chart to be created where each individual bar segment is a separate record Resolved 09/08/2011
Related to Weave - Bug #534: Stepping through session history in Line chart produces unexpected results if new group-by feature is used Open 09/23/2011
Duplicated by Weave - Feature #298: Ability to create a time-series line chart when from 3 data table variables (e.g., YEAR, PLACE, RATE) Resolved 08/03/2011
Blocked by Weave - Feature #408: Create a reverse lookup for getting keys corresponding to a data value. Resolved 08/19/2011

History

#1 Updated by Andy Dufilie over 6 years ago

  • Description updated (diff)

#2 Updated by Andy Dufilie over 6 years ago

  • Description updated (diff)

#3 Updated by Andy Dufilie over 6 years ago

  • Description updated (diff)

#4 Updated by Krithika Manohar over 6 years ago

  • Assignee set to Krithika Manohar

#5 Updated by Krithika Manohar about 6 years ago

  • Status changed from Open to Resolved

#6 Updated by Andy Dufilie about 6 years ago

  • Status changed from Resolved to Needs Merge

#7 Updated by Krithika Manohar about 6 years ago

  • Status changed from Needs Merge to Resolved

#8 Updated by Andy Dufilie about 6 years ago

  • Target version set to 1.0

Also available in: Atom PDF