I have a table with more than 3 million records. I need to plot a line graph with the number of records in each year, but I only have a start date and an end date. From this I calculate the interval of years between these dates. When I do this, my table grows to over 35 million rows. I would like to keep the original number of lines, so I placed the ranges within a json in a new column, for example +----+-------+---------------------------+ | ID | IntervalYears | +----+-------+---------------------------+ | 1 | {"IntervalYears": [2010, 2011, 2012, 2013]} | | 2 | {"IntervalYears": [2012, 2013, 2014, 2015]} | +----+-------+---------------------------+ So, I would like to know if it is possible to plot these quantities per year, but using this column in json, resulting in a graph like this, for example
... View more