daily_average median q1 q3 iqr sd
472 365 200 635 435 396

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 3,680 27 411.5
Total 56,665 457 5,193.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 6,955 55 686
Total 56,665 457 5,194
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
Brian Masero s001 10 1,480 181
Peter Ngugi s098 1 1,400 48
Kennedy Maingi (Bonny) s019 6 1,320 84
Davis Nyabuto s047 3 1,130 120
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