# Fluctuating value displayed on vision power table in Time column

**URL:** <https://forum.inductiveautomation.com/t/fluctuating-value-displayed-on-vision-power-table-in-time-column/69336>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [February 2, 2023, 12:42pm UTC](https://forum.inductiveautomation.com/t/fluctuating-value-displayed-on-vision-power-table-in-time-column/69336 "2023-02-02T12:42:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![aditi.misra](https://avatars.discourse-cdn.com/v4/letter/a/e9a140/32.png) [@aditi.misra](https://forum.inductiveautomation.com/u/aditi.misra)\
**Post date:** [February 2, 2023, 12:42pm UTC](https://forum.inductiveautomation.com/t/fluctuating-value-displayed-on-vision-power-table-in-time-column/69336/1 "2023-02-02T12:42:03Z")

</div>

Hi ,  
I am using the below script on vision Power table to display the value of seconds in the format DD HH MM SS . The script is a timer script and is running every 5 seconds .For some reason it is alternating between both the retuned outputs every 5 seconds . Attaching the code below .

```auto
def convertSecondsToDHMS(secs):
    days = int(secs / (24 * 3600))
    secs = secs % (24 * 3600)
    hour = int(secs / 3600)
    secs %= 3600
    minutes = int(secs / 60)
    secs %= 60
    seconds = int(secs)
    if days <= 0:
        return str(hour) + ':' + str(minutes) + ':' + str(seconds)
    else:
        return str(days) + ' days ' + str(hour) + ':' + str(minutes) + ':' + str(seconds)
    
tagNamePathsList = []
tagNameValuesList = []

#tagNamePathsList.append('[default]ML/Area/Braiding/CompletionTime/CompletionTime C9')
tagNamePathsList.append('[default]ML/Area/Braiding/CompletionTime/CompletionTime D9')
tagNamePathsList.append('[default]ML/Area/Braiding/CompletionTime/CompletionTime E7')
tagNamePathsList.append('[default]ML/Area/Braiding/CompletionTime/CompletionTime E8')
tagNamePathsList.append('[default]ML/Area/Braiding/CompletionTime/CompletionTime G2')

valuesName= system.tag.readBlocking(tagNamePathsList)

for index in range(len(tagNamePathsList)):
	valueName=tagNamePathsList[index][-2:]
	tagNameValuesList.append(valueName)
	
namesDS=system.dataset.toDataSet(['Machine Name'],[[x] for x in tagNameValuesList])

#HasFaultTags

tagHasFaultPathsList = []
tagHasFaultValuesList = []

#tagHasFaultPathsList.append('[default]ML/Area/Braiding/CompletionTime/CompletionTime C9')
tagHasFaultPathsList.append('[default]ML/Area/Braiding/CompletionTime/CompletionTime D9')
tagHasFaultPathsList.append('[default]ML/Area/Braiding/CompletionTime/CompletionTime E7')
tagHasFaultPathsList.append('[default]ML/Area/Braiding/CompletionTime/CompletionTime E8')
tagHasFaultPathsList.append('[default]ML/Area/Braiding/CompletionTime/CompletionTime G2')

valuesFault= system.tag.readBlocking(tagHasFaultPathsList)

for index in range(len(tagHasFaultPathsList)):
	valueFault=valuesFault[index].value
	tagHasFaultValuesList.append(valueFault)
	
hasFaultDS=system.dataset.toDataSet(['Faulted'],[[x] for x in tagHasFaultValuesList])

rows= zip(tagNameValuesList,tagHasFaultValuesList)

headers=['Machine Name','Time']
comboData = system.dataset.toDataSet(headers,rows)

newData=system.dataset.sort(comboData, 'Time', 0)
pyDataSet = system.dataset.toPyDataSet(newData)
dataRows = []
for row in pyDataSet:	
	formatedTime = convertSecondsToDHMS(float(row[1]))
	assetName = row[0]
	dataRows.append([assetName,formatedTime])

finalDataSet = system.dataset.toDataSet(headers,dataRows)

system.tag.writeBlocking('[default]ML/Area/Braiding/CompletionTime/CompletionTimeAll', finalDataSet)

```

![power table op](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/0/70e3c0bf29bc75613064261020eb603d329a2edd.png)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [February 2, 2023, 5:16pm UTC](https://forum.inductiveautomation.com/t/fluctuating-value-displayed-on-vision-power-table-in-time-column/69336/2 "2023-02-02T17:16:45Z")

</div>

You probably have a script and a binding 'fighting' over what value to display (or even two different scripts). Without your actual window, that's just a guess. Double check your flow of execution.
