6 Replies Latest reply: Sep 10, 2014 5:08 PM by Caue Candeloro RSS

    Generating missing data on multiple component table

    Suzan Wijnans

      I have a table called 'Components' which contains values and begindates for several components linked to key field Employee No. (See example)

      Generating Datefields.JPG.jpg

      In my dashboard I want to select a date, and see values per component, per employee.

       

      I probably need to generate all missing dates per employee/component combination, but do not have a clue how. Do you?