Forum Discussion
Filter Date
Good day,
Please assist me with this formula.
I have a table showing the number of orders we create and give feedback on from our desktops and phone app. The order can be for Preventive or Corrective services
Columns are as follows;
| Order number | Create Date | Compl Date | Corr / Preven | Create Total Qty | FB Total Qty | Create App | FB App |
| 123456 | 01/05/2019 | 10/05/2019 | Corrective | 1 | 1 | 1 | 1 |
| 123567 | 01/06/2019 | 17/06/2019 | Corrective | 1 | 1 | 0 | 0 |
| 134567 | 10/04/2019 | 31/04/2019 | Preventive | 1 | 1 | 1 | 1 |
| 135698 | 15/05/2019 | 21/05/2019 | Preventive | 1 | 1 | 0 | 0 |
| 156897 | 01/06/2019 | 10/06/2019 | Preventive | 1 | 1 | 1 | 0 |
| 149637 | 15/06/2019 | 17/06/2019 | Preventive | 1 | 1 | 1 | 1 |
| 129856 | 12/07/2019 | 30/07/2019 | Preventive | 1 | 1 | 1 | 0 |
I created formulas to calculate the qty's of the Corrective and Preventive and also calculated the percentage of how many orders were created via the app. This is new in our company, that is why we are monitoring it.
The problem I am having is, we started using the app for Corrective services in April 2019 and for Preventive in June 2019.
I created this formula to calculate the App % per month and create a relationship between created and feedback date but I have to add a filter to show only the Preventive from 1st of June.
3 Replies
Hi Susan_Colyn ,
Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Hi,
I forgot to add that the data in the " trend" tab is where I would like to include the date filter.
Thank you for your help. I really appreciate it.
