Phil,
I'm back with another similar issue. I can not figure out why this expression is returning <No Data>
. I've been staring at it for a couple of hours trying to get it to work with no success so, time to ask for another more knowledgeable set of eyes.
I have some custom properties on a power table in Vision, their current status looks like this:
This is the binding on summedData:
summedData binding
orderBy(
selectStar(
{Root Container.Processing Group.processingMinsTable.pivotedData},
asMap('Last 8','D','Last 24', 'D'),
asMap(
transform(
groupBy(
{Root Container.Processing Group.processingMinsTable.last8HistoricalData},
split(it()['path'],'_')[0]
),
forEach(
value(),
asList(
case(
it()[0],
'productlevel','No Product',
'caps','No Caps',
'empty','No Bottles',
'Packaging'
),
round(sum(it()[1],'value') / 60.0, 1)
)
)
)
)[it()['Occurrence']],
asMap(
transform(
groupBy(
{Root Container.Processing Group.processingMinsTable.historicalData},
split(it()['path'],'_')[0]
),
forEach(
value(),
asList(
case(
it()[0],
'productlevel','No Product',
'caps','No Caps',
'empty','No Bottles',
'Packaging'
),
round(sum(it()[1],'value') / 60.0, 1)
)
)
)
)[it()['Occurrence']],
asMap(
'No Bottles', 6,
'No Caps', 4,
'No Product', 1,
'Packaging', 5
)[it()['Occurrence']]
),
it()['Occurrence']
)
Here is sample data that can be used for the other three properties:
historicalData
"#NAMES"
"path","value","quality","timestamp"
"#TYPES"
"str","L","I","date"
"#ROWS","120"
"productlevel_at_sp","3600","192","2025-01-12 15:00:00.000"
"cap_supply","3600","192","2025-01-12 15:00:00.000"
"downstream_stop_request","3600","192","2025-01-12 15:00:00.000"
"empty_bottles_present","0","200","2025-01-12 15:00:00.000"
"empty_bottles_primied","0","192","2025-01-12 15:00:00.000"
"productlevel_at_sp","3600","192","2025-01-12 16:00:00.000"
"cap_supply","3600","192","2025-01-12 16:00:00.000"
"downstream_stop_request","3600","192","2025-01-12 16:00:00.000"
"empty_bottles_present","0","200","2025-01-12 16:00:00.000"
"empty_bottles_primied","0","192","2025-01-12 16:00:00.000"
"productlevel_at_sp","3600","192","2025-01-12 17:00:00.000"
"cap_supply","3600","192","2025-01-12 17:00:00.000"
"downstream_stop_request","3600","192","2025-01-12 17:00:00.000"
"empty_bottles_present","0","200","2025-01-12 17:00:00.000"
"empty_bottles_primied","0","192","2025-01-12 17:00:00.000"
"productlevel_at_sp","3600","192","2025-01-12 18:00:00.000"
"cap_supply","3600","192","2025-01-12 18:00:00.000"
"downstream_stop_request","3600","192","2025-01-12 18:00:00.000"
"empty_bottles_present","0","200","2025-01-12 18:00:00.000"
"empty_bottles_primied","0","192","2025-01-12 18:00:00.000"
"productlevel_at_sp","3600","192","2025-01-12 19:00:00.000"
"cap_supply","3600","192","2025-01-12 19:00:00.000"
"downstream_stop_request","3600","192","2025-01-12 19:00:00.000"
"empty_bottles_present","0","200","2025-01-12 19:00:00.000"
"empty_bottles_primied","0","192","2025-01-12 19:00:00.000"
"productlevel_at_sp","3600","192","2025-01-12 20:00:00.000"
"cap_supply","3600","192","2025-01-12 20:00:00.000"
"downstream_stop_request","3600","192","2025-01-12 20:00:00.000"
"empty_bottles_present","0","200","2025-01-12 20:00:00.000"
"empty_bottles_primied","0","192","2025-01-12 20:00:00.000"
"productlevel_at_sp","3600","192","2025-01-12 21:00:00.000"
"cap_supply","3600","192","2025-01-12 21:00:00.000"
"downstream_stop_request","3600","192","2025-01-12 21:00:00.000"
"empty_bottles_present","0","200","2025-01-12 21:00:00.000"
"empty_bottles_primied","0","192","2025-01-12 21:00:00.000"
"productlevel_at_sp","3132","192","2025-01-12 22:00:00.000"
"cap_supply","3600","192","2025-01-12 22:00:00.000"
"downstream_stop_request","3600","192","2025-01-12 22:00:00.000"
"empty_bottles_present","0","200","2025-01-12 22:00:00.000"
"empty_bottles_primied","0","192","2025-01-12 22:00:00.000"
"productlevel_at_sp","282","192","2025-01-12 23:00:00.000"
"cap_supply","889","192","2025-01-12 23:00:00.000"
"downstream_stop_request","1384","192","2025-01-12 23:00:00.000"
"empty_bottles_present","0","200","2025-01-12 23:00:00.000"
"empty_bottles_primied","180","192","2025-01-12 23:00:00.000"
"productlevel_at_sp","605","192","2025-01-13 00:00:00.000"
"cap_supply","0","192","2025-01-13 00:00:00.000"
"downstream_stop_request","1372","192","2025-01-13 00:00:00.000"
"empty_bottles_present","0","200","2025-01-13 00:00:00.000"
"empty_bottles_primied","0","192","2025-01-13 00:00:00.000"
"productlevel_at_sp","304","192","2025-01-13 01:00:00.000"
"cap_supply","7","192","2025-01-13 01:00:00.000"
"downstream_stop_request","0","192","2025-01-13 01:00:00.000"
"empty_bottles_present","0","200","2025-01-13 01:00:00.000"
"empty_bottles_primied","0","192","2025-01-13 01:00:00.000"
"productlevel_at_sp","0","192","2025-01-13 02:00:00.000"
"cap_supply","0","192","2025-01-13 02:00:00.000"
"downstream_stop_request","0","192","2025-01-13 02:00:00.000"
"empty_bottles_present","0","200","2025-01-13 02:00:00.000"
"empty_bottles_primied","0","192","2025-01-13 02:00:00.000"
"productlevel_at_sp","0","192","2025-01-13 03:00:00.000"
"cap_supply","0","192","2025-01-13 03:00:00.000"
"downstream_stop_request","0","192","2025-01-13 03:00:00.000"
"empty_bottles_present","0","200","2025-01-13 03:00:00.000"
"empty_bottles_primied","0","192","2025-01-13 03:00:00.000"
"productlevel_at_sp","0","192","2025-01-13 04:00:00.000"
"cap_supply","0","192","2025-01-13 04:00:00.000"
"downstream_stop_request","0","192","2025-01-13 04:00:00.000"
"empty_bottles_present","0","200","2025-01-13 04:00:00.000"
"empty_bottles_primied","0","192","2025-01-13 04:00:00.000"
"productlevel_at_sp","1141","192","2025-01-13 05:00:00.000"
"cap_supply","0","192","2025-01-13 05:00:00.000"
"downstream_stop_request","0","192","2025-01-13 05:00:00.000"
"empty_bottles_present","0","200","2025-01-13 05:00:00.000"
"empty_bottles_primied","0","192","2025-01-13 05:00:00.000"
"productlevel_at_sp","3280","192","2025-01-13 06:00:00.000"
"cap_supply","0","192","2025-01-13 06:00:00.000"
"downstream_stop_request","0","192","2025-01-13 06:00:00.000"
"empty_bottles_present","0","200","2025-01-13 06:00:00.000"
"empty_bottles_primied","0","192","2025-01-13 06:00:00.000"
"productlevel_at_sp","3464","192","2025-01-13 07:00:00.000"
"cap_supply","0","192","2025-01-13 07:00:00.000"
"downstream_stop_request","0","192","2025-01-13 07:00:00.000"
"empty_bottles_present","0","200","2025-01-13 07:00:00.000"
"empty_bottles_primied","0","192","2025-01-13 07:00:00.000"
"productlevel_at_sp","1640","192","2025-01-13 08:00:00.000"
"cap_supply","0","192","2025-01-13 08:00:00.000"
"downstream_stop_request","565","192","2025-01-13 08:00:00.000"
"empty_bottles_present","0","200","2025-01-13 08:00:00.000"
"empty_bottles_primied","0","192","2025-01-13 08:00:00.000"
"productlevel_at_sp","229","200","2025-01-13 09:00:00.000"
"cap_supply","0","192","2025-01-13 09:00:00.000"
"downstream_stop_request","907","192","2025-01-13 09:00:00.000"
"empty_bottles_present","0","200","2025-01-13 09:00:00.000"
"empty_bottles_primied","348","192","2025-01-13 09:00:00.000"
"productlevel_at_sp","0","200","2025-01-13 10:00:00.000"
"cap_supply","761","200","2025-01-13 10:00:00.000"
"downstream_stop_request","611","192","2025-01-13 10:00:00.000"
"empty_bottles_present","0","200","2025-01-13 10:00:00.000"
"empty_bottles_primied","58","192","2025-01-13 10:00:00.000"
"productlevel_at_sp","0","200","2025-01-13 11:00:00.000"
"cap_supply","0","200","2025-01-13 11:00:00.000"
"downstream_stop_request","468","192","2025-01-13 11:00:00.000"
"empty_bottles_present","0","200","2025-01-13 11:00:00.000"
"empty_bottles_primied","155","192","2025-01-13 11:00:00.000"
"productlevel_at_sp","0","200","2025-01-13 12:00:00.000"
"cap_supply","0","200","2025-01-13 12:00:00.000"
"downstream_stop_request","0","192","2025-01-13 12:00:00.000"
"empty_bottles_present","0","200","2025-01-13 12:00:00.000"
"empty_bottles_primied","101","192","2025-01-13 12:00:00.000"
"productlevel_at_sp","0","200","2025-01-13 13:00:00.000"
"cap_supply","0","200","2025-01-13 13:00:00.000"
"downstream_stop_request","515","200","2025-01-13 13:00:00.000"
"empty_bottles_present","0","200","2025-01-13 13:00:00.000"
"empty_bottles_primied","151","200","2025-01-13 13:00:00.000"
"productlevel_at_sp","0","200","2025-01-13 14:00:00.000"
"cap_supply","0","200","2025-01-13 14:00:00.000"
"downstream_stop_request","0","200","2025-01-13 14:00:00.000"
"empty_bottles_present","0","200","2025-01-13 14:00:00.000"
"empty_bottles_primied","0","200","2025-01-13 14:00:00.000"
last8historicalData
"#NAMES"
"path","value","quality","timestamp"
"#TYPES"
"str","L","I","date"
"#ROWS","40"
"productlevel_at_sp","3464","192","2025-01-13 07:00:00.000"
"cap_supply","0","192","2025-01-13 07:00:00.000"
"downstream_stop_request","0","192","2025-01-13 07:00:00.000"
"empty_bottles_present","0","200","2025-01-13 07:00:00.000"
"empty_bottles_primied","0","192","2025-01-13 07:00:00.000"
"productlevel_at_sp","1640","192","2025-01-13 08:00:00.000"
"cap_supply","0","192","2025-01-13 08:00:00.000"
"downstream_stop_request","565","192","2025-01-13 08:00:00.000"
"empty_bottles_present","0","200","2025-01-13 08:00:00.000"
"empty_bottles_primied","0","192","2025-01-13 08:00:00.000"
"productlevel_at_sp","229","200","2025-01-13 09:00:00.000"
"cap_supply","0","192","2025-01-13 09:00:00.000"
"downstream_stop_request","907","192","2025-01-13 09:00:00.000"
"empty_bottles_present","0","200","2025-01-13 09:00:00.000"
"empty_bottles_primied","348","192","2025-01-13 09:00:00.000"
"productlevel_at_sp","0","200","2025-01-13 10:00:00.000"
"cap_supply","761","200","2025-01-13 10:00:00.000"
"downstream_stop_request","611","192","2025-01-13 10:00:00.000"
"empty_bottles_present","0","200","2025-01-13 10:00:00.000"
"empty_bottles_primied","58","192","2025-01-13 10:00:00.000"
"productlevel_at_sp","0","200","2025-01-13 11:00:00.000"
"cap_supply","0","200","2025-01-13 11:00:00.000"
"downstream_stop_request","468","192","2025-01-13 11:00:00.000"
"empty_bottles_present","0","200","2025-01-13 11:00:00.000"
"empty_bottles_primied","155","192","2025-01-13 11:00:00.000"
"productlevel_at_sp","0","200","2025-01-13 12:00:00.000"
"cap_supply","0","200","2025-01-13 12:00:00.000"
"downstream_stop_request","0","192","2025-01-13 12:00:00.000"
"empty_bottles_present","0","200","2025-01-13 12:00:00.000"
"empty_bottles_primied","101","192","2025-01-13 12:00:00.000"
"productlevel_at_sp","0","200","2025-01-13 13:00:00.000"
"cap_supply","0","200","2025-01-13 13:00:00.000"
"downstream_stop_request","515","200","2025-01-13 13:00:00.000"
"empty_bottles_present","0","200","2025-01-13 13:00:00.000"
"empty_bottles_primied","151","200","2025-01-13 13:00:00.000"
"productlevel_at_sp","0","200","2025-01-13 14:00:00.000"
"cap_supply","0","200","2025-01-13 14:00:00.000"
"downstream_stop_request","0","200","2025-01-13 14:00:00.000"
"empty_bottles_present","0","200","2025-01-13 14:00:00.000"
"empty_bottles_primied","0","200","2025-01-13 14:00:00.000"
pivotedData
"#NAMES"
"Occurrence","_7A","_8A","_9A","_10A","_11A","_12P","_1P","_2P","_3P","_4P","_5P","_6P","_7P","_8P","_9P","_10P","_11P","_12A","_1A","_2A","_3A","_4A","_5A","_6A"
"#TYPES"
"str","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"
"#ROWS","4"
"No Product","0","0","0","0","7","0","0","0","0","0","0","0","0","0","45","42","43","4","0","0","0","0","0","0"
"Packaging","6","10","14","6","1","6","12","0","0","0","0","0","0","0","0","0","0","0","11","17","13","20","22","9"
"No Bottles","0","0","4","0","0","0","1","0","0","0","0","0","0","0","45","41","0","0","0","0","0","0","0","0"
"No Caps","2","1","0","2","0","0","1","60","60","60","60","60","60","60","60","60","60","11","0","0","0","0","0","2"
I have a nearly identical binding working on another table on the same window. The only differences being that there are only two columns added, they're of type double, and the sum is not divided by 60.0 to convert to mins
The only error I get is from a binding, where a columnsOf()
expression is complaining that this dataset is null, which of course it is, for whatever reason.
Any assistance is appreciated.