Please I would like to know how I can implement Rate of change Visualisations over time in Kibana. I would like to create a visualisation showing the rate of change of student enrollment on the Y axis plotted against time (Years) on the X-axis. This implies plotting individual (non aggregated values) on the Y-axis against Year values on the X-axis. Some of the rate of change values are negative as well.
When I try this however, Kibana by default tries to aggregate this values and I do not want Kibana to aggregate the values at all. I just want it to Plot these individual values against the corresponding years in question like in the graph below.
I would like Kibana if possible to generate the rate of change values from a set of values which are also in the table.
So For example the first column in the table contain enrollment years. The second column contains the enrollment figures for the corresponding years in the first column.
Now, I would like Kibana to dynamically generate the "Rate of Change of enrollment" figures for the corresponding years and then plot these dynamically generated rate of change figures against the corresponding years .
I would be grateful if anybody can help me out with a solution to this problem