Hi guys,
I was wondering if you guys could help me out with a few formulas they I need to apply to saved searches, I will elaborate on the goal and how we achieve via using excel formulas:
- Difference between days - excluding weekends. Our company is a Global company which has 2 subsidiaries. The working days for 1 subsidiary is Mon-Friday and the working days for the other subsidiary is Sun-Thu. We are trying t o measure or internal KPI by difference between dates, the only thing is that in some cases we cannot exclude by default Fri & Sat and in other Sat & Sun since it is dependent on subsidiary. To over come this issue, in excel, we converted the the date into a weekday in number (Sun=1, Mon=2, Tue=3...etc.)
- Based on this conversion we used an IF formula that says the following: If the date=2(Mon) Then show the date-3, Else show Date-2 END So by thus, we are excluding weekend according to the subsidiary, I have attached an excel file as reference, please refer to 'Expected ship date VS actual db' sheet and review column 'J'
Eventually based on the entire spread sheet mentioned iinnpoint #2 we would like to present it as a PIE graph as we have in sheet: 'Expected VS actual' and to see the info in a format of percentage and not numbers Our e main goal is to try and capture this data with any available formulas that NS has to offer and present it in a graph in the home page as a Dashboard, currently we are using a saved search for the initial data and furtherdding ng columns in ex. PleaseOsee screenshots of the saved search criteria we are using. os this something we can deploy in NS as well? Thank you