6 Replies Latest reply on Mar 19, 2017 9:25 PM by Micky

    Trend visualization

    Swift

      Hi,

       

      I have two clarifications regarding the trends visualization in the process book.

       

      1.) I want to export the data from the trend to an Excel file (Not manually

      by viewing it in the Details Bar) But with just clicking a Button the trend

      should be exported to a csv File. Is there any VBA Script for it.

       

      2.) I would like to create a nested menu(Expandable List Box) for TAGs and

      by clicking on that TAG -specific trend for the selected TAG should be

      displayed in ProcessBook.

       

      It would be great if you could help me find a solution for my

      clarifications.

       

      Thanks in advance.

        • Re: Trend visualization
          gregor

          Hello Bagya,

           

          1) This functionality is already built in with PI ProcessBook.

           

          2) I have a few questions regarding your second request.

          What exactly do you need help with in that regards? Is it with filling a ListBox with PI Point names, with adding a trace to a PI Trend or something else? 

          When you say Expandable ListBox, do you have in mind to allow the creation of new PI Points?

          Configuring a Trend in PI ProcessBook is pretty simple. Do you see any issue with the Trend configuration dialog?

          Are you utilizing the Asset Framework? If so, have you looked into creating an Element Relative Display?

            • Re: Trend visualization
              Swift

              Hi Gregor,

               

              Thanks for the response. I just want to know if the below requirements can be met via process book.

              Helpless Requirements –

               

              1. I need to build an Expandable drop down list for specific tags. When I select the particular tags – then the specific tags trend should be displayed. I do not want new PI points as you mentioned in the previous post. The Element Relative display option is not working out in my case.
              2. We need to show the Actual working conditions (like ON/ OFF) of specific tags and compare with the desired working conditions. For example If PUMP’s desired condition should be ON and if PUMP is actually OFF. We need these data to be generated in Excel or Process book dynamically.
              3. I need to export all the trend values to a single Excel sheet. I created a vba script to export the data from one trend to a csv file. But the operators don’t understand the csv file and the data is only from one trend. I need to create an option to export as they require with separator (; or TAB). Is there a way to do so?
              4. The operator’s from the plant want a customized Time Range bar like in Ticket booking websites (with Calendar - from and to).  Unlike the Time range bar in Process book.
                • Re: Trend visualization
                  Eugene Lee

                  1ld734.gif

                   

                  Here is a sample for requirement 1.

                    • Re: Trend visualization
                      Micky

                      Hallo Eugen,

                       

                      The above suggested reply was helpful. I have a similar kind of problem.

                       

                      1.) Is it possible to have  combination of several tags from the same combo box in the same trend?

                       

                      2.) And also, Is it possible to select te tags from different combo box and view them in the same tren display?

                       

                      3.) Actually I need to create a nested menu of Tags .Is there an option to create a Nested menu /Expandable menu in Process book?

                       

                      please have a look at my  attached process book display.

                        • Re: Trend visualization
                          Eugene Lee

                          Hi Deepthi,

                           

                          You can modify the code to be like this.

                           

                          Private Sub comboBox1_Click()
                          ThisDisplay.Symbols.Remove "Trend1"
                          Dim t As Trend
                          Set t = ThisDisplay.Symbols.Add(pbSymbolTrend)
                          t.AddTrace ComboBox1.Value
                          t.AddTrace ComboBox2.Value
                          t.AddTrace ComboBox3.Value
                          End Sub
                          
                          
                          Private Sub ComboBox2_Click()
                          ThisDisplay.Symbols.Remove "Trend1"
                          Dim t As Trend
                          Set t = ThisDisplay.Symbols.Add(pbSymbolTrend)
                          t.AddTrace ComboBox1.Value
                          t.AddTrace ComboBox2.Value
                          t.AddTrace ComboBox3.Value
                          End Sub
                          
                          
                          Private Sub ComboBox3_Click()
                          ThisDisplay.Symbols.Remove "Trend1"
                          Dim t As Trend
                          Set t = ThisDisplay.Symbols.Add(pbSymbolTrend)
                          t.AddTrace ComboBox1.Value
                          t.AddTrace ComboBox2.Value
                          t.AddTrace ComboBox3.Value
                          End Sub
                          
                          
                          Private Sub Display_Open()
                          ComboBox1.Clear
                          ComboBox2.Clear
                          ComboBox3.Clear
                          
                          
                          ComboBox1.AddItem "cdt158"
                          ComboBox1.AddItem "cdm158"
                          ComboBox2.AddItem "cdep158"
                          ComboBox2.AddItem "sinusoidu"
                          ComboBox3.AddItem "sinusoid"
                          ComboBox3.AddItem "ba:active.1"
                          End Sub
                          

                           

                          I am not aware of any options to create a nested menu in Processbook.

                            • Re: Trend visualization
                              Micky

                              Hi Eugene

                               

                              I thank you for the code that you suggested it was very useful and it's

                              the exact idea I had.

                               

                              The problem is that the user is not able to select more than one parameter

                              at the same time. Sometimes a user wants to compare multiple parameters,

                              from one or different groups, at the same time. So, it is suggested to use

                              "Checkbox list" instead of "list" menus.  Using checkbox list,  can we

                              "Group" them to save space and have a more organized list .can we implement the parameters list

                              in one list? do we have an idea of "one grouped checkbox list" as shown in the following pic.

                               

                              I have the attached PDI file with this mail for your reference with the

                              code you suggested above.

                               

                               

                               

                              Best Regards

                              Ms. Deepthi Rajkumar

                              Graduate Student

                              Automation & IT (Master)

                              Technische Hochschule Köln(TH- Köln)

                              Email : deepthirajkumar94@gmail.com