complex Multi-Value filtering on data

[shyamcharan]

Hi Experts,

I have data as shown below

Month	ID	Driver	Incident Flag
Feb 19	1	E	1
Feb 19	1	B	0
Feb 19	1	C	0
Feb 19	2	B	1
Feb 19	2	C	0
Feb 19	3	E	0
Feb 19	3	C	1
Feb 19	4	E	0
Feb 19	4	B	1
Feb 19	5	E	1
Feb 19	6	B	1
Feb 19	6	C	1

I want to filter the data so that I see all the ID's that involve 'E' Driver and has the Incident Flag as 1.

The result from the above data should be

Month	Incidents
Feb-19	4

I appreciate your help on this. Thanks in advance.

[anushree1]

I do not see Month Field in the input Data

[kishorj1982]

You can filter data in script,

Like

load

* 

from tablename where  Driver='E' and Incident Flag='1'

or expression level also you can handle this

thanks

[shyamcharan]

Sorry, I have updated my data table now.

[shyamcharan]

Thank you for your reply.

Could you please help me providing the expression formula to handle this.

If you could have sample dashboard created that would be great. Thanks in advance.

[shyamcharan]

Thank you for your reply.

Could you please help me providing the expression formula to handle this.

If you could have sample dashboard created that would be great. Thanks in advance.