One To Many Count

[Lionel_Maximus]

Hello Everyone,

I have two fields Username & FarmerName. There's one to many relationship(User To Farmers). Now i want to visualize the number of times a User(Username) visited a farmer with dates . How to do that??......Username has ID column too and There's a date coulmn as well.

Data Sample File Attached

Thanks

[mikaelsc]

create a counter field in both tables... 

1 AS _FarmerCounter

in farmers table

1 as _FarmerVisit

in visits table. 

sum(_FarmerCounter) for the number of farmers

sum(_FarmerVisit) for the number of visits. 

obviously, tables need to be associated (farmer ID?) ... no duplicates, no joins,... 

[JordyWegman]

Hi Lionel,

You can make a pivot table:

Dimension 1: UserName

Dimension 2: FarmerName

Measure 1: Count(FarmerName)

This way you will get the number of times a user visited a farmer.

Jordy

Climber