AVEVA™ PI System™ Feedback Portal

Welcome to our feedback site!


We created this site to hear your enhancement ideas, suggestions and feedback about AVEVA products and services. All of the feedback you share here is monitored and reviewed by the AVEVA product managers.

To start, take a look at the ideas in the list below and VOTE for your favorite ideas submitted by other users. POST your own idea if it hasn’t been suggested yet. Include COMMENTS and share relevant business case details that will help our product team get more information on the suggestion. Please note that your ideas and comments are visible to all other users.


This page is for feedback specifically for AVEVA PI System. For links to our other feedback portals, please see the tab RESOURCES below.

Add a new idea Subscribe
Status Declined
Product AVEVA™ PI Server
Categories Analytics & Calculations
Created by Guest
Created on Aug 20, 2022

RELATED IDEAS

Add a function to calculate the week number of the year

In order to calculate the current shift operating at a plant, I need to calculate where in the 28-day cycle the current week is. Knowing which week of the year it is allows me to do that. Note that current PI weekday functions always count Sunday as Day 1, while some Excel functions count Monday as Day 1. It might be important to have an option to specify which day of the week is Day 1.
  • ADMIN RESPONSE
    Aug 20, 2022
    Thank you very much for sharing your feedback on the PI Server. After further evaluation, we have decided to decline this item, as we are not planning on implementing it in the near future due to other high priority items across the PI System. Thank you for your feedback, and know that we are listening and reviewing every item that gets submitted!
  • Attach files
  • Guest
    Reply
    |     Aug 20, 2022
    The ISO week number is a very useful Excel function when managing roll up summary reports and pivot table. It would be extremely useful to have the ability in PI-AF to return the ISO week number for a given timestamp.
  • esancha
    Reply
    |     Aug 20, 2022
    From my point of view it would be essential that the week number returned was that established by ISO 86001 (The first week of the year is one that contains the first Thursday of the year)
  • Guest
    Reply
    |     Aug 20, 2022
    Thank you for your comment.
  • Guest
    Reply
    |     Aug 20, 2022
    Based on this article (https://www.sqlservercentral.com/articles/a-simple-formula-to-calculate-the-iso-week-number) I wrote a simple Analytic line that will calculate the ISO week number of the current day: Int((Yearday('mon+3d')+6)/7) It works for the date range shown in the article (2009-12-24 to 2010-01-14). My recommendation would be to include this in a global "config" type element as a PI tag and calculate the ISO week number once per day and write it to the PI tag. Then that PI Tag can be referenced as an input by all other analytics that need to use it.