Count issue with a filter

[shyamcharan]

Hi Experts,

I have a scenario as show below

MasterID	InitiationID	ResponseID	TransportID	InitiationRowID	Destination	ResponseCount	TransportCount	InitiationCount
M1	I1	A1		1		1	0	1
M2	I1	A2	R1	2	Dest1	1	1

In the above data:

responses = 2

Transports = 1

Initiations = 1

For 2 responses out of which one was transported and only one reached the destination Dest1, there is one Initiation associated with it.

So my requirement is when I select a 'Dest1' in the filters, I want the result as :

responses = 2

Transports = 1

Initiations = 1

This is because the user want to see Initiations as 1,  though only one response has a transport with a destination.

Also, I have to use the InitiationCount.

However, I get as below(with Dest1 as filter):

responses = 1

Transports = 1

Initiations = 0

Please find the attached sample QVW.

Thanks in advance.

Regards,

Shyam.

[shyamcharan]

Hi Vineeth,

Sorry for the delayed response.

I really appreciate your replies. Great work.

Thanks heaps.

I am trying to resolve this at the Data Model level. Currently the Incident count is associated with MasterID but not with InitiationID.

I am thinking to change the DM design to have tables as in the attached QVW.

Please suggest if I did anything wrong.

Thanks in advance.

Regards,

Shyam.

[vinieme12]

I will check and get back to you

[shyamcharan]

Thanks Vineeth

[vinieme12]

All of your Relational tables are Many to One or ONe to ONe

You can consolidate all of it in one single Master table no need to keep them in separate tables

Master

Left Join(Master)

Response

LeftJOin(Master)

Transport

Left Join(Master)

Bridgetable

Left JOin (Master)

Initiation