{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "3450476b-4442-4058-a85f-fe62318bf4d4",
   "metadata": {},
   "source": [
    "# Parameter `base` of the Waterfall Plot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "12b11c62-ca96-4170-b170-3621f8443dfa",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "from lets_plot import *\n",
    "from lets_plot.bistro import *"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "bf650dff-1671-4c71-9ccc-16bd70fdeaad",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "            <div id=\"jU3eFj\"></div>\n",
       "            <script type=\"text/javascript\" data-lets-plot-script=\"library\">\n",
       "                if(!window.letsPlotCallQueue) {\n",
       "                    window.letsPlotCallQueue = [];\n",
       "                }; \n",
       "                window.letsPlotCall = function(f) {\n",
       "                    window.letsPlotCallQueue.push(f);\n",
       "                };\n",
       "                (function() {\n",
       "                    var script = document.createElement(\"script\");\n",
       "                    script.type = \"text/javascript\";\n",
       "                    script.src = \"https://cdn.jsdelivr.net/gh/JetBrains/lets-plot@v4.5.0/js-package/distr/lets-plot.min.js\";\n",
       "                    script.onload = function() {\n",
       "                        window.letsPlotCall = function(f) {f();};\n",
       "                        window.letsPlotCallQueue.forEach(function(f) {f();});\n",
       "                        window.letsPlotCallQueue = [];\n",
       "                        \n",
       "                    };\n",
       "                    script.onerror = function(event) {\n",
       "                        window.letsPlotCall = function(f) {};    // noop\n",
       "                        window.letsPlotCallQueue = [];\n",
       "                        var div = document.createElement(\"div\");\n",
       "                        div.style.color = 'darkred';\n",
       "                        div.textContent = 'Error loading Lets-Plot JS';\n",
       "                        document.getElementById(\"jU3eFj\").appendChild(div);\n",
       "                    };\n",
       "                    var e = document.getElementById(\"jU3eFj\");\n",
       "                    e.appendChild(script);\n",
       "                })()\n",
       "            </script>\n",
       "            "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "LetsPlot.setup_html()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "9bbe82ee-646c-4343-bd8b-c13189e8854a",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = {\n",
    "    \"Accounts\": [\"Product revenue\", \"Services revenue\", \"Fixed costs\", \"Variable costs\"],\n",
    "    \"Values\": [830_000, 290_000, -360_000, -150_000],\n",
    "}"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ccb69f6a-4946-4aca-aeed-12216c172268",
   "metadata": {},
   "source": [
    "## Default View"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "291034ab-767e-479a-9016-c8f7b807ecea",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "   <div id=\"YTB0hN\"></div>\n",
       "   <script type=\"text/javascript\" data-lets-plot-script=\"plot\">\n",
       "   \n",
       "   (function() {\n",
       "   // ----------\n",
       "   \n",
       "   var containerDiv = document.getElementById(\"YTB0hN\");\n",
       "   var observer = new ResizeObserver(function(entries) {\n",
       "       for (let entry of entries) {\n",
       "           var width = containerDiv.clientWidth\n",
       "           if (entry.contentBoxSize && width > 0) {\n",
       "           \n",
       "               // Render plot\n",
       "               if (observer) {\n",
       "                   observer.disconnect();\n",
       "                   observer = null;\n",
       "               }\n",
       "\n",
       "               var plotSpec={\n",
       "\"data\":{\n",
       "},\n",
       "\"theme\":{\n",
       "\"axis_tooltip\":{\n",
       "\"blank\":true\n",
       "},\n",
       "\"name\":\"minimal\"\n",
       "},\n",
       "\"kind\":\"plot\",\n",
       "\"scales\":[{\n",
       "\"aesthetic\":\"x\",\n",
       "\"name\":\"Accounts\",\n",
       "\"breaks\":[0.0,1.0,2.0,3.0,4.0],\n",
       "\"labels\":[\"Product revenue\",\"Services revenue\",\"Fixed costs\",\"Variable costs\",\"Total\"]\n",
       "},{\n",
       "\"aesthetic\":\"y\",\n",
       "\"name\":\"Values\"\n",
       "},{\n",
       "\"aesthetic\":\"color\",\n",
       "\"name\":\"Flow type\",\n",
       "\"breaks\":[\"Increase\",\"Decrease\",\"Total\"],\n",
       "\"values\":[\"#4daf4a\",\"#e41a1c\",\"#377eb8\"]\n",
       "},{\n",
       "\"aesthetic\":\"fill\",\n",
       "\"name\":\"Flow type\",\n",
       "\"breaks\":[\"Increase\",\"Decrease\",\"Total\"],\n",
       "\"values\":[\"#4daf4a\",\"#e41a1c\",\"#377eb8\"]\n",
       "}],\n",
       "\"layers\":[{\n",
       "\"geom\":\"spoke\",\n",
       "\"data\":{\n",
       "\"..x..\":[0.0,1.0,2.0,3.0,4.0],\n",
       "\"..value..\":[830000.0,1120000.0,760000.0,610000.0,610000.0],\n",
       "\"..radius..\":[0.09999999999999998,0.09999999999999998,0.09999999999999998,0.09999999999999998,0.0]\n",
       "},\n",
       "\"mapping\":{\n",
       "\"x\":\"..x..\",\n",
       "\"y\":\"..value..\",\n",
       "\"radius\":\"..radius..\"\n",
       "},\n",
       "\"angle\":0.0,\n",
       "\"position\":{\n",
       "\"name\":\"nudge\",\n",
       "\"x\":0.45\n",
       "}\n",
       "},{\n",
       "\"geom\":\"crossbar\",\n",
       "\"data\":{\n",
       "\"..x..\":[0.0,1.0,2.0,3.0,4.0],\n",
       "\"..ymin..\":[0.0,830000.0,760000.0,610000.0,null],\n",
       "\"..ymax..\":[830000.0,1120000.0,1120000.0,760000.0,null],\n",
       "\"..flow_type..\":[\"Increase\",\"Increase\",\"Decrease\",\"Decrease\",\"Total\"],\n",
       "\"..dy..\":[830000.0,290000.0,-360000.0,-150000.0,610000.0]\n",
       "},\n",
       "\"mapping\":{\n",
       "\"x\":\"..x..\",\n",
       "\"ymin\":\"..ymin..\",\n",
       "\"ymax\":\"..ymax..\",\n",
       "\"fill\":\"..flow_type..\"\n",
       "},\n",
       "\"color\":\"black\",\n",
       "\"size\":0.0,\n",
       "\"linetype\":1,\n",
       "\"width\":0.9,\n",
       "\"show_legend\":false,\n",
       "\"tooltips\":{\n",
       "\"lines\":[\"@..dy..\"],\n",
       "\"formats\":[{\n",
       "\"field\":\"..dy..\",\n",
       "\"format\":\".2~f\"\n",
       "}]\n",
       "}\n",
       "},{\n",
       "\"geom\":\"crossbar\",\n",
       "\"data\":{\n",
       "\"..x..\":[0.0,1.0,2.0,3.0,4.0],\n",
       "\"..ymin..\":[null,null,null,null,0.0],\n",
       "\"..ymax..\":[null,null,null,null,610000.0],\n",
       "\"..flow_type..\":[\"Increase\",\"Increase\",\"Decrease\",\"Decrease\",\"Total\"],\n",
       "\"..value..\":[830000.0,1120000.0,760000.0,610000.0,610000.0]\n",
       "},\n",
       "\"mapping\":{\n",
       "\"x\":\"..x..\",\n",
       "\"ymin\":\"..ymin..\",\n",
       "\"ymax\":\"..ymax..\",\n",
       "\"fill\":\"..flow_type..\"\n",
       "},\n",
       "\"color\":\"black\",\n",
       "\"size\":0.0,\n",
       "\"linetype\":1,\n",
       "\"width\":0.9,\n",
       "\"show_legend\":false,\n",
       "\"tooltips\":{\n",
       "\"disable_splitting\":true,\n",
       "\"lines\":[\"@..value..\"],\n",
       "\"formats\":[{\n",
       "\"field\":\"..value..\",\n",
       "\"format\":\".2~f\"\n",
       "}]\n",
       "}\n",
       "},{\n",
       "\"geom\":\"text\",\n",
       "\"data\":{\n",
       "\"..x..\":[0.0,1.0,2.0,3.0,4.0],\n",
       "\"..ymiddle..\":[415000.0,975000.0,940000.0,685000.0,305000.0],\n",
       "\"..label..\":[830000.0,290000.0,-360000.0,-150000.0,610000.0]\n",
       "},\n",
       "\"mapping\":{\n",
       "\"x\":\"..x..\",\n",
       "\"y\":\"..ymiddle..\",\n",
       "\"label\":\"..label..\"\n",
       "},\n",
       "\"color\":\"white\",\n",
       "\"show_legend\":false,\n",
       "\"label_format\":\".2~f\"\n",
       "},{\n",
       "\"geom\":\"hline\",\n",
       "\"yintercept\":0.0,\n",
       "\"linetype\":2,\n",
       "\"tooltips\":\"none\",\n",
       "\"data\":{\n",
       "}\n",
       "}],\n",
       "\"metainfo_list\":[],\n",
       "\"spec_id\":\"1\"\n",
       "};\n",
       "               window.letsPlotCall(function() {\n",
       "       \n",
       "               var toolbar = null;\n",
       "               var plotContainer = containerDiv;               \n",
       "               \n",
       "                   var options = {\n",
       "                       sizing: {\n",
       "                           width_mode: \"min\",\n",
       "                           height_mode: \"scaled\",\n",
       "                           width: width\n",
       "                       }\n",
       "                   };\n",
       "                   var fig = LetsPlot.buildPlotFromProcessedSpecs(plotSpec, -1, -1, plotContainer, options);\n",
       "                   if (toolbar) {\n",
       "                     toolbar.bind(fig);\n",
       "                   }\n",
       "               });\n",
       "               \n",
       "               break;\n",
       "           }\n",
       "       }\n",
       "   });\n",
       "   \n",
       "   observer.observe(containerDiv);\n",
       "   \n",
       "   // ----------\n",
       "   })();\n",
       "   \n",
       "   </script>"
      ],
      "text/plain": [
       "<lets_plot.plot.core.PlotSpec at 0x148364ee0>"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "waterfall_plot(data, \"Accounts\", \"Values\", hline=element_line()) + theme_minimal()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fca89d1a-6b5a-4393-a420-47c33381c7fd",
   "metadata": {},
   "source": [
    "## Change Base"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "d4836173-0cd3-4831-bdb3-873f76b3e987",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "   <div id=\"yDBTSS\"></div>\n",
       "   <script type=\"text/javascript\" data-lets-plot-script=\"plot\">\n",
       "   \n",
       "   (function() {\n",
       "   // ----------\n",
       "   \n",
       "   var containerDiv = document.getElementById(\"yDBTSS\");\n",
       "   var observer = new ResizeObserver(function(entries) {\n",
       "       for (let entry of entries) {\n",
       "           var width = containerDiv.clientWidth\n",
       "           if (entry.contentBoxSize && width > 0) {\n",
       "           \n",
       "               // Render plot\n",
       "               if (observer) {\n",
       "                   observer.disconnect();\n",
       "                   observer = null;\n",
       "               }\n",
       "\n",
       "               var plotSpec={\n",
       "\"data\":{\n",
       "},\n",
       "\"theme\":{\n",
       "\"axis_tooltip\":{\n",
       "\"blank\":true\n",
       "},\n",
       "\"name\":\"minimal\"\n",
       "},\n",
       "\"kind\":\"plot\",\n",
       "\"scales\":[{\n",
       "\"aesthetic\":\"x\",\n",
       "\"name\":\"Accounts\",\n",
       "\"breaks\":[0.0,1.0,2.0,3.0,4.0],\n",
       "\"labels\":[\"Product revenue\",\"Services revenue\",\"Fixed costs\",\"Variable costs\",\"Total\"]\n",
       "},{\n",
       "\"aesthetic\":\"y\",\n",
       "\"name\":\"Values\"\n",
       "},{\n",
       "\"aesthetic\":\"color\",\n",
       "\"name\":\"Flow type\",\n",
       "\"breaks\":[\"Increase\",\"Decrease\",\"Total\"],\n",
       "\"values\":[\"#4daf4a\",\"#e41a1c\",\"#377eb8\"]\n",
       "},{\n",
       "\"aesthetic\":\"fill\",\n",
       "\"name\":\"Flow type\",\n",
       "\"breaks\":[\"Increase\",\"Decrease\",\"Total\"],\n",
       "\"values\":[\"#4daf4a\",\"#e41a1c\",\"#377eb8\"]\n",
       "}],\n",
       "\"layers\":[{\n",
       "\"geom\":\"spoke\",\n",
       "\"data\":{\n",
       "\"..x..\":[0.0,1.0,2.0,3.0,4.0],\n",
       "\"..value..\":[1230000.0,1520000.0,1160000.0,1010000.0,1010000.0],\n",
       "\"..radius..\":[0.09999999999999998,0.09999999999999998,0.09999999999999998,0.09999999999999998,0.0]\n",
       "},\n",
       "\"mapping\":{\n",
       "\"x\":\"..x..\",\n",
       "\"y\":\"..value..\",\n",
       "\"radius\":\"..radius..\"\n",
       "},\n",
       "\"angle\":0.0,\n",
       "\"position\":{\n",
       "\"name\":\"nudge\",\n",
       "\"x\":0.45\n",
       "}\n",
       "},{\n",
       "\"geom\":\"crossbar\",\n",
       "\"data\":{\n",
       "\"..x..\":[0.0,1.0,2.0,3.0,4.0],\n",
       "\"..ymin..\":[400000.0,1230000.0,1160000.0,1010000.0,null],\n",
       "\"..ymax..\":[1230000.0,1520000.0,1520000.0,1160000.0,null],\n",
       "\"..flow_type..\":[\"Increase\",\"Increase\",\"Decrease\",\"Decrease\",\"Total\"],\n",
       "\"..dy..\":[830000.0,290000.0,-360000.0,-150000.0,610000.0]\n",
       "},\n",
       "\"mapping\":{\n",
       "\"x\":\"..x..\",\n",
       "\"ymin\":\"..ymin..\",\n",
       "\"ymax\":\"..ymax..\",\n",
       "\"fill\":\"..flow_type..\"\n",
       "},\n",
       "\"color\":\"black\",\n",
       "\"size\":0.0,\n",
       "\"linetype\":1,\n",
       "\"width\":0.9,\n",
       "\"show_legend\":false,\n",
       "\"tooltips\":{\n",
       "\"lines\":[\"@..dy..\"],\n",
       "\"formats\":[{\n",
       "\"field\":\"..dy..\",\n",
       "\"format\":\".2~f\"\n",
       "}]\n",
       "}\n",
       "},{\n",
       "\"geom\":\"crossbar\",\n",
       "\"data\":{\n",
       "\"..x..\":[0.0,1.0,2.0,3.0,4.0],\n",
       "\"..ymin..\":[null,null,null,null,400000.0],\n",
       "\"..ymax..\":[null,null,null,null,1010000.0],\n",
       "\"..flow_type..\":[\"Increase\",\"Increase\",\"Decrease\",\"Decrease\",\"Total\"],\n",
       "\"..value..\":[1230000.0,1520000.0,1160000.0,1010000.0,1010000.0]\n",
       "},\n",
       "\"mapping\":{\n",
       "\"x\":\"..x..\",\n",
       "\"ymin\":\"..ymin..\",\n",
       "\"ymax\":\"..ymax..\",\n",
       "\"fill\":\"..flow_type..\"\n",
       "},\n",
       "\"color\":\"black\",\n",
       "\"size\":0.0,\n",
       "\"linetype\":1,\n",
       "\"width\":0.9,\n",
       "\"show_legend\":false,\n",
       "\"tooltips\":{\n",
       "\"disable_splitting\":true,\n",
       "\"lines\":[\"@..value..\"],\n",
       "\"formats\":[{\n",
       "\"field\":\"..value..\",\n",
       "\"format\":\".2~f\"\n",
       "}]\n",
       "}\n",
       "},{\n",
       "\"geom\":\"text\",\n",
       "\"data\":{\n",
       "\"..x..\":[0.0,1.0,2.0,3.0,4.0],\n",
       "\"..ymiddle..\":[815000.0,1375000.0,1340000.0,1085000.0,705000.0],\n",
       "\"..label..\":[830000.0,290000.0,-360000.0,-150000.0,1010000.0]\n",
       "},\n",
       "\"mapping\":{\n",
       "\"x\":\"..x..\",\n",
       "\"y\":\"..ymiddle..\",\n",
       "\"label\":\"..label..\"\n",
       "},\n",
       "\"color\":\"white\",\n",
       "\"show_legend\":false,\n",
       "\"label_format\":\".2~f\"\n",
       "},{\n",
       "\"geom\":\"hline\",\n",
       "\"yintercept\":400000.0,\n",
       "\"linetype\":2,\n",
       "\"tooltips\":\"none\",\n",
       "\"data\":{\n",
       "}\n",
       "}],\n",
       "\"metainfo_list\":[],\n",
       "\"spec_id\":\"2\"\n",
       "};\n",
       "               window.letsPlotCall(function() {\n",
       "       \n",
       "               var toolbar = null;\n",
       "               var plotContainer = containerDiv;               \n",
       "               \n",
       "                   var options = {\n",
       "                       sizing: {\n",
       "                           width_mode: \"min\",\n",
       "                           height_mode: \"scaled\",\n",
       "                           width: width\n",
       "                       }\n",
       "                   };\n",
       "                   var fig = LetsPlot.buildPlotFromProcessedSpecs(plotSpec, -1, -1, plotContainer, options);\n",
       "                   if (toolbar) {\n",
       "                     toolbar.bind(fig);\n",
       "                   }\n",
       "               });\n",
       "               \n",
       "               break;\n",
       "           }\n",
       "       }\n",
       "   });\n",
       "   \n",
       "   observer.observe(containerDiv);\n",
       "   \n",
       "   // ----------\n",
       "   })();\n",
       "   \n",
       "   </script>"
      ],
      "text/plain": [
       "<lets_plot.plot.core.PlotSpec at 0x148364dc0>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prev_period_total = 400_000\n",
    "waterfall_plot(data, \"Accounts\", \"Values\", base=prev_period_total, hline=element_line()) + theme_minimal()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.20"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}