Hello friends. How do I divide into months, ...

[Eduardo_dos_San]

Hello friends.

How do I divide into months, a quantity of information that is stored in a Google spreadsheet to assemble a chart?

[Simon_Robinson]

So can display just July 2018 for example?

[Eduardo_dos_San]

@Simon_Robinson

Mr. Robinson, I created a slice to filter out my team’s production as shown in the picture.

But this data is from November (date of app creation) to Today.

I want to share this information in their respective months.

I want the chart to show me: What is november What is december What is January

[Bellave_Jayaram]

You can create charts for each month by making a slice for each month. For November you can use:

SELECT(Expenses[Amount],MONTH([Date])=11) Or are you wanting a stacked bar chart where all months are shown in the same chart?

[Simon_Robinson]

Addition to @Bellave_Jayaram you could also use a dashboard to display multiple graphs on on screen.

But it depends on the complexity.

Sometimes I create a table actually in the spreadsheet which Appsheet then reads

[Eduardo_dos_San]

@Bellave_Jayaram

stacked bar chart where every month is shown on the same chart.

It’s possible ?

[Bellave_Jayaram]

Have you see this page - help.appsheet.com - Charts: The Essentials

You need to arrange your data as shown in the example on Column/Row Series [Stack}. If your data is not in that structure, then you need to create it using sheet formulas in a separate tab and import that table into the app. Then, you can have multiple months data in the same chart. Charts: The Essentials help.appsheet.com

[Eduardo_dos_San]

@Bellave_Jayaram

I arranged the data in my spreadsheet. It worked

Thank you