Pivot table and grouping by # of distinct date values

[eugenm]

Hi folks,

My source data has long format and date format date values and a column called ID.
Here's a mock of the short format Date column and the ID column.

Date	ID
May 1	10
May 2	10
May 3	11
May 4	12
May 5	11
May 6	12
May 7	10

Desired output:

Count of ID	Count of Date
1	3
2	2

I would like to do this in the visual, as I am working with a ton of data. Additional processing in the original data or adding calculcated columns, etc is not a great idea. But if that's the last resort, I may consider it.

How can I solve the challenge above? It seems to be a good place for a pivot table, maybe?

Thanks in advance.

[eugenm · Accepted solution]

I will switch this to another type of example, in a new post.
Maybe that will have better luck.

Consider this thread closed. Thanks

[eugenm]

So, is there no solution for doing this?

[Sergii24]

Hi @eugenm, could you elaborate a bit more on the desired output?

Count of ID

1

2

How would you achive this? If I look at yout sample, there are 7 IDs (3 unique: 10, 11 and 12) so I can't understand where this 1 and 2 comes from?

[eugenm]

Sure. 
One ID (#10) occurs 3x.
Two ID's occur twice - they are #11 and #12.
Total= 7 unique ID's indeed.