I have a table called Priority that includes:
X-axis: Money
Y-axis: Decimal values (range: 1–5)
Items column: Each item has a corresponding Money value, a Y-axis value, and a Priority List (e.g., 1, 2, 3, 4) that indicates purchase priority.
What I Tried:
- Created a virtual column with this formula:
SWITCH([Priority],
“1”, “Red”,
“2”, “Orange”,
“3”, “Yellow”,
“4”, “Green”,
“Default”)
- Changed Priority List type from Number to Text to allow color mapping.
Issues Faced:
Some points disappear from the graph unless I apply the search filter. When filtered, the points appear in default blue color instead of custom colors.
If I search for multiple priorities (e.g., 1, 2, 3, 4), only some points show (e.g., 1, 2, 3), and colors remain system-generated instead of custom ones.
I created a scatter plot using App Sheet’s new chart feature. By default, system-generated colors are applied, which works fine, but I want to customize colors for each priority level (e.g., Priority 1 = Red, Priority 2 = Orange, Priority 3 = Yellow, Priority 4 = Green).
Questions:
-
How to ensure all points are visible in the scatter plot without disappearing when custom colors are used?
-
How to assign custom colors properly so they remain consistent across all filters?
-
Can we set fixed axis ranges instead of auto-scaling in the new chart view?
it is working good but second one
it is not showing blue color and even when I filter those all corresponding data is appearing but when searching up to 3 colors are showing.
Lastly I need that round up thing values that desirable labels
could any one help if any workaround or solution will be very helpful.