CODEWITHSUNDEEP
tableau-api
andreaswienes
andreaswienes

Reputation: 3551

How to count values once?

I'm using Tableau Public to analyze a dataset of job offers. One of my charts shows the count for different job titles.

Some jobs are posted in different locations, but with the same title and date.

Is there a way to count those jobs only once?

Example:

They should only be counted once, when day are posted on the same date, even if they are located in different countries.

So the total numbers should be as followed.

Java Developer: 2

Android Dev: 1

iOS Devs: 2

Any ideas on how to do this?

Upvotes: 0

Views: 242

Answers (1)

Gatik Vij
Gatik Vij

Reputation: 47

You could use LOD here, {Fixed Date: countd(Jobs)}

This will restrict the level of aggregation of the calculation.

Upvotes: 2

Related Questions