Добрый день! Как вывести итоги в таблице типа koob-table-simple.
Опция DisplayOverall приводит к ошибке
Добрый день!
Приложите пожалуйста:
- Версии компонентов LuxmsBI на вашей стороне.
- JSON-конфиг таблицы, в которой вы пробуете вывести итоги.
{
frame: {
h: 7,
w: 12,
x: 0,
y: 1,
},
display: {
headerStyle: {
color: 'rgba(68,119,170,1)',
},
},
options: [
'FullWidth',
'DisplayOverall',
],
dataSource: {
koob: 'Vertica_dwh_luxms_svc_r00_AK.DQMON_dmgd_euv_rpo',
style: {
DELIV_MR: {
title: 'МР Вручения',
},
measures: {
sum_IS_0_DAYS: {
title: '0 дней',
},
sum_IS_1_DAYS: {
title: '1 день',
},
sum_IS_2_DAYS: {
title: '2 дня',
},
sum_IS_3_DAYS: {
title: '3 дня',
},
sum_IS_4_DAYS: {
title: '4 дня',
},
sum_IS_5_DAYS: {
title: '5 дней',
},
sum_IS_6_DAYS: {
title: '6 дней',
},
sum_IS_7_DAYS: {
title: '7 дней',
},
sum_IS_8_DAYS: {
title: '8 дней',
},
sum_IS_9_DAYS: {
title: '9 дней',
},
sum_VOZVR_EUV: {
title: 'ВОЗВРАТНЫЕ ',
},
sum_IS_10_DAYS: {
title: '10 дней',
},
sum_IS_11_DAYS: {
title: '>=11 дней',
},
percent_returned: {
title: '% ВОЗВРАТНЫХ',
format: '[*100] #,00%',
},
sum_NE_VRUCH_EUV: {
title: 'НЕВРУЧЕННЫЕ',
},
PERCENT_IS_0_DAYS: {
title: '%',
format: '[*100] #,00%',
},
PERCENT_IS_1_DAYS: {
title: '%',
format: '[*100] #,00%',
},
PERCENT_IS_2_DAYS: {
title: '%',
format: '[*100] #,00%',
},
PERCENT_IS_3_DAYS: {
title: '%',
format: '[*100] #,00%',
},
PERCENT_IS_4_DAYS: {
title: '%',
format: '[*100] #,00%',
},
PERCENT_IS_5_DAYS: {
title: '%',
format: '[*100] #,00%',
},
PERCENT_IS_6_DAYS: {
title: '%',
format: '[*100] #,00%',
},
PERCENT_IS_7_DAYS: {
title: '%',
format: '[*100] #,00%',
},
PERCENT_IS_8_DAYS: {
title: '%',
format: '[*100] #,00%',
},
PERCENT_IS_9_DAYS: {
title: '%',
format: '[*100] #,00%',
},
PERCENT_IS_10_DAYS: {
title: '%',
format: '[*100] #,00%',
},
PERCENT_IS_11_DAYS: {
title: '%',
format: '[*100] #,00%',
},
percent_undelivered: {
title: '% НЕВРУЧЕННЫХ',
format: '[*100] #,00%',
},
},
},
xAxis: 'DELIV_MR',
yAxis: 'measures',
filters: {
DELIV_MR: true,
DELIV_UFPS: true,
YEAR_NCODE: true,
MONTH_NCODE: true,
DELIV_POCHTAMT: true,
DELIV_INDEX_OPER: true,
},
measures: [
'sum(IS_0_DAYS):sum_IS_0_DAYS',
'sum(IS_0_DAYS)/sum(IS_DELIV_EUV):PERCENT_IS_0_DAYS',
'sum(IS_1_DAYS):sum_IS_1_DAYS',
'(sum(IS_0_DAYS)+sum(IS_1_DAYS))/sum(IS_DELIV_EUV):PERCENT_IS_1_DAYS',
'sum(IS_2_DAYS):sum_IS_2_DAYS',
'(sum(IS_0_DAYS)+sum(IS_1_DAYS)+sum(IS_2_DAYS))/sum(IS_DELIV_EUV):PERCENT_IS_2_DAYS',
'sum(IS_3_DAYS):sum_IS_3_DAYS',
'(sum(IS_0_DAYS)+sum(IS_1_DAYS)+sum(IS_2_DAYS)+sum(IS_3_DAYS))/sum(IS_DELIV_EUV):PERCENT_IS_3_DAYS',
'sum(IS_4_DAYS):sum_IS_4_DAYS',
'(sum(IS_0_DAYS)+sum(IS_1_DAYS)+sum(IS_2_DAYS)+sum(IS_3_DAYS)+sum(IS_4_DAYS))/sum(IS_DELIV_EUV):PERCENT_IS_4_DAYS',
'sum(IS_5_DAYS):sum_IS_5_DAYS',
'(sum(IS_0_DAYS)+sum(IS_1_DAYS)+sum(IS_2_DAYS)+sum(IS_3_DAYS)+sum(IS_4_DAYS)+sum(IS_5_DAYS))/sum(IS_DELIV_EUV):PERCENT_IS_5_DAYS',
'sum(IS_6_DAYS):sum_IS_6_DAYS',
'(sum(IS_0_DAYS)+sum(IS_1_DAYS)+sum(IS_2_DAYS)+sum(IS_3_DAYS)+sum(IS_4_DAYS)+sum(IS_5_DAYS)+sum(IS_6_DAYS))/sum(IS_DELIV_EUV):PERCENT_IS_6_DAYS',
'sum(IS_7_DAYS):sum_IS_7_DAYS',
'(sum(IS_0_DAYS)+sum(IS_1_DAYS)+sum(IS_2_DAYS)+sum(IS_3_DAYS)+sum(IS_4_DAYS)+sum(IS_5_DAYS)+sum(IS_6_DAYS)+sum(IS_7_DAYS))/sum(IS_DELIV_EUV):PERCENT_IS_7_DAYS',
'sum(IS_8_DAYS):sum_IS_8_DAYS',
'(sum(IS_0_DAYS)+sum(IS_1_DAYS)+sum(IS_2_DAYS)+sum(IS_3_DAYS)+sum(IS_4_DAYS)+sum(IS_5_DAYS)+sum(IS_6_DAYS)+sum(IS_7_DAYS)+sum(IS_8_DAYS))/sum(IS_DELIV_EUV):PERCENT_IS_8_DAYS',
'sum(IS_9_DAYS):sum_IS_9_DAYS',
'(sum(IS_0_DAYS)+sum(IS_1_DAYS)+sum(IS_2_DAYS)+sum(IS_3_DAYS)+sum(IS_4_DAYS)+sum(IS_5_DAYS)+sum(IS_6_DAYS)+sum(IS_7_DAYS)+sum(IS_8_DAYS)+sum(IS_9_DAYS))/sum(IS_DELIV_EUV):PERCENT_IS_9_DAYS',
'sum(IS_10_DAYS):sum_IS_10_DAYS',
'(sum(IS_0_DAYS)+sum(IS_1_DAYS)+sum(IS_2_DAYS)+sum(IS_3_DAYS)+sum(IS_4_DAYS)+sum(IS_5_DAYS)+sum(IS_6_DAYS)+sum(IS_7_DAYS)+sum(IS_8_DAYS)+sum(IS_9_DAYS)+sum(IS_10_DAYS))/sum(IS_DELIV_EUV):PERCENT_IS_10_DAYS',
'sum(IS_11_DAYS):sum_IS_11_DAYS',
'(sum(IS_0_DAYS)+sum(IS_1_DAYS)+sum(IS_2_DAYS)+sum(IS_3_DAYS)+sum(IS_4_DAYS)+sum(IS_5_DAYS)+sum(IS_6_DAYS)+sum(IS_7_DAYS)+sum(IS_8_DAYS)+sum(IS_9_DAYS)+sum(IS_10_DAYS)+sum(IS_11_DAYS))/sum(IS_DELIV_EUV):PERCENT_IS_11_DAYS',
'sum(VOZVR_EUV):sum_VOZVR_EUV',
'sum(VOZVR_EUV)/sum(IS_ACCEPT_EUV):percent_returned',
'sum(NE_VRUCH_EUV):sum_NE_VRUCH_EUV',
'sum(NE_VRUCH_EUV)/sum(IS_ACCEPT_EUV):percent_undelivered',
],
dimensions: [
'DELIV_MR',
],
},
view_class: 'koob-table-simple',
title: 'РАСПРЕДЕЛЕНИЕ ПО СРОКАМ ЗАГРУЗКИ',
}