Display the right x-axis on a chart

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?

2X_6_687d544e4f7320826f7542ccb4a34fd7ed51147f.png

Chart definition:
2X_e_e410b66aa59922fa5356a9443b5f14dbe22ca721.png

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 Solved
1 5 2,089
1 ACCEPTED 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.

View solution in original post

5 REPLIES 5