May 15, 2017 at 12:25 pm
Hi
I have a stacked graph and need to calculate running values.
I have a series value is CountDistinct(Fields!WorkOrders.Value)
CategoryGroup (Fields!AgeGroupWeek.Value) and SeriesGroup (Fields!WorkOrderImportance.Value)
Then I created a secondary axis as a line type in order to calculate the accumulative value, the expression I used is
Runningvalue(Fields!WorkOrderCode.Value,Count,nothing)
The only problem is that it's calculate for each SeriesGroup whereas I need to calculate the Running Value on a category group.
provided the sample data
CREATE
TABLE DATALOAD
(
WorkOrderId VARCHAR(10)
,AgeGroupWeek VARCHAR(20)
,WorkOrderImportance VARCHAR(20)
);
INSERT INTO DATALOAD (WorkOrderId,AgeGroupWeek,WorkOrderImportance) VALUES ('S00258051' ,'Over 3 Months ago' ,'Normal')
INSERT INTO DATALOAD (WorkOrderId,AgeGroupWeek,WorkOrderImportance) VALUES ('S00126' ,'Over 3 Months ago' ,'Normal')
INSERT INTO DATALOAD (WorkOrderId,AgeGroupWeek,WorkOrderImportance) VALUES ('S03101' ,'Over 3 Months ago' ,'High')
INSERT INTO DATALOAD (WorkOrderId,AgeGroupWeek,WorkOrderImportance) VALUES ('S03091' ,'2 Months ago' ,'Low')
INSERT INTO DATALOAD (WorkOrderId,AgeGroupWeek,WorkOrderImportance) VALUES ('S03092' ,'2 Months ago' ,'Low')
INSERT INTO DATALOAD (WorkOrderId,AgeGroupWeek,WorkOrderImportance) VALUES ('S03093' ,'2 Months ago' ,'Low')
INSERT INTO DATALOAD (WorkOrderId,AgeGroupWeek,WorkOrderImportance) VALUES ('S03094' ,'1 Months ago' ,'Low')
INSERT INTO DATALOAD (WorkOrderId,AgeGroupWeek,WorkOrderImportance) VALUES ('S03095' ,'3 Weeks ago' ,'High')
INSERT INTO DATALOAD (WorkOrderId,AgeGroupWeek,WorkOrderImportance) VALUES ('S03096' ,'3 Weeks ago' ,'High')
INSERT INTO DATALOAD (WorkOrderId,AgeGroupWeek,WorkOrderImportance) VALUES ('S03097' ,'2 Weeks ago' ,'Normal')
INSERT INTO DATALOAD (WorkOrderId,AgeGroupWeek,WorkOrderImportance) VALUES ('S03098' ,'Over 3 Months ago' ,'Normal')
INSERT INTO DATALOAD (WorkOrderId,AgeGroupWeek,WorkOrderImportance) VALUES ('S03091' ,'Over 3 Months ago' ,'Normal')
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply