Generic data preparation and transformation (use case: charts)

[jbostoen]

Development can be sponsored to make it a priority.

The idea is to create a generic processor which could transform iTop data into structured data ready to use in plotly.js graphs.

Data preparation

• Specify multiple levels to group by.
• Group by one attribute.
• Group by multiple attributes.
• Group by derived values (e.g. parts of a date, or string)
• Different functions should be possible. Count, min, max, avg, median, ...

Data transformation

• Some gaps need to be filled (should this be done here? Or in preparation)?: missing years, months, days, attribute values, ...
• Transform data into specific data structures for graph rendering (sunburst, bar, line, markers, ...). Open question whether it should just be able to prepare the datasets, or also contain other graph properties.

[jbostoen]

This is available privately for now / offered as a professional service.