Requirements: two broken lines with millions of data differences are displayed on the same Y axis

1. Realize the display of two line charts on the unified Y axis, one of which represents millions of data, the other represents thousands or even dozens of data. If you use the log type, although the two curves can be displayed, the two curves will be similar to a straight line, and the fluctuation is not obvious
2. Want to do this by using the Y axis interrupt, but the interrupt effect is as follows:

.

is there a good way for the great gods?

Apr.09,2021

I'm not sure about the drawing framework you use. But it's impossible to guess mathematically.

A random fluctuation of millions of data exceeds the diameter of another, which is bound to lead to one of the approximate straight lines.

consider using double Y axes, similar to rainfall diagram in Echarts

.

converts the Y-axis raw data of two lines to the same unit, such as the percentage of fluctuation.

for example, suppose the Y-axis raw data of two lines are

, respectively.
  y1=[1000, 900, 1100]
  y2=[  10,   8,   15]

percentage of fluctuation converted to first place

  y1=[   1, -0.1,  0.1]
  y2=[   1, -0.2,  0.5]

of course, there are other ways, depending on your specific needs.


is there a correlation between these two data? There is no reason why you should put
in the same picture. Consider taking the logarithm
http://www.echartsjs.com/opti.

.
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e488f7-44cbb.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e488f7-44cbb.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?