Data Retrieval

[MFYDev]

Data has been retrieved, and I'll upload the file or the link here when it's the right time to do so.

I am thinking those data should not be public until they give us permission?

[kusn-odoo]

Data Structure(initial): { year:{ month:{ mrr:{ } nrr:{ }

} } }

example: { 2021: { "jan": { "mrr": {}, "nrr": {}, "total_sales": {}, "net_ent": {} } "q1": {}, "q2": {} } }

[kusn-odoo]

Overall view Data retrieved: { JAN: { actual_mrr: '6758', actual_nrr: '15880', target_mrr: '12800', target_nrr: '81600', achieve_mrr: '53%', achieve_nrr: '19%', new_ent_sold: '12' }, FEB: { actual_mrr: '8815', actual_nrr: '72025', target_mrr: '13200', target_nrr: '84150', achieve_mrr: '67%', achieve_nrr: '86%', new_ent_sold: '13' }, MAR: { actual_mrr: '7742', actual_nrr: '49860', target_mrr: '13600', target_nrr: '86700', achieve_mrr: '57%', achieve_nrr: '58%', new_ent_sold: '17' }, APR: { actual_mrr: '13676', actual_nrr: '71470', target_mrr: '14400', target_nrr: '91800', achieve_mrr: '95%', achieve_nrr: '78%', new_ent_sold: '21' }, MAY: { actual_mrr: '9814', actual_nrr: '54570', target_mrr: '15200', target_nrr: '96900', achieve_mrr: '65%', achieve_nrr: '56%', new_ent_sold: '20' }, JUN: { actual_mrr: '12297', actual_nrr: '99324', target_mrr: '15600', target_nrr: '99450', achieve_mrr: '79%', achieve_nrr: '100%', new_ent_sold: '20' }, JUL: { actual_mrr: '14072', actual_nrr: '79710', target_mrr: '16000', target_nrr: '102000', achieve_mrr: '88%', achieve_nrr: '78%', new_ent_sold: '33' }, AUG: { actual_mrr: '23386', actual_nrr: '199590', target_mrr: '16000', target_nrr: '102000', achieve_mrr: '146%', achieve_nrr: '196%', new_ent_sold: '34' }, SEP: { actual_mrr: '17767', actual_nrr: '101825', target_mrr: '17600', target_nrr: '132000', achieve_mrr: '101%', achieve_nrr: '77%', new_ent_sold: '27' }, OCT: { actual_mrr: '24082', actual_nrr: '157003', target_mrr: '24000', target_nrr: '180000', achieve_mrr: '100%', achieve_nrr: '87%', new_ent_sold: '30' }, NOV: { actual_mrr: '24641', actual_nrr: '120475', target_mrr: '24000', target_nrr: '180000', achieve_mrr: '103%', achieve_nrr: '67%', new_ent_sold: '31' }, DEC: { actual_mrr: '28868', actual_nrr: '183308', target_mrr: '28800', target_nrr: '216000', achieve_mrr: '100%', achieve_nrr: '85%', new_ent_sold: '39' }, Q1: { actual_mrr: '23316', actual_nrr: '137765', target_mrr: '39600', target_nrr: '252450', achieve_mrr: '59%', achieve_nrr: '55%', new_ent_sold: '42' }, Q2: { actual_mrr: '35786', actual_nrr: '225364', target_mrr: '45200', target_nrr: '288150', achieve_mrr: '79%', achieve_nrr: '78%', new_ent_sold: '61' }, Q3: { actual_mrr: '55225', actual_nrr: '381125', target_mrr: '49600', target_nrr: '336000', achieve_mrr: '111%', achieve_nrr: '113%', new_ent_sold: '94' }, Q4: { actual_mrr: '77591', actual_nrr: '460785', target_mrr: '76800', target_nrr: '576000', achieve_mrr: '101%', achieve_nrr: '80%', new_ent_sold: '100' }, Total: { actual_mrr: '191918', actual_nrr: '1205039', target_mrr: '211200', target_nrr: '1452600', achieve_mrr: '91%', achieve_nrr: '83%', new_ent_sold: '297' } }

[fame-odoo]

Just a quick update, the data retrieval part code is in https://github.com/kusn-odoo/sales-dashboard-backend . This repo is not public yet but the data has already been retrieved.