Using an enum data column for graph. I only ...

Tim_Meske
Participant V

Using an enum data column for graph.

I only want to display 3 of the 6 enum options on the graph.

Is it possible to NOT include all the enum selections in the graph?

0 6 394
6 REPLIES 6

Mike_A
Participant V

Have you tried using a slice as the source and filter the records based on the ENUM value?

If i get you correctly, you only want to include records in the chart with specific ENUM values?

Tim_Meske
Participant V

@Mike_Adler yes.

Sounds like that will work. Thanks!

Tim_Meske
Participant V

@Mike_Adler your suggestion works so that only select enum records qty are displayed but the x-axis on the chart continues to display the other enum names at 0.

How to only display the required x-axis column names but not the other non-required enum names.

Hope this makes sense.

Mike_A
Participant V

I havenโ€™t tried this so would have to test how blanks are handled.

Can you post the exact filter equation you used in the slice?

Tim_Meske
Participant V

Mike_A
Participant V

@Tim_Meske - seems logical to me.

Would have to play around if I get some time.

Maybe an appsheet guru knows a better way to approach this.

Seems like if you filter the entire record (eg: a slice), then only records with the โ€œrightโ€ [General Contractor Name] values would showโ€ฆ and I assume that was what the X axis was dynamically created from.

Looks like I guessed wrong!

Top Labels in this Space