Update app.py

app.py

@@ -84,13 +84,29 @@ select_bar = alt.selection_point(
     clear="true"
 )
 
+#summing the barchart but the human services and transit departments are so large you cannot click on the other agencies
+# bar_chart = (
+#     alt.Chart(df_small)
+#     .mark_bar()
+#     .encode(
+#         y=alt.Y("Agency:N", sort="-x"),
+#         x=alt.X("sum(YTD Gross):Q", title="Total Personale Expense"),  # <-- take the mean
+#         tooltip=[
+#             "Agency:N",
+#             alt.Tooltip("mean(YTD Gross):Q", title="Avg YTD Gross", format="$,.0f")
+#         ],
+#         color=alt.condition(select_bar, alt.value("#4C78A8"), alt.value("#CCCCCC"))
+#     )
+#     .add_params(select_bar)
+#     .properties(width=500, height=800)
+# )
 
 bar_chart = (
     alt.Chart(df_small)
     .mark_bar()
     .encode(
         y=alt.Y("Agency:N", sort="-x"),
-        x=alt.X("sum(YTD Gross):Q", title="Total Personale Expense"),  # <-- take the mean
+        x=alt.X("mean(YTD Gross):Q", title="Average Personale Expense"),  # <-- take the mean
         tooltip=[
             "Agency:N",
             alt.Tooltip("mean(YTD Gross):Q", title="Avg YTD Gross", format="$,.0f")
@@ -102,6 +118,22 @@ bar_chart = (
 )
 
 
+bar_chart = (
+    alt.Chart(df_small)
+    .mark_bar()
+    .encode(
+        y=alt.Y("Agency:N", sort="-x"),
+        x=alt.X("sum(YTD Gross):Q", title="Total Personale Expense"),  # <-- take the mean
+        tooltip=[
+            "Agency:N",
+            alt.Tooltip("mean(YTD Gross):Q", title="Avg YTD Gross", format="$,.0f")
+        ],
+        color=alt.condition(select_bar, alt.value("#4C78A8"), alt.value("#CCCCCC"))
+    )
+    .add_params(select_bar)
+    .properties(width=500, height=800)
+)
+
 # box = (
 #     alt.Chart(df_small)
 #     .mark_boxplot(size=40)