Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Suppose I have a table like below.
Id, Marks
1,10
2,34
3,21
4,56
5,11
I want to draw a chart in which dimension will be id and expression will be sum(Marks)
I want to overide the id , show same values of sum corresponding to all Id. ie, in chart it should show 132 corresponding to all id's.
Please help how the expression needs to be changed.
Expression
SUM(TOTAL Marks)
Or
You can get the same by script
Table1:
Load * Inline
[
Id, Marks
1,10
2,34
3,21
4,56
5,11
];
Left Join
Load SUM(Marks) as TotalMarks Resident Table1;
Expression
SUM(TOTAL Marks)
Or
You can get the same by script
Table1:
Load * Inline
[
Id, Marks
1,10
2,34
3,21
4,56
5,11
];
Left Join
Load SUM(Marks) as TotalMarks Resident Table1;
Thanks Manish