Dynamic Series in a Stacked Columm Chart

[Neil LeiningerParticipant]

I have a list of Modules and inside each module I have a separate list of features. Some features may be the same between the modules, but not always. I’m trying to developed a stacked column chart that shows how many successful tests were run for each feature. So my data would like the following.

[
{
“ModuleName”: “Accounting”,
“ModuleCode”: “ACC”,
“FeatureName”: “Activate Accounting”,
“TestsPassed”: 8,
“TestsFailed”: 0
},
{
“ModuleName”: “API 560”,
“ModuleCode”: “560”,
“FeatureName”: “Analyze – API 560”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “API 560”,
“ModuleCode”: “560”,
“FeatureName”: “API 560 Input Data”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “API 560”,
“ModuleCode”: “560”,
“FeatureName”: “Open”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “API 610”,
“ModuleCode”: “610”,
“FeatureName”: “Analyze – API 610”,
“TestsPassed”: 23,
“TestsFailed”: 0
},
{
“ModuleName”: “API 610”,
“ModuleCode”: “610”,
“FeatureName”: “Input Data”,
“TestsPassed”: 3,
“TestsFailed”: 0
},
{
“ModuleName”: “API 610”,
“ModuleCode”: “610”,
“FeatureName”: “New”,
“TestsPassed”: 2,
“TestsFailed”: 0
},
{
“ModuleName”: “API 610”,
“ModuleCode”: “610”,
“FeatureName”: “Open”,
“TestsPassed”: 3,
“TestsFailed”: 0
},
{
“ModuleName”: “API 610”,
“ModuleCode”: “610”,
“FeatureName”: “Save Report”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “API 610”,
“ModuleCode”: “610”,
“FeatureName”: “Select Loads Job and Load Case”,
“TestsPassed”: 2,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II Data Matrix”,
“ModuleCode”: “DAT”,
“FeatureName”: “Convert File”,
“TestsPassed”: 5,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II Folder/Installation”,
“ModuleCode”: “INS”,
“FeatureName”: “CAESAR II Configuration”,
“TestsPassed”: 2,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II ISOGEN”,
“ModuleCode”: “IGN”,
“FeatureName”: “Create Drawing”,
“TestsPassed”: 3,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II ISOGEN”,
“ModuleCode”: “IGN”,
“FeatureName”: “Edit PCF”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II ISOGEN”,
“ModuleCode”: “IGN”,
“FeatureName”: “Isometric Style Configuration”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II ISOGEN”,
“ModuleCode”: “IGN”,
“FeatureName”: “Line Number Filtering”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II ISOGEN”,
“ModuleCode”: “IGN”,
“FeatureName”: “Open”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II ISOGEN”,
“ModuleCode”: “IGN”,
“FeatureName”: “Select Existing Style”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II Main”,
“ModuleCode”: “C2M”,
“FeatureName”: “CAESAR II Configuration”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II Main”,
“ModuleCode”: “C2M”,
“FeatureName”: “Convert Input to New Units”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II Main”,
“ModuleCode”: “C2M”,
“FeatureName”: “Data Export Wizard Interface”,
“TestsPassed”: 2,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II Main”,
“ModuleCode”: “C2M”,
“FeatureName”: “Exit”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II Main”,
“ModuleCode”: “C2M”,
“FeatureName”: “Language”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II Main”,
“ModuleCode”: “C2M”,
“FeatureName”: “Open”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II Main”,
“ModuleCode”: “C2M”,
“FeatureName”: “Piping Input”,
“TestsPassed”: 3,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II Main”,
“ModuleCode”: “C2M”,
“FeatureName”: “QA Certificate”,
“TestsPassed”: 6,
“TestsFailed”: 0
},
{
“ModuleName”: “CAESAR II Neutral File”,
“ModuleCode”: “CII”,
“FeatureName”: “Convert File”,
“TestsPassed”: 2,
“TestsFailed”: 0
},
{
“ModuleName”: “Convert Input to New Units”,
“ModuleCode”: “CVU”,
“FeatureName”: “Convert File”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Data Export Wizard”,
“ModuleCode”: “DEX”,
“FeatureName”: “Generate Output”,
“TestsPassed”: 33,
“TestsFailed”: 0
},
{
“ModuleName”: “Dynamic Animation”,
“ModuleCode”: “DYA”,
“FeatureName”: “Show Motion”,
“TestsPassed”: 8,
“TestsFailed”: 0
},
{
“ModuleName”: “Dynamic Input”,
“ModuleCode”: “DYL”,
“FeatureName”: “Add Entry”,
“TestsPassed”: 4,
“TestsFailed”: 0
},
{
“ModuleName”: “Dynamic Input”,
“ModuleCode”: “DYL”,
“FeatureName”: “DLF Spectrum Generator”,
“TestsPassed”: 9,
“TestsFailed”: 0
},
{
“ModuleName”: “Dynamic Input”,
“ModuleCode”: “DYL”,
“FeatureName”: “Dynamic Output Processor”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Dynamic Output Processor”,
“ModuleCode”: “DYO”,
“FeatureName”: “Dynamic Input Report”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Dynamic Output Processor”,
“ModuleCode”: “DYO”,
“FeatureName”: “Open”,
“TestsPassed”: 7,
“TestsFailed”: 0
},
{
“ModuleName”: “Material Database”,
“ModuleCode”: “MAT”,
“FeatureName”: “Edit Material”,
“TestsPassed”: 38,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Allowable Stresses Tab”,
“TestsPassed”: 30,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Allowables List”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Batch Run”,
“TestsPassed”: 10,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Bends List”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Change Block Sequence”,
“TestsPassed”: 12,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Classic Input”,
“TestsPassed”: 41,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Coordinates List”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Elements List”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Exit”,
“TestsPassed”: 2,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Flanges List”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Global Coordinates”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Hangers List”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Insert Element”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “New”,
“TestsPassed”: 2,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Nozzle API 650 List”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Open”,
“TestsPassed”: 3,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Restraints List”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Review Error Report”,
“TestsPassed”: 4,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “SE Iso View”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Select Element”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Show Corrosion”,
“TestsPassed”: 13,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Show Diameters”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Show Node Numbers”,
“TestsPassed”: 92,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Show Pressures”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Show Temperatures”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “SIFs List”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Special Execution Parameters”,
“TestsPassed”: 2,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Start Run”,
“TestsPassed”: 2,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Static Seismic Wizard”,
“TestsPassed”: 6,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Wind/Wave List”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Piping Input”,
“ModuleCode”: “PPI”,
“FeatureName”: “Zoom Window”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Static Load Case”,
“ModuleCode”: “STL”,
“FeatureName”: “Analyze – Static”,
“TestsPassed”: 8,
“TestsFailed”: 0
},
{
“ModuleName”: “Static Load Case”,
“ModuleCode”: “STL”,
“FeatureName”: “Import Load Cases”,
“TestsPassed”: 6,
“TestsFailed”: 0
},
{
“ModuleName”: “Static Load Case”,
“ModuleCode”: “STL”,
“FeatureName”: “Recommend Load Cases”,
“TestsPassed”: 10,
“TestsFailed”: 0
},
{
“ModuleName”: “Static Output Processor”,
“ModuleCode”: “STO”,
“FeatureName”: “Add New Custom Report Template”,
“TestsPassed”: 20,
“TestsFailed”: 0
},
{
“ModuleName”: “Static Output Processor”,
“ModuleCode”: “STO”,
“FeatureName”: “Add Report”,
“TestsPassed”: 4,
“TestsFailed”: 0
},
{
“ModuleName”: “Static Output Processor”,
“ModuleCode”: “STO”,
“FeatureName”: “Miscellaneous Data Options”,
“TestsPassed”: 10,
“TestsFailed”: 0
},
{
“ModuleName”: “Static Output Processor”,
“ModuleCode”: “STO”,
“FeatureName”: “Restraint Summary Extended Report”,
“TestsPassed”: 2,
“TestsFailed”: 0
},
{
“ModuleName”: “Structural Steel Input”,
“ModuleCode”: “SSI”,
“FeatureName”: “Start Run”,
“TestsPassed”: 1,
“TestsFailed”: 0
},
{
“ModuleName”: “Underground”,
“ModuleCode”: “UGR”,
“FeatureName”: “Buried Pipe Data”,
“TestsPassed”: 54,
“TestsFailed”: 0
},
{
“ModuleName”: “Underground”,
“ModuleCode”: “UGR”,
“FeatureName”: “Convert Input”,
“TestsPassed”: 11,
“TestsFailed”: 0
},
{
“ModuleName”: “Underground”,
“ModuleCode”: “UGR”,
“FeatureName”: “Open”,
“TestsPassed”: 16,
“TestsFailed”: 0
}
]

How would I automate the creation of the Series Groups and Series?

[HristoParticipant]

Hello Neil Leininger,

I would like to suggest you look at this example.
You could use this approach to extract the data and organize it.
Also, please, take a look at this demo:
https://www.jqwidgets.com/jquery-widgets-demo/demos/jqxchart/javascript_chart_stacked_column_series.htm?light
If this does not help you or if you have some troubles with the mentioned example please, let me know.

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[Author]

Posts