Histogram chart displaying zero value columns

[jmable]

I'm trying to create a histogram based on a subset of statuses. So I created a slice that only shows requests that have the "Appt Status" values shown but how do I not show all the other values in the chart? I was trying to figure out if I could create a Virtual Column and a subset of Appt Status values but I couldn't figure out how to get that to work. Any ideas? I tried to use the enhanced charting options which works but didn't allow you to click on the columns to drill into the data which is what I need as well.

Here are my chart settings:

[Suvrutt_Gurjar · Accepted solution]

Please try below.

Please create a virtual or physical column called say [ApptStatus_V] with an app formula expression of [ApptStatus]

Now please base your histogram chart on the column  [ApptStatus_V] rather than column [ApptStatus]

The above solution assumes that the column [ApptStatus] is a required column and does not have any blanks. 

if it is not a required column, then you could have a slice on the table with an expression something like 

ISNOTBLANK([ApptStatus_V]) and then base the histogram chart on this slice and of course the column as  [ApptStatus_V]

[PauloExpert]

You're close — and you're thinking in the right direction by using a slice and wanting to drill down from a chart. Here's how to only show certain ApptStatus values in your chart while retaining drill-down capability (clicking a bar to view records):

✅ Best Approach: Use a Slice with a Filtered Condition

You don’t need a virtual column if your goal is just to filter out specific ApptStatus values. You can do this directly in the slice.

✅ Step-by-Step Fix

1. Create a Slice (already done):

Go to Data > Slices.

Filter only the statuses you want to show:

IN([ApptStatus], {"Confirmed", "Cancelled", "No Client Response"})

Name this slice something like "Filtered Request History".

2. Create a Chart View Based on the Slice:

Go to UX > Views, create a new view.

Set:

For this data: Filtered Request History

View type: Chart

Chart type: Histogram (or Bar)

Group aggregate: COUNT

Chart columns: ApptStatus

Position it where you want (menu, dashboard, etc.)

3. Enable Drill-Down:

AppSheet automatically lets you click on a bar in a chart to view the list of matching rows, as long as:

You’re using a chart view tied to a slice or table.

You use a field with discrete values like ApptStatus.

⚠️ Don’t Use Enhanced Chart Editor

You're correct — the new enhanced charting options are powerful but currently don’t support drill-down interactions in AppSheet apps. Stick with the regular chart editor for interactive dashboards.

✅ Optional: Virtual Column (for custom grouping)

If you wanted a custom grouping, like grouping multiple statuses into a label (e.g., all "lost" statuses), you could create a virtual column:

SWITCH(

  [ApptStatus],

  "Cancelled", "Closed",

  "Rejected", "Closed",

  "No Client Response", "Pending Follow-up",

  [ApptStatus]

)

Then you can use that virtual column in the chart instead of ApptStatus.

Summary

Goal Solution

Only show selected statuses Use a Slice with IN([ApptStatus], {...})

Make chart bars clickable Use regular Chart View (not enhanced charts)

Group multiple statuses Use a Virtual Column with SWITCH() logic

[jmable]

Thank you for all the details. I did have a filtered slice based on ApptStatus using an "or" condition but I changed it to your "In" and it still is showing all the columns in the chart. 😞

Below is a snippet of my Slice and what the chart looks like.

[Suvrutt_Gurjar · Accepted solution]

Please try below.

Please create a virtual or physical column called say [ApptStatus_V] with an app formula expression of [ApptStatus]

Now please base your histogram chart on the column  [ApptStatus_V] rather than column [ApptStatus]

The above solution assumes that the column [ApptStatus] is a required column and does not have any blanks. 

if it is not a required column, then you could have a slice on the table with an expression something like 

ISNOTBLANK([ApptStatus_V]) and then base the histogram chart on this slice and of course the column as  [ApptStatus_V]

[jmable]

When I do that it lumps the results all together into a single column.

[Suvrutt_Gurjar · Accepted solution]

I requested you to simply code the virtual column as [ApptStatus]

Please make it a text type column.

---

@Suvrutt_Gurjar wrote:

Please create a virtual or physical column called say [ApptStatus_V] with an app formula expression of [ApptStatus]

---

[jmable]

Oops, I missed that. Genius! It worked!