Several custom attributes in one report row?

Hi!

I need to put together a report to compare story estimates with the total of estimates defined in the children tasks. Story estimates are defined as two integers (aggressive and probable) and stored as two custom attributes on the Story level. I can create a data set based on LIVE_WORKITEM_CNT table and include STRING_KEY as a parameter. STRING_VAL column will contain the value. The problem is, I need TWO custom attributes at once, on the same row. How can I get several custom attributes in the same data set, in the same row?

Thanks in advance, Dmitry

Hi bisikalo,

I suggest you first try to make one data set which will contain first custom attribute, for example, if you have first custom attribute called aggresive_int, from LIVE_WORKITEM_CNT pick next columns:
WI_ID, INTEGER_KEY and INTEGER_VAL.
While you have been editing this data set, pick filters, and create one by picking INTEGER_KEY and as filter value type: aggresive_int. This data set will return rows with this value and belonging WI_ID. Then, create another data set, similar to this, which will contain another integer value, for example, probable_int, and make filter with this.
Third step is to create joined data set, which will contain previous datasets, joined by WI_ID.
Then, drop your joined data set to report, and you'll get both integer values in same row.

P.S. If you have a custom attribute with type small or medium html, you need to pick STRING_KEY and STRING_VAL, but in your way, you need to choose INTEGER_KEY and INTEGER_VAL.

Hope this helps,

Regards,

Hi bisikalo,

Another way of doing this is to define multiple datasets to retrieve all these attributes. Mark them as hidden in the display. For each row retrieved, update a java script array (which will reflect your final output).

Finally, define a scripted dataset which retrieves and displays data from the javascript array you created.

Hope this helps