I'm doing a report on Jaspersoft, but I just want to filter by OBS.
In the "OBS Path" filter it is shown together (OBS and Location) .
How can I separate or filter it so that it only shows me the values of OBS?
My friend, I have not received help by this way Please help me
What you could do is ask CA Mexico Pre sales o CA Mexico Services, if they know anything
Could you send me the CA Mexico Pre sales o CA Mexico Services contact information?Please
I am afraid that this is not possible OOTB due to the design of the domains:
For each OBS Type (e.g. Department or Location), you will get one piece of information, e.g. the ETC hours on a project.
If you filter for Department Sales and Location London, you will get the first 3 rows which adds up the 140 hours twice.
If you only want to fitler for either Department or Location, just add the OBS Type to your filter.
If you want to filter both Department and Location, you have to transpose both values to columns using Calculated Fields:
Name "Department Path": IF("OBS Type" == 'Department', "OBS Path", null)
Name "Location Path": IF("OBS Type" == 'Location', "OBS Path", null)
Now, you can filter by both fields
I hope I could help!