Spark lines

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.

Back to Exploring

trudain.com | All content copyright (c) 2022-2024