How to use col series chart [line]

[ECardoso]

Hello everyone.

I have a table in this model

I think I need to put her in this model

because I want to use this type of chart!

Does anyone have any tips or tutorials on how to do this?

[Joseph_Seddik]

Just add a calculated "Month" column.

[ECardoso]

month is a text type column.

How am I going to calculate?

[Joseph_Seddik]

MONTH() - AppSheet Help

[ECardoso]

did not work

[Joseph_Seddik]

What exactly did not work? did you have errors? something else? Please be more descriptive so you could get better help.

[ECardoso]

First: I don't understand what is "a calculated "Month" column?"

second: I didn't find the solution in 

https://support.google.com/appsheet/answer/10107922?hl=en&sjid=10155161583859601706-EU

[Joseph_Seddik]

A calculated column is a column with an App formula (or an Initial Value). You can use AppSheet's function MONTH() to give you exactly what you need. The exact case of calculating month names from dates is in the guide. 

[ECardoso · Accepted solution]

I appreciate you helping me, but I found what I want.

PS: I used the Month name method described in the link - I called my virtual column month.

First I create a virtual column with the sum of the pay column. look
SUM( Select(mytable[pay], [month]=[_THISROW].[month]))

Second I create a slice of my table. and use the formula

max(select(table[pay], [_thisrow].[month] = [month])) = [pay]

Finally I create my chart UX and I get the result I want

[Joseph_Seddik]

You don't have to create additional columns for sum and max, and actually using virtual columns with these formulas on a table like yours is a very bad idea. 

You only need the Month column, then aggregate in the chart itself.