I want to put in a table which will be displayed in my ProcessBook view, some attributes values over the last 12 months (each month = a value).
But I don't know how to do it ?
Can someone help me, please ?
As I understand your question, you would like to have 12 months of data with one value per month in a table type format.
For illustration purposes, something like this:
I created an element with 12 monthly attributes:
I also have an attribute (not shown) for the source tag; for my purposes, the data is the monthly average for the source tag. Month 1 is current month to date average, month 2 is previous month average, etc... I didn't bother populating the other months, just wanted to prove the concept.
To get the monthly averages, I used an analysis - periodic, every 5 minutes just to get some data
SOM1 is the start of the current month; M1 is the tag average for the source tag from SOM1 to now.
M1 is then mapped to the attribute 'Month 1'
To get SOM2, start of the previous month, I used 'concat' to build a string, parsed the time, and then took the beginning of the derived time; today, that equates to 6/1/2019 00:00:00.
M2 is the tag average from SOM2 (start of previous month) to SOM1 (start of current month).
M1 is then mapped to the attribute 'Month 2'
etc... down to month 12.
On the display, add a text field for the first month, then add an element relative item and select the attribute 'Month 1'.
Copy/paste the text/value, and edit them to reflect month 2 and the 'Month 2' attribute.
There exist different options to represent monthly values. My recommendation is to use Asset Analytics to calculate the monthly values and to record them to PI Points. You could than build your ProcessBook display by referring the PI Points recording the aggregations.
Other options may also fit e.g. creating DataSets in ProcessBook for the monthly values. This could be a simple option if the raw data is sampled at a lower frequency. Can you indicate what kind of aggregation you like to do and at what rate the raw PI Points sample?
Thx for your answer !
Your first suggestions looks good, but I would like avoid to create a lot of PI Points, if possible.
For the second solution, I don't know how to create datasets in ProcessBook.
In fact, I have an attribute Num of start-ups, I want to track its values over 12 months and display it in ProcessBook as a table.
Not sure if you intentionally or unintentionally avoid answering my questions.
Let's see if we can collaborate on getting closer to the answers.
Can you please create a ProcessBook Display, add a Trend control and configure it to point to your Num of start-ups attribute. Please set the Plot time to 1 month as shown in below screenshot.
Now, switch to Run mode and enable the details pane (menu View -> Details). If the Details pane shows without Data Item, please click the Trend control. You should now have your Num of start-ups attribute as the selected Data Item and should see values and belonging timestamps in a table. Is this already what you are looking for?
If not, please capture a screenshot of ProcessBook, save it to file and insert it with your response.
Sorry, I don't avoid your questions.. maybe we don't understand each over well, or I don't formulate my idea Well ?
So, I tried your last suggestion, as you can see on this image, but that's not really what I'm looking for.
The problem is that the value of my attribute comes from an analysis and therefore it varies far too much (depending on the defined period). I'd like to have only one value per month.
Do you understand what I mean ?
(sorry if I don't make myself clear, I'm a PI beginner)
That's exactly what I was trying to do.
Thank you for help !
Then, I'm glad I could help
Retrieving data ...