I have several fields, prmTIXQTY, filedate and prmBUYERTYPE.
What I want to do is create a chart that shows the number of tickets sold (prmTIXQTY) by all buyer types [prmBUYERTYPE) except one (STH) over the course of time (filedate)
The problem that I am running into is that the data seems to aggregate (keeps adding in some way that I am not sure of) I choose full accumulation and no accumulation and the problem is the same.
Ideally, the data should be:
filedate prmTIXQTY prmBUYERTYPE Sum
10/1 100 Adult 100
10/2 50 Adult 12
So, I want to show that on 10/1 there were 100 tickets sold and on 10/2 there were 50 tickets sold. (Using full accumulation I can show where the number of tickets sold over all is) but I want to shows the number sold each day.
It sounds like a straight table with prmBUYERTYPE and filedate as dimensions and sum(prmTIXQTY) should be all you need. If you want to except the buyertype STH then use this expression:
sum({$-<prmBUYERTYPE={'STH'}>}prmTIXQTY).
You don't need to enable accumulation unless you want each rows value to be the sum of the previous rows values and the current one.
It sounds like a straight table with prmBUYERTYPE and filedate as dimensions and sum(prmTIXQTY) should be all you need. If you want to except the buyertype STH then use this expression:
sum({$-<prmBUYERTYPE={'STH'}>}prmTIXQTY).
You don't need to enable accumulation unless you want each rows value to be the sum of the previous rows values and the current one.
