running values on a stacked graph

• Nomvula

  Hall of Fame

  Points: 3775

  More actions

  May 15, 2017 at 12:25 pm

  #321411

  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')