car;Essentials;1;610.96;event22=610.96;;,
Add-ons;Breakdown;1;73.99;;;,
Add-ons;Motor Legal;1;24.95;;;,
Add-ons;Hire Car;1;19.99;;;
This is a style of the string I'm sending
@samma10 right, and all of these have revenue associated to them.
But I imagine the way you were talking, you might also have some free optional items, so:
car;Essentials;1;610.96;event22=610.96;,
Add-ons;Breakdown;1;73.99;;,
Add-ons;Motor Legal;1;24.95;;,
Add-ons;Hire Car;1;19.99;;,
optional;something;1;0;;
For the record, you don't actually need to have all the ; at the end of each item (unless that's just the way your code is adding things regardless of values in those positions).
The problem here is that revenue isn't a dimension, it's not filterable.
What I was saying would be to add an "is free" merchandising eVar using true/false.
So:
car;Essentials;1;610.96;event22=610.96;eVarX=false,
Add-ons;Breakdown;1;73.99;;eVarX=false,
Add-ons;Motor Legal;1;24.95;;eVarX=false,
Add-ons;Hire Car;1;19.99;;;eVarX=false,
optional;something;1;0;;eVarX=true
Then you can filter based on eVarX being true... or rather, you can't use segments at this time to only get some of the products back, but you can do dimension breakdowns..
So in your table, you can pull in eVarX "true" as the top item, then break it down by products to only see the "free" ones:
| |
|
|
|
Metric |
| Is Free (eVarX) |
|
|
|
10 |
| |
true |
|
|
10 |
| |
|
Products |
|
10 |
| |
|
|
Free Product 1 |
5 |
| |
|
|
Free Product 2 |
3 |
| |
|
|
Free Product 3 |
2 |
