7 Replies Latest reply on Oct 3, 2018 10:26 AM by venkatram

# Count for 2 different dates, 1 reference date

Hi all,

I'm trying to use column A as date reference and with that do a count for each day, but also check column B.

for example for day 14/09/2018 column A will appear 12 entries but should also be able to count column B with 25 entries. all of this in the same graph.

I'm only being able to show on the same graph the count of column B which have equal date to column A, which is the reference date. but should show 12 entries for A and the 25 for B, and not 12 entries for A and also 12 entries for B.

Can anyone try to explain me, if it is possible to do this?

 A B 13/09/2018 14/09/2018 13/09/2018 14/09/2018 13/09/2018 14/09/2018 13/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 14/09/2018 15/09/2018 14/09/2018 15/09/2018 14/09/2018 15/09/2018 14/09/2018 15/09/2018 14/09/2018 15/09/2018 14/09/2018 15/09/2018 14/09/2018 16/09/2018 14/09/2018 16/09/2018 14/09/2018 21/09/2018 14/09/2018

MP

• ###### 1. Re: Count for 2 different dates, 1 reference date

Hi,

You need to transform your data structure to get the dates in one field. You can use pivot option to transpose your fields like this

Once done then go to worksheet and drag field like this

Let us know if this help.

Mahfooj

• ###### 2. Re: Count for 2 different dates, 1 reference date

Hi @MAHFOOJ KHAN,

Thanks for you help right away. Unfortunately, i'm not able to convert data structure to a pivot. I forgot to mention that.

Data structure is handle to me, and i cannot manipulate.

Do you remember something else?

• ###### 3. Re: Count for 2 different dates, 1 reference date

Step-01:

Step-02:

Step-03:

Step-04:

• ###### 5. Re: Count for 2 different dates, 1 reference date

Thanks for the tip!!!

Best Regards

MP

• ###### 6. Re: Count for 2 different dates, 1 reference date

Hi @Venkatram,

Thanks for you clear explanation was very useful.

Best Regards,

MP

• ###### 7. Re: Count for 2 different dates, 1 reference date

Hey Miguel,