AnsweredAssumed Answered

Create chart by combining 2 tables

Question asked by vaishnavi on Nov 14, 2017
Latest reply on Nov 14, 2017 by philmodjunk



I need help in building a chart.I have a Users table(which has userID,username,groupname of each user) and SampleInfo (includes SampleInDate,Sample RemovedDate,userid)table.And I need to create a chart to show the number of  "Active Records"  per groupname.   "Active Records" are entries which have "Sample Removed Date"empty.So I need to create chart with Group name on the x axis and the number of records on Y axis. Can anyone help me with it.

Below is sample entry page.