Date wise,Name wise Status should be displayed on Bar chart

[Anonymous]

From below table we need to show Date wise, Name wise Status on Bar chart.

1 Means Present

0 Means Absent

Please suggest how to achieve it.

Date	Name	Login	Logout	Status
10/11/2017	ABC	9:30	6:30	1
10/12/2017	ABC	9:30	6:30	1
10/13/2017	ABC	-	-	0
10/14/2017	ABC	9:30	6:30	1
10/15/2017	ABC	-	-	0
10/16/2017	ABC	9:30	6:30	1
10/17/2017	ABC	9:30	6:30	1

[Anil_Babu_Samineni]

Expected result?

[prma7799]

Like this ??

If the attachment is not fulfill your requirement please share some expected output.

Thanks

[Anonymous]

I want to see on which date ABC is present and on which date ABC is absent on Bar chart.

[prma7799]

PFA...

[Anonymous]

Can you please send the steps in notepad as that qvw document will not open in my Desktop.

[prma7799]

Back end Script:

Test:

LOAD * ,

if(Status = 1 ,'Present','Absent') as NewStatus ,

date(date#(Date,'MM/DD/YYYY'),'DD-MM-YYYY') as NewDate;

LOAD * Inline [

Date, Name, Login, Logout, Status

10/11/2017, ABC, 9:30, 6:30, 1

10/12/2017, ABC, 9:30, 6:30, 1

10/13/2017, ABC, - ,- ,     0,

10/14/2017, ABC, 9:30, 6:30, 1

10/15/2017, ABC , - ,-, 0,

10/16/2017, ABC, 9:30, 6:30, 1

10/17/2017, ABC, 9:30, 6:30, 1

];

Front end :

Chart1:

Dimen: Name

Exp:

count ({<NewStatus={'Absent'}>}Status)

count ({<NewStatus={'Present'}>}Status)

Chart2:

Dimen: Date

Expre:

count (NewStatus)

Thanks.

[Anonymous]

Thank you friend.