Reporting using grouping of string field

[tahnalos]

Client is looking to report on a string field and is looking to generate a bar chart however, I have the distinct feeling that it isn't possible and would like to know some alternatives.

For some reason, a previous consultant used a short_description on a form extended from task to dump some recurring data.   When I mean recurring, I mean that there are about 20 different possible values for this field, but yet the form is about 500,000 entries big.   The intent is to grab statistics based on these 20 possible values for a given time period (usually a month)

Obviously, I would like to draw a report based on that field but I am unable to do so.   One of the other options was to copy the field in question into a smaller field then use that to group data.   That doesn't work either.

Anyone else have any ideas on how to proceed?

[sachin_namjoshi]

Hi,

You can create metric defintion based on conditions to populate metric definition table and then report on metric definition table.

Create a metric

Regards,

Sachin

[tahnalos]

Hi Sachin

It looks like I will need to extract the exact values that I want to report on and put them into the metric, right?   I'm just hoping to do a count aggregate of particular values in the string field.

Thanks

[sachin_namjoshi]

You can write metric definition script to do count of agreement of particular values in the string field.

Regards,

Sachin

[tahnalos]

Hi Sachin.   Can you provide an example when a GlideAggregate can be used in a metric?   Almost all the examples that I see of metrics seem to deal with individual records in a table.

Thanks