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]

I think the table structure is just the issue. So it's a good thing they changed this in New York. Also with New York this gives the freedom of creating additional labels or actually removing labels. Though looking at the table, it's actually all the same field because it's on a new m2m table. Which you could reference, etc.. Though also... easily report on.

For example, with 3 or 4 clicks, in New York I can easily report on the labels on VTB Cards used:

Upgrade asap 🙂

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

Kind regards,
Mark

---

LinkedIn
Community article list

[keithd323]

We actually have our test environment at New York, and will be upgrading Production in a couple weeks to New York, so that is great news! I've been trying to get these results in our test environment though, and still not succeeding for one reason or another.

Having said that, a couple clarifications please.

TABLE: To get the graph above, did you used Many-to-Many tagged object (sqanda_tag_entry) or the Visual Task Board Card (vtb_card) as your table for the report? You had mentioned m2m, i assume the one mentioned earlier is what you were referring to.

GROUP BY: After trying both, I'm still not able find labels as something I can group by. only Label_1, Label_2, etc. What are you using for group by? did you have to go to related tables of some sort?

FILTER CONDITIONS: The only thing I suspect to add here is the board I am reporting on. Is there anything else you had to add?

[keithd323]

Also, it appears that the graph above is only reporting on how many labels their are, on a specific board. Not how many times each label has been applied to a card, which is what I'm after. Am I mistaken here?

[karsrao]

I had similar requirement was able to achieve by creating a database view (join vtb_card and label_entry)