I am trying to do a count of and id column [pps] to show me how many were created on a certain date.
I need to filter this data based on the date from 2 different columns. [date_pps] and [date_ship]
(http://bakerabilene.com/home/cognos_filter.png)
To create the table from the image I had each data item setup like so
PPS_PRINTED
if
([date_pps]=?prompt_date?)
then
([pps])
else null
PPS_SHIPPED
if
([date_ship]=?prompt_date?)
then
([pps])
else null
I then had to do the same for the PPS Lines.
It is working but is very slow and I feel its because I am not doing something obvious.
Is there a better way to do what I am trying to achieve?
Another option would be to create two separate queries, one for 'print' and one for 'ship', then union them together. You would have to change how you calculate % shipped so it may or may not be that helpful.