How to Calculate the In-service% vs Out-of-service% of an equipment in an year, using bar chart?

[#1]

Hi,

I have an employee's Work Calendar,

example

Equipment#	Service Start Date	Service End Date
00001	29/01/15	30/05/15
00001	24/07/15	29/11/15
00001	02/05/14	12/10/14

Now, Want to create a bar chat(similar to below image) for In-Service% Vs Out-Of-service% across the year    

Kindly help on this

[marcus_sommer]

I think you will need to create the missing data and link them per intervalmatch to a master-calendar:

Generating Missing Data In QlikView

IntervalMatch

How to use - Master-Calendar and Date-Values

- Marcus

[brunobertels]

Hi

May be this

% Start :

count("Service Start Date") /  ( count("Service Start Date") + count("Service End Date") )

% End

count("Service End Date") /  ( count("Service Start Date") + count("Service End Date") )

in your graph :

Dimension YEARS

MESURES :

% Start

% End

select stacked option in graph panel

Hope it helps