I have a data set similar to the following:
"_time",source,increment
"2020-02-26","third",
"2020-02-25","third","yes"
"2020-02-21","third",
"2020-02-20","third","yes"
"2020-02-29","second",
"2020-02-28","second","yes"
"2020-02-27","second","yes"
"2020-02-26","second","yes"
"2020-02-25","second","yes"
"2020-02-24","second","yes"
"2020-02-23","second","yes"
"2020-02-22","second","yes"
"2020-03-01","first",
"2020-02-29","first","yes"
I would like to make this chart with first =blue, second =red, and third =green:
So for each yes in the increment column add 1 to the current count for the source , else reset the count back to 0. If a source does not have a reset column it should continue at the current count to the end of the chart.
Is this possible?
... View more