'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 |
---|