LinkedIn
Twitter
Hi, I’m very new to Appsheet and I’m having trouble displaying specific data as a chart.
I have a sheet of individual items that have characteristics rated from 0 to 5. I’d like to tap that item and see a chart that shows that items data only as a way to visualize the individual scores.
To make it concrete let’s say I have a database of fruit and I’m rating them based on specific qualities: size, shape, color, smell, firmness on a scale of 0 to 5. If I click on “Golden Delicious” I’d like to see a chart with just the data for that row not for every individual entry in the database.
Attached pic for example
Hi @Minisaurus ,
Please explore if following helps you
-
You may wish to create a row series type chart view on the above table and include all the required columns for chart ( size, shape,color,smell ,firmness) while defining that view.
-
You can then create an action type 'App: go to another view within the app" and define it something like below
LINKTOFILTEREDVIEW(“Row Chart”,[Name]=[_THISROW].[Name])
Here "Row Chart"is the name of the chart view created in step 1 above. [Name] is fruit name column. This column should typically be a row key column.
- Please make this action as “display inline” and attach this action to say a blank column of the table to make it display in say table view.
As per my understanding such row series chart may not though currently have different colors for different attributes when defined in view in AppSheet.
The images below show the table with inline action highlighted and chart view with single row data.
When I set Action Appearance Prominence “Display inline”, the column name attached in view will be obscured by Action icon --that is, I cannot see the name of corresponding column name.
Can u tell me where I use it wrongly and how to do to show corresponding column name?
Thanks @Suvrutt_Gurjar ,
I don’t know the meaning of phase “VC” ,and I found column name and icon show in one column in your below case. I wanna implement same effect as yours.
VC means virtual columns.
The column names and other values show in my case because I have attached the inline action to a column that I do not wish to see in the summary view. It could be key column or some other such column. As mentioned, you can even create a VC with an app formula as “Chart” and attach the action to that column.
Action
Virtual Column
Column included the view definition
Something like above. Please ensure you include the column in the summary view to which the action is attached.
Thanks @Suvrutt_Gurjar ,
I follow your directions, but the column split line on the top not like your sample case. I means the icon not within class column, column VC i created show in behind split line, like below. And I hope the position of split line is in the position of red line.
Thanks your patient rely @Suvrutt_Gurjar ,
For aesthetic consideration, I think the old version is better. 
