Hi, how to make a chart with sum of each part...

(Arnaud B.) #1

Hi, how to make a chart with sum of each part, per date ? THX For exemple: 01/01 part A, SUM is 6, 01/02 part A SUM is 5 and part B SUM is 11 …

(Bellave Jayaram) #2

SUM(SELECT (Table[Value], AND([Date]=[_THISROW].[Date],[Part]=[_THISROW].[Part])))

(Arnaud B.) #3

@Bellave_Jayaram THX, then i need to make a virtual value for this i think ?

(Arnaud B.) #4

@Bellave_Jayaram THX, i’ll try

(Arnaud B.) #5

@Arnaud_B It don’t work. Appsheet force me to add the key column in the slice (timestamp).

(Bellave Jayaram) #6

Yes, correct- in the chart settings you can choose column series chart with date on x axis and sum on y axis.

(Arnaud B.) #7

THX, i’ll try

(Arnaud B.) #8

@Bellave_Jayaram It work but, for example, if i have 3 value the same day, in chart i see 3 times the sum, side by side

(Bellave Jayaram) #9

Change the X axis from Datetime to Date. Add a VC of type Date called, say DateVC, with app formula [Date]

(Arnaud B.) #10

The datetime is my key. I can’t change it. But I’ve a virtual column: Vdate from datetime. But how to set Vdate as axis?

(Bellave Jayaram) #11

Can you try adding Vdate as the first chart column ?

(Arnaud B.) #12

@Bellave_Jayaram with colseries, Vdate as first chart column = no data available

(Bellave Jayaram) #13

Create a slice of just the two columns, Vdate and SumColumn for your

chart view