...
Allow using Sparkline chart in a table to better illustrate trends. It should be possible to add this feature to particular list items in rows or columns of the table.
Sub User Stories
The function should be available both for fixed templates and free format reports.
...
Step
...
Title
...
Wireframe
...
Notes
...
"Item Type" list setting
...
...
- List setting "Item Type" should be moved from the tab "Display" to the tab "Data" and put right after the tab "Item Label"
- When you add new item, item type "Data" should be automatically selected.
- If you double click on item type "Data", "Item type" selector is appeared. You can select different item types: Empty/ Label Only, Data, Comment, Subtotal, Microchart.
...
Setting up a Sparline (Microchart)
- When you select "Microchart" item type,"Microchart Settings" popup is appeared.
- Only one type of Microcharts - Sparkline chart - will be implemented for now. In the popup we should show information about chart type. Later we want to expand the library of Microcharts. It will be possible to set different types of Microcharts.
- There is a selector for scale types of Sparklines in the popup. You can select between two types: Individual Series and Entire Series.
- In the popup you can set "Category Axis List" by pressing the button "Set List".
- When you press the button "Set List", the popup of list selection is appeared.
...
- There is a selector for scale types of Sparklines in the popup. You can adjust to data based on: individual lines and all lines
- If you select "Individual Lines", the scale begins with the lowest value of the sparkline at the bottom and ends at the highest value at the top.
- If you select "All lines", the scale begins with the lowest value and ends with the highest value of the entire series. If you can drill the row, children are not taken into account in the calculation of scale of the first level of dimensions. The scale of children's sparklinesbegins with the lowest value and ends with the highest value only of the entire series of children's sparklines.
...
...
- After you have selected the list, the name of the list is shown in the popup.
- "Save" button becomes active.
...
...
Maintenance on Microcharts
- New list setting "Height" should be implemented. It should be put in the tab "Format" after list setting "Width".
- When Sparkline charts are present the height and the width of the cell should be expanded by default (height - 30px, width - 100 px) in order to show them correctly.
- It should be possible for user to set "Height" and "Width" for the column with Sparkline charts (not only) by himself.
It should be possible to set height property for dynamic list too. We need to implement new list rule "Set Height".
- If Sparkline charts are all removed the height and the width of the row should be resized to the standard height.
- Height can contain only numerical values - number of pixels
...
...
- After you have added Sparkline charts to the table, it should be possible to edit it's settings. If you double click on item type "Microchart", "Item Type" selector is appeared. There one more row is appeared: "Edit Microchart Settings ...". If you click it, "Microchart Settings" popup is appeared.
...
...
- If Category Axis List is not set for Microchart, "Save" button is not active.
- The error message "One list is required" will be shown in the "Microchart Settings" popup.
...
...
...
- If a format associated with an item has specific settings for charts, precision and/or scale, those settings have to be taken into account.
- By default Microcharts have the same format settings as normal charts.
...
...
- In the resulting reports the list item will be ignored.
- When the list is shown in the Content Panel in a context of not-supported control, a warning will be displayed for each microchart item in the list (if any). Message = "Microchart is displayed only in Multi-Column template and Table free format control for rows or columns".
...
...