Hi James,

In order to make this happen, I've had to add a third column, in order to keep the rows separate. This is because otherwise Tableau groups the names from "Field 1" together.

I used the following table:

To replicate counting, you need to use a calculated field of "INDEX()", and then make sure this is configured correctly.

I've also attached a copy of the workbook that demonstrates it. Hopefully you can get what you are after from this.

Andrew

Hi James,

I haven't given a try but I suppose Count Distinct might help you in this case. This option is only available when you go with extract connection or else you need to write calculated field using CountD function.

Thanks,

Prem

Hi James,

Not really. The suggestion of count distinct from Prem Reddy isn't going to help - sorry.

The thing is that a calculated field that you are wanting only occurs at row level, and if the values are the same, then there will be no difference between the rows with the same names.

Countd is an aggregated function, so occurs at aggregation time. This means that all same names are grouped together, and then each group counted once. Each name will have 1 against them.

Table Calculations happen after aggregation, so you need to have something to make the aggregated table have multiple rows for each name.

If you have no other fields to make the individual rows unique, then the only thing you can do is to unaggregate the measures. (Analysis -> untick "Aggregate Measures"). You can then remove RowID and change the Incremental field to be Compute Using Cell. However, this then groups the names together, so you don't get quite the result you were asking for.

See Sheet2 in the attached workbook