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 …
SUM(SELECT (Table[Value], AND([Date]=[_THISROW].[Date],[Part]=[_THISROW].[Part])))
@Bellave_Jayaram THX, then i need to make a virtual value for this i think ?
@Arnaud_B It don’t work. Appsheet force me to add the key column in the slice (timestamp).
Yes, correct- in the chart settings you can choose column series chart with date on x axis and sum on y axis.
THX, i’ll try
@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
Change the X axis from Datetime to Date. Add a VC of type Date called, say DateVC, with app formula [Date]
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?
Can you try adding Vdate as the first chart column ?
@Bellave_Jayaram with colseries, Vdate as first chart column = no data available
Create a slice of just the two columns, Vdate and SumColumn for your