Clarity

How to Remove Adjusted Hours from Jaspersoft Ad-Hoc View

  • 1.  How to Remove Adjusted Hours from Jaspersoft Ad-Hoc View

    Posted Dec 11, 2017 03:50 PM

    Hi All,

     

    We have built a custom Ad-Hoc view using OOTB source - Time Management.

     

    In this crosstab report we have kept Period Finish Date as Column. Resource Manager, Resource Name, Investment Name as Rows, Time Entry Hours as Measure

     

    As a filter we are using Period Finish date with  is after function, Resource Employment Type with is one of Function, Resource Name with is one of function with some fixed resources

     

    The report works fine when there is no adjustment timesheet. Problem happens when there is a timesheet adjustments as it shows the entire hours. E.g. if for 1 week lets say i have put 80 hrs which i have then updated to 40 hrs

     

    So, that means 80 hours would have status as Adjusted and 40 hrs will be Posted (Adjustment). The reports aggregate both and shows 120 hrs for that week for that resource instead of showing 40 hrs which is final

     

    I tried to use Adjustment as a Filter with all function available like is one of, equal to etc etc but no luck as it does not give desired output

     

    I also tried to build a calculated attribute to get similar output but could not using the limited functions

     

    Could you please help me how can i fix this to get the corrected data

     

    Regards\\Avik