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:
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,
Solved! Go to Solution.
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.
User | Count |
---|---|
17 | |
14 | |
10 | |
7 | |
4 |