I have the following table:
Id Service Start Stop
12 Mobile Jan May
13 TV Feb Sep
what I want to do is reshape for a line chart to have counts of accounts for active services:
id date service
12 feb mobile
12 march mobile
12 Apr mobile
12 May mobile
13 Feb tv
etc…