'Normalize y-axis apache superset time series

Is it possible to normalize the y-axis data in a timeseries chart?

Given a single database table with:

data series name value date
Timing of slow report 1,000,000 Jan 1
Timing of slow report 1,100,000 Feb 1
Timing of slow report 1,600,000 Mar 1
Timing of med report 50,000 Jan 1
Timing of med report 60,000 Feb 1
Timing of med report 70,000 Mar 1
Timing of fast report 50 Jan 1
Timing of fast report 60 Feb 1
Timing of fast report 70 Mar 1

and each data series having orders of magnitude difference. It would be ideal to see if they have a common trend. But because they y-axis is not normalized each series becomes a straight line.

The idea of the graph would be to see that across many "reports" are they all trending in the same direction. This would indicate if it is a system error slowing everything down, or if it is just a few outliers than it is a specific reports problem.

I have tried the "Percentage change" and it doesn't seem to give what I want.

If this is not possible in apache-superset but is possible in another similar tool (tableau for example) that would also be worth knowing.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source