daily_average median q1 q3 iqr sd
471 365 200 630 430 393

This section shows weekly net revenue after subtracting transport costs, alongside a summary of transactions and liters sold.

Weekly Revenue Table
week net_revenue total_transactions liters_sold
1 410 3 41.0
2 820 8 65.0
3 2,420 16 184.0
4 2,920 17 305.0
5 2,070 15 168.0
6 1,800 15 180.0
7 1,570 13 154.0
8 3,350 27 271.0
9 2,670 24 231.0
10 4,850 39 393.0
11 5,100 34 463.0
12 4,910 30 366.0
13 3,435 35 348.0
14 3,850 36 347.0
15 3,550 33 354.0
16 4,155 37 444.0
17 3,090 28 315.0
18 2,015 20 153.0
19 4,430 31 491.5
Total 57,415 461 5,273.5
Monthly Revenue Summary
month_name monthly_net_revenue monthly_transactions liters_sold
Apr 4,750 34 396
May 10,610 80 972
Jun 18,380 139 1,536
Jul 15,970 149 1,604
Aug 7,705 59 766
Total 57,415 461 5,274
Top 15 Customers by Lifetime Value
name id visits lifetime_value total_litres
Ian Kimori s022 15 2,470 320
Susan Kamau s034 9 2,150 255
Eunice Nyaa s051 5 1,850 220
Githaiga Advocate s031 3 1,750 190
Viv's Pub s004 5 1,700 130
Rose Nyambati s024 9 1,580 180
Evans Nganga s002 8 1,570 160
Davis Nyabuto s047 4 1,530 160
Brian Masero s001 10 1,480 181
Peter Ngugi s098 1 1,400 48
Kennedy Maingi (Bonny) s019 6 1,320 84
Ruhumiza Claver s109 14 1,020 102
Susan Ndungu (DK Kinyozi) s070 3 1,010 101
Jose Boda s028 5 1,000 100
Postbank s026 3 990 120