Hi All,
When creating a graph, the x-axis column is automatically default to the Table label. In my case, the label is the Date field which is fine but I am interested to create other graphs with different x-axis (Week Date and Month Date). How can I do that?
Chart definition:
This is similar to:
[Charting/Graphs: Is there a way to use other fields vs just the label for charting on the x-axis?](https://community.appsheet.com/t/charting-graphs-is-there-a-way-to-use-other-fields-vs-just-the-label-for-charting-on-the-x-axis/12832) Questions
I have a client who’s extremely excited about the charting capability but find that unfortunately they’re limited to only the label associated with each table for the x-axis. If I change the label for the chart, this affects the remainder of the app screens. Client would like to see the value of quotes by sales rep and by quote stage - none of which are the main labels for the Quote table. Has anyone found a way to handle this? Thanks [image]
But I am creating another post since my x-axis is always date. I just want to see a chart per day, week and month.
Thanks,
1 Like
In order to show the charts by week or month, I would assume you need to summarize or collate data in some fashion? Right?
What I do for these situations is create separate Google sheets and use queries to create the summarized information from my main data sheet. I then pull those into AppSheet as separate tables and then create a Chart view for each one.
3 Likes
WillowMobileSystems:
What I do for these situations is create separate Google sheets and use queries to create the summarized information from my main data sheet.
John, do you have an example of a google sheet that uses queries? I have data points I would like to aggregate (SUM) per week. Thanks.
Here’s an example query I use in Google to capture Daily Revenue summary with the resulting data sheet sample below.
Feel free to ask questions!
=Query(WorkOrders!E:AJ, "select year(Q), month(Q)+1, day(Q), sum(AE), sum(AF), sum(AG), sum(AH), sum(AI) where Q is not null and E = 'Order' group by year(Q), month(Q)+1, day(Q) label year(Q) 'Year', month(Q)+1 'Month', day(Q) 'Day', sum(AE) 'Products', sum(AF) 'Materials', sum(AG) 'Labor', sum(AH) 'Other', sum(AI) 'SubTotal'")
2 Likes
Thanks a ton John. I need to read more about Query.
