Oasis provides a number of means to create spark lines.
For the first example we will use a table of data as follows:
It is just a list of items with values. Item names can repeat. We can create a simple pivot of the data where the rows are the Item name and data are the Values:
Without applying a collation function, each item gets an array of values:
The table designer allows for values to be plotted as a spark line:
This results in the following:
Spark bars are also available:
For the second example we will start with data in a different format:
To create a spark line or bar we first need to collect all the items into an array. We can add a calculated column that does this. The formula used is @thisRow[2:10]
. This results in an array. In addition to creating a spark line in the table designer, we can also show the first and last values:
This post has shown how spark lines and bars can be added to a table. It has also shown how an array of data can be created and used in models and views.