Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Cumulative value with Date table

Hello to everyone,

 

first of all i am a newb

i have 2 tables :

1 - drawings list with release date given by the consultant.

2 - drawings list export from our CDE (or electronics data base of drawings available for everyone on site). This table containes date of the release of the drawings.

 

As i need to create 2 Scurve (table 1 vs table 2) i created a date table and create a relationshio between Date_table and table 1 and Date_table and table 2.

I created in table 1 and 2 a measure of cumulative count of drawings which works fine. Graphics is a perfect s curve.

But as soon as i tried to combine all in one graphics, the cumulative measure doesn't work, instead of counting, it just shows the value at the dedicated date.

I think it's a basic mistake for you but i would really appreciate your help.

Thank you very much

Jeff

 

 

1 Reply

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion

    try switching the bidirectional relationships to single and make sure the months in the charts are coming from the DATE_TABLE