With use of calculated item as described in the thread the calculated value does not correspond when the item does not return any value.
change("log[{#STATSFILE},"{#FWDNAME} queue:.* size=([0-9]+)",,,,\1]")+change("log[{#STATSFILE},"{#FWDNAME} queue\[DA\]:.* size=([0-9]+)",,,,\1]")
Seems the change function always return last diff, even when the values were retrieved hours before.
How to solve/workaround this situation? The requirement is to have the calculated item value corresponding to actual values with n/a substituted to value of 0.
List of values ' queue:.* size' :
List of values ' queue\[DA\]:.* size' :
Calculated values:
As you can see the calculated item still report value, even after 21:35:26, when original items stopped providing values.
change("log[{#STATSFILE},"{#FWDNAME} queue:.* size=([0-9]+)",,,,\1]")+change("log[{#STATSFILE},"{#FWDNAME} queue\[DA\]:.* size=([0-9]+)",,,,\1]")
Seems the change function always return last diff, even when the values were retrieved hours before.
How to solve/workaround this situation? The requirement is to have the calculated item value corresponding to actual values with n/a substituted to value of 0.
List of values ' queue:.* size' :
| 2018-06-28 21:35:26 | 646496 |
| 2018-06-28 21:35:14 | 609060 |
| 2018-06-28 21:35:01 | 548933 |
| 2018-06-28 21:34:43 | 490208 |
| 2018-06-28 21:34:43 | 421712 |
| 2018-06-28 21:34:43 | 362725 |
| 2018-06-28 21:33:57 | 342713 |
| 2018-06-28 21:33:45 | 292319 |
| 2018-06-28 21:33:37 | 243292 |
| 2018-06-28 21:33:12 | 223533 |
| 2018-06-28 21:32:58 | 197770 |
| 2018-06-28 21:32:43 | 186890 |
| 2018-06-28 21:32:25 | 171289 |
| 2018-06-28 21:32:15 | 141093 |
| 2018-06-28 21:31:57 | 76034 |
| 2018-06-28 21:31:57 | 14797 |
| 2018-06-28 21:31:25 | 0 |
| 2018-06-28 21:31:10 | 0 |
List of values ' queue\[DA\]:.* size' :
| 2018-06-28 21:35:26 | 0 |
| 2018-06-28 21:35:14 | 0 |
| 2018-06-28 21:35:01 | 0 |
| 2018-06-28 21:34:43 | 0 |
| 2018-06-28 21:34:43 | 0 |
| 2018-06-28 21:34:43 | 0 |
| 2018-06-28 21:33:57 | 0 |
| 2018-06-28 21:33:45 | 0 |
| 2018-06-28 21:33:37 | 0 |
| 2018-06-28 21:33:12 | 0 |
| 2018-06-28 21:32:58 | 0 |
| 2018-06-28 21:32:43 | 0 |
| 2018-06-28 21:32:25 | 0 |
| 2018-06-28 21:32:15 | 0 |
| 2018-06-28 21:31:57 | 0 |
| 2018-06-28 21:31:57 | 0 |
| 2018-06-28 21:38:23 | 40796 |
| 2018-06-28 21:38:11 | 40796 |
| 2018-06-28 21:37:56 | 40796 |
| 2018-06-28 21:37:43 | 40796 |
| 2018-06-28 21:37:26 | 40796 |
| 2018-06-28 21:37:09 | 40796 |
| 2018-06-28 21:36:59 | 40796 |
| 2018-06-28 21:36:51 | 40796 |
| 2018-06-28 21:36:25 | 40796 |
| 2018-06-28 21:35:56 | 40796 |
| 2018-06-28 21:35:38 | 40796 |
| 2018-06-28 21:35:23 | 53951 |
| 2018-06-28 21:35:15 | 56869 |
| 2018-06-28 21:35:03 | 69966 |
| 2018-06-28 21:34:43 | 49482 |
| 2018-06-28 21:34:34 | 49482 |
| 2018-06-28 21:34:19 | 49482 |
| 2018-06-28 21:34:06 | 49482 |
| 2018-06-28 21:33:38 | 34355 |
| 2018-06-28 21:33:23 | 34355 |
| 2018-06-28 21:33:14 | 34355 |
| 2018-06-28 21:32:59 | 5969 |
| 2018-06-28 21:32:44 | 27860 |
| 2018-06-28 21:32:31 | 27860 |
| 2018-06-28 21:32:13 | 61237 |
| 2018-06-28 21:31:57 | 0 |