VTB Reporting by labels

[keithd323]

My team is marking our work as Bug, Chore and Feature by using the labels in the visual task board. I'm wanting to create a report to show to our leadership, that reflects the number of each work type we are completing per week. Our work is typically in the form of INC, TASK, SCTASK, and CHG.

I assume vtb_card is the right table, but I can't seem to create a pie chart that allows me to group by Labels as a whole, only grouping by individual labels.

Attached an example of what I am trying to get.

[Mark Roethof]

Hi there,

For Madrid the vtb_card table is indeed correct. Though be aware, in New York the structure for labels changed and this will not work anymore!
Read about the New York structure of labels in:
https://community.servicenow.com/community?id=community_article&sys_id=3a323a581b7fb348d01143f6fe4bc...
https://community.servicenow.com/community?id=community_article&sys_id=8add0d3edb94c49023f4a345ca961...

I think the New York structure also can fix your grouping issue. In Madrid, it's 7 different fields, while in New York it's just one - in a separate table - which you could simply can group.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark

---

LinkedIn
Community article list

[keithd323]

Ok, good to know I'm starting with the right table. but given the sample I attached, what would group by in order to show the different labels all at once in a pie chart? or graph?

[Mark Roethof]

You would need to group on multiple fields and only interested in the true value I guess. I don't know which labels in your case, but for example label_1, label_2, and label_3. I don't see this happening with the structure in Madrid in one single chart. Or one chart though which usage of the group by filter, so still not in one overview.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark

---

LinkedIn
Community article list

[keithd323]

There is a plus sign next to "group by", but when I try to add more than 1 item to that, it only shows and reports on the first one in the list. And yes, I would only be interested in the "true" value for each of the three labels I'm using, which are indeed label_1, label_2, and label_3. Looks to me as this is not possible in Madrid, which seems crazy that you cannot report on more than 1 label at a time since the use case for them is often times distinguishing between several categories of work. Thanks for your help Mark, looks like this is not possible today. Back to excel for reports 😞