Making a graph with data from a portal
First of all, thanks for helping me to solve this problem:
I have a table embedded as a portal in my FM database . This table contains many products, with the date of usage (beginning and ending) for each product.
One product might appear on many different line at different period of time ( each defined with a date of beginning and ending).
I want to calculate the duration of usage of each product but not only line by line but a cumulated duration.
I then want to use this information to make a graph in bars that will include the cumulated duration of each product one by one.
Waiting for your comments and input...