Piweb Planner: Creating a calculated characteristic

[[Gr...]]

Hello everyone!
I have a following problem. I need to calculate how many time elasped between 10 last measurements. I need to create a chart based on this value. In my database I have a position K4 - Time (format: Data).
In Piweb Designer I can calculate this value, but only in field Text: I used following formula:
${(Qdb.Measurement(4,-1) - Qdb.Measurement(4,-10))}
and it works 😉 in Piweb Designer.
Can I calculate this value directly in Piweb Planner? or, Can I created a chart based on value calculated in Piweb Designer?

Thank you for help and stay healthly!
Grzegorz

[[La...]]

As far as I know, you can't use measurement attributes in calculated characteristics. Why not create a calculated measurement attribute?

I would have to try this out, and I'm not sure it would work so I'm just spitballing at this point.

Why not run a server job 'Modify Measurement Attribute' and if the calculated date = n. def then Calculated Date = ${(Qdb.Measurement(4,-1) - Qdb.Measurement(4,-10))}

I'm not sure how that would "array" out to other measurements though, since you're using explicitly -1 and -10. You'd have to run the job more frequently than the measurements would be incoming.

Or, you load your measurements into a report and then use the Hyperlink/action "Write measurement attributes" and have the variable in there. Then have a following action of Write Changes.

I've not tested any of these but this is where my mind goes when I think of a potential solution..

[[Gr...]]

Hi Laura,
Thanks for your interesting on my problem 🙂
What is it - calculated measurement attribute? this is a variable in Piweb Planner?
I admit that I'm a beginner in Piweb's stuff.

[[La...]]

By calculated measurement attribute, I meant, a measurement attribute that is defined by a variable, sorry. A variable which would be a calculated value..

Edit: And yes, you could try setting up a server job in Planner. Again, I don't know the syntax that you would need to use or if it's possible but this would be where I would go first.