Performance Analytics - Use field values

[jonathan_living]

Hi all,

I'm attempting to put together a Dashboard that collects data from a single table and uses field values. It's a table that has a reference to a group and a number of integer fields that hold the interested data. As an example, one of the fields is a count of the members in the group. I'd like to be able to show over time the value stored in that field. The field is audited, so I think I can get historical data. If not possible, I'm fine with starting now and going forward. However, I don't see in the breakdown how to collect these specific fields. I've tried adding a breakdown mapping, but I don't think that's right. I have roughly 7 fields I'd like to track and put onto the Dashboard. I tried a Breakdown script using the same logic in the online training material, but I can't get anything to work other than getting the matching number of overall records on table. Any guidance here would be greatly appreciated.

[AndersBGS]

Hi @jonathan_living ,

Why not just create an automated indicator that captures the amount of users within that specific group. You will get same result but without the custom field. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[jonathan_living]

Thanks for the response. While that's a viable option, my preference is to leverage the data I already have. The table contains various statistics for a point it time and the group membership is only one of several fields, some of which have complex calculations to obtain the value. 

[AndersBGS]

Hi @jonathan_living ,

Allright, In general if you would like to track field changes over time, metrics could be utilized to capture the changes together with time/date etc. of the change. Afterwards, the reporting needs can be created based on the metrics.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[tresener]

@jonathan_living did you find a solution?