i have date field and totalCon field in table
that table like
3- aug 098
so i want sum of totalcon in date ways like 1-aug sum(12323+983+0222+11111) this so please tell me any one in chats
If you have Date as your dimension, sum(totalcon) would give you the sum by each date.
You could use a resident load in your script and group by your date to get the totals instead if preferred.
Create a chart and set "date" as dimension and "Sum(totalcon)" as expression.
Maybe you need to convert totalcon to number:
If you can is better to do this conversion when loading the data in script.
You can do this in the script if you use the function Group by.
LOAD * INLINE [
date , totalcon
1-aug , 12323
1-aug , 983
1-aug , 0222
1-aug , 11111
1-aug , 231
2-aug , 1111
2-aug , 321
3-aug , 234
Sum (totalcon) As Sum_totalcon
Group by date;
Drop Table A_tmp;