I need help with particular functionality.
I have created a data type (X) to allow users to define certain metrics (with data fields like metric name, type, description, method, etc).
Now, I want the users to update values of on those defined metrics (existing as data in X) on a weekly basis and create a table/chart (more like an MIS).
I think this can be done in two ways:
- By converting the data field inputs (metric details) from a particular data type (X) into new data fields of another data type.
- By adding new data fields corresponding to each week in the same data type (X).
I am not able to figure out a way how to execute either of these. Please help me with this, and also let me know if there is any other way to go about it.