AnsweredAssumed Answered

Making a graph with data from a portal

Question asked by preziaro on Apr 3, 2014
Latest reply on Apr 3, 2014 by philmodjunk

Title

Making a graph with data from a portal

Post

     Hello everybody, 

     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...


Thanks.

Outcomes