trying to fix formatting

Dependencies

• [2] Q22Y36T4 added .julia format, tidy up
• [3] A7ZUWLHK killed git
• [4] WWD7AK5V new data 2024-02-12
• [5] BVGC7DNN update for 25/12/23 MBM
• [6] 2WLFHMV7 New data 8/1/24
• [7] W7QD6CHH new data for 2024-01-01
• [8] WPCMAQQ2 new data 22/1/24
• [9] K4V5O6JX updated for 2023-12-04
• [10] LTNUXR5D
• [11] QZTNIJSV updated 2023-12-18
• [12] 44VMPIMA catch up commit including survey
• [13] IYLVG2FI first commit
• [14] 3EZS3IU6 changed metrics_plot() so it includes total sales, simplified plot

Change contents

• file deletion: .JuliaFormatter.toml (----------)
  [4.1]→[3.91:135](∅→∅),[3.135]→[3.75:75](∅→∅)
  − style = "blue"
• edit in src/FiordlandPacks.jl at line 27
  [2.353342]→[4.671:716](∅→∅),[4.671]→[4.671:716](∅→∅),[4.716]→[4.4:92](∅→∅),[4.92]→[4.799:938](∅→∅),[4.799]→[4.799:938](∅→∅),[4.938]→[2.353343:354042](∅→∅)
  − function metrics_plot()

  − if Sys.isapple()

  − file = "/Users/david/julia/FiordlandPacks/images_and_tables/FiordlandPacks.csv"

  − else

  − file = "/media/david/SSD1/FiordlandPacks/images_and_tables/FiordlandPacks.csv"

  − end

  − df = DataFrame(CSV.File(file))

  − transform!(df, [:Shopify_Sales, :Invoice_Sales] => (a, b) -> a .+ b)

  − select!(

  − df,

  − :Week,

  − :Contact_Submit,

  − :Pack_Builder_Clicks,

  − :Checkouts_Created,

  − :Customer_Actions,

  − :Shopify_Sales,

  − :Invoice_Sales,

  − :Shopify_Sales_Invoice_Sales_function => "Sales",

  − :Google_Spend,

  − )

  − table = pretty_table(

  − last(df, 12);

  − title="Metrics",

  − header=[

  − "Week",

  − "Contact",

  − "Builder",

  − "Checkout",

  − "ACTIONS",

  − "Shopify",

  − "Invoice",

  − "Sales",

  − "Google",

  − ],

  − display_size=(30, 300),

  − )
• edit in src/FiordlandPacks.jl at line 28
  [4.1108]→[4.481:550](∅→∅),[4.550]→[4.1201:1333](∅→∅),[4.1201]→[4.1201:1333](∅→∅),[4.1520]→[4.1520:1541](∅→∅),[4.1541]→[2.354043:354162](∅→∅),[4.189]→[4.1632:1641](∅→∅),[2.354162]→[4.1632:1641](∅→∅),[4.1632]→[4.1632:1641](∅→∅),[4.1641]→[2.354163:354532](∅→∅),[2.354532]→[4.1744:1765](∅→∅),[4.1744]→[4.1744:1765](∅→∅)
  − df2 = Base.stack(df, [:Customer_Actions, :Sales, :Google_Spend])

  − transform!(df2, :Week => ByRow(x -> Dates.format(x, "yyyy-mm-dd")))

  − rename!(df2, :variable => "Metric", :value => "Number")

  − if Sys.isapple()

  − save(

  − "/Users/david/julia/FiordlandPacks/images_and_tables/metrics_fiordland_packs.png",

  − )

  − else

  − save(

  − "/media/david/SSD1/FiordlandPacks/images_and_tables/metrics_fiordland_packs.png"

  − )

  − end(

  − @vlplot(

  − :line,

  − x = :Week,

  − y = :Number,

  − color = :Metric,

  − title = "Metrics Plot",

  − width = 400,

  − height = 400

  − )(

  − df2

  − ),

  − )

  − return table

  − end
• replacement in images_and_tables/metrics_fiordland_packs.png at line 1
  [4.394888]→[2.392944:443707](∅→∅)
  [4.394888]
• replacement in images_and_tables/FiordlandPacks.csv at line 30
  [2.443833]→[2.443833:443863](∅→∅)
  − 2024-03-11,3,15,1,19,0,4,22.64
  [2.443833]
  + 2024-03-11,3,15,1,19,0,4,22.64

  + 2024-03-18,4,11,0,15,0,3,19.19