How to display report based on 2 fields

[Renu9]

Hi All,

I have created a bar report where I am grouping by the field 'Supply' , I also have another field 'quantity' for each record . I have to display quantity on the data label for the particular supply and not the tickets count.

Please find below screenshot where it is displaying supply with ticket count on data label

Here 3 and 1 are the number of tickets that are with advert panels and halos, but I want the for the quantity '5' , advert panels are shown.

How is that possible?

[AndersBGS]

Hi @Renu9 ,

It's not possible according to you have a "string" type field. Either you need to recreate the field as an numeric field and copy the value by some scripting. Alternative you need yo create your report through performance analytics with a automated scripted indicator.

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

best regards

Anders 

[AndersBGS]

Hi @Renu9 

if my answer has helped with your question, please mark my answer as accepted solution.

Best regards

Anders