I have the following thing at the moment:
[ Delivery Charge:1, 1]
>>
Tickets has|Count
{REPORT TICKET DETAILS:TT.Delivery Charge,CA.Delivery Charge:(TT=Delivery Charge) and T.TotalAmount>0}
This generates the following report:
So i would like to show three rows now:
40 Baht 9 Tickets
60 Baht 3 Tickets
Free 1 Tickets
So my question is how do i cumulate this whole thing?
Its being very difficult not having any documentation for all these parts.
Is there is print_r equivalent to show the report object structures ?
Youll need to define a list of tags with an @ list, think there is a tag list report but never used so @ comma,list
Then in the report/table under it ad (TT.Delivery Charge=$1) and the @ list will feed in the values of the list and repeat rows for each value.
I have been trying to figure out this @ thing… I think im not understanding yet how exactly this works.
here is my query so far:
[Delivery Charge:1, 1,1]
>>
Tickets has|Total
@{REPORT TICKET DETAILS:TT.Delivery Charge,CA.Delivery Charge.Sum.desc:T.TotalAmount>0:{0}:,}
{REPORT TICKET DETAILS:TT.Delivery Charge,CA.Delivery Charge.Sum:TT.Delivery Charge="$1"}
But i get an empty table result.
I still need to figure out how to get the total count. i.e. the number of tickets/rows that match per “$1”
{REPORT TICKET DETAILS:TT.Delivery Charge,CA.Delivery Charge:(TT=Delivery Charge) and T.TotalAmount>0}
This query does return a result though.
maybe just try something like this
@10 Baht,20 Baht,30 Baht,40 Baht,50 Baht,60 Baht,70 Baht,80 Baht,90 Baht,100 Baht
$1|{REPORT TICKET DETAILS:TT.Delivery Charge.Count:(TT=$1) and T.TotalAmount>0}
1 Like
You Rock!
Works like a charm. Thanks a lot!
You owe me a pizza when I go back to Thailand