Combine Date Fields

[#1]

Hello,

I have 3 date fields, Submitted Date, Approval Date, and Terminated Date. I have 3 columns in my table:

Count (Submitted Date)

Count (Approval Date)

Count (Terminated Date)

I would like to know if it is possible to have 1 date field that, I can filter by, that would affect all 3.

For example if I choose 01/01/2016 on my new field it would filter the 3 dates for my table. I provided a screenshot of my table and the Date fields.

The current behavior is that if I change my Approval Date to 01/01/2016 it filters my Total Approved column perfectly but not the others.

Thank you,

Ismael

[swuehl]

You can do this using a

Canonical Date