Show the id's status in terms of active,inactive and both.

[Anonymous]

I have a data which contains two fields namely id and its performance date. Something like this:

I need to create a chart which shows me the status of the total count of id's getting activated, inactivated and both in a day wise manner.

Sample Output:

Here 2 id's are getting activated on 04-01-16, 1 id is getting inactive on day 7 and lastly '1 id is active - 1 id is inactive' on day 8.

I should show the differentiate the active/inactive/both id's in terms of the color's in the output.

Please provide a solution

[MarcoWedel]

Glad it's the correct result.

Can you share your current solution so we can see what bit is missing?

[Anonymous]

Hey Marco,

This is the result which i obtained. Plus I added some color format (Grey) for the days which are Saturday and Sunday. Thanks for sharing your result. It was helpful.