0.00.0100005050NY50000YN1000100-2025/06/24 13:46:58.005-2025/06/24 13:46:58.005H4sIAAAAAAAAAAMAAAAAAAAAAAA=Ndw bi indotekniklocalhostPOSTGRESQLNativedw_bi_indoteknik5703metabaseEncrypted 2be98dfba28d7bf86853c9f58cfc4f889FORCE_IDENTIFIERS_TO_LOWERCASENFORCE_IDENTIFIERS_TO_UPPERCASENIS_CLUSTEREDNPORT_NUMBER5703PRESERVE_RESERVED_WORD_CASEYQUOTE_ALL_FIELDSNSUPPORTS_BOOLEAN_DATA_TYPEYSUPPORTS_TIMESTAMP_DATA_TYPEYUSE_POOLINGNerp indoteknik productionlocalhostPOSTGRESQLNativeerp_indoteknik5901odooEncrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3FORCE_IDENTIFIERS_TO_LOWERCASENFORCE_IDENTIFIERS_TO_UPPERCASENIS_CLUSTEREDNPORT_NUMBER5901PRESERVE_RESERVED_WORD_CASEYQUOTE_ALL_FIELDSNSUPPORTS_BOOLEAN_DATA_TYPEYSUPPORTS_TIMESTAMP_DATA_TYPEYUSE_POOLINGNTable inputIf field value is nullYIf field value is nullModified JavaScript valueYModified JavaScript valueSelect valuesYSelect valuesUpdateYTable inputTableInputY1nonedw bi indoteknikselect partner_id, round(avg(aging::numeric),2) as aging,
'https://analytic.indoteknik.com/dashboard/140-customer-aging?date=past12months&partner_id='||partner_id as url_bi
from mv_aging_customer
where invoice_date >= (now() - '365 days'::interval)
group by partner_id0NNNNIntegernormalpartner_id90Table inputpartner_id####0;-####0.,noneNY0NNNen_USAsia/BangkokNBigNumbernormalaging-1-1Table inputaging######0.0###################;-######0.0###################.noneNY0NNNen_USAsia/BangkokNStringnormalurl_bi2147483647-1Table inputurl_bi.,noneNY0NNNen_USAsia/BangkokN176112YUpdateUpdateY1noneerp indoteknik productionN100NNpublic
res_partner
partner_idid=avg_agingagingpayment_difficultyresultpayment_history_urlurl_bi304224YModified JavaScript valueScriptValueModY1noneN90Script 1var result = '';
if (aging <= 5) {
result = 'normal';
} else if (aging > 5 && aging <= 10) {
result = 'agak_sulit';
} else if (aging > 10 && aging <= 20) {
result = 'sulit';
} else {
result = 'bermasalah';
}resultresultString-1-1N496112YIf field value is nullIfNullY1noneYNNaging0N304112YSelect valuesSelectValuesY1nonepartner_idagingurl_biresultN496224YN