How To Trend Calculated Values in WinCC SCADA V8

[@viesuliss12]

Hello, WinCC Guru! Have you ever worked with pulling data from the Data Logging database, either using C-Script or some other method? I'm asking because I want to create a small program that can retrieve a specific tag's value based on a given date.

[@WinCCGURU]

yes, you can use VBScript with the OLEDB provider to retrieve tag logging data from the archive.

[@WinCCGURU]

Members of this channel can download the WinCC V8 version of the example project.

[@huseyingoze1373]

Hello Sir! firstly, thank you so much for your amazing videos :) I would like to ask about it is same for Calculated to Analog Values in Main Screen ? do you have any videos or document about that ?

[@WinCCGURU]

You can use dynamic dialog or scripting to show calculated values on a screen.

[@NasirMehmood-yt7nw]

sir, Bob thanks you very much,🙂

[@WinCCGURU]

You are very welcome. Hope it helped.

[@NasirMehmood-yt7nw]

Sir, I have received a lot of help. I will send you the video and images. Thank you very much

[@sinanartemis6176]

great job keep doing

[@WinCCGURU]

Will do. Been putting a lot of time into the class

[@mo.eshghali]

Hi Could you please make video for long term archiving in wincc comfort panel?

[@WinCCGURU]

Hi sir. I don’t have a comfort panel here. I am going to load Unified V19 and maybe I can simulate it …

[@rodrigobaliosian5370]

Hi Guru, I have a question about WinCC Trends. Can I dynamize the different y-axes depending on the tags to graph that are selected from the list? Because I have many variables of different magnitudes and I want to be able to view the axes if only the tags are selected. Thanks you

[@WinCCGURU]

Yes, you can create multiple value axes on a Trend Control with different value ranges and assign the value trends to the the relevant value axis. Just click on the Value Axis tab, add a new axis, set the value range and give it a name. Then on the Trends tab, add trends to the relevant value axis.

[@rodrigobaliosian5370]

@@WinCCGURU I create differents axes and I assign the tags to my axes but, I want to be able to dynamize the visulization of the 'y' axes depending on the tag I select corresponding to the axis. For example, in the same trend I have tags of pressure, temperature, current, level, etc. and I want to hide the axes if the pressure tags are not selected, and the same with tags of temperature, current, etc.

[@WinCCGURU]

Ah, OK. You have full access to the properties of the Trend Window via VBS Script, so you may be able to do what you want in a VBS Script. Please see this video: kzbin.info/www/bejne/j5zLiJppZ9ilfsk it shows how to programmatically define the trend window attributes. This particular script is assigning tags to trends and colors, etc, but you will get the idea. Please take a look.

[@rodrigobaliosian5370]

@@WinCCGURU Thanks you for the answer, I will watch the video. Lastly, where would be the correct place to put the VBS script? In which event would it be best? Considering that, based on what I want to do, it should update when selecting or deselecting tags.

[@WinCCGURU]

@@rodrigobaliosian5370 in WinCC, anytime an object property changes, it generates an event which can be used to trigger a script or action. If you look on the events tab of the trend control , under Object Events, you will see a lot of events you can probably use to detect when a trend is selected. My advice is to put an HMIRuntime.Trace statement on each and print out the event name, then go to runtime and add trends, and see which event triggers. that's where you put the script.