Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a bar graph that shows total amount of Quotes per month from jan 2010 to september 2010 my script looks like this at the moment
LOAD
Month(ih_quodate) as [Quote Month],Text(ih_quotat) as [Quote No]; LOAD * WHERE Year([ih_quodate]) = 2010
SQL SELECT
`ih_quodate`,
`ih_quotat`
FROM
ihead;
My Bar graph seems to display coreectly and shows the correct amount of quotes for Jan but then seems to add up Febs quotes with January Quotes and the same with the rest of the months.
So January would be say 112 and febuary should be 210 but it show Februarys as 322 instead, it does this for all the other months just adding them together.
Is it possible to prevent this.?
Thanks
John
Hello John,
If you have set Month as dimension and Sum([Quote No]) as expression, make sure that in your chart properties, both "No accumulation" and "Total Modes - No totals" are checked.
Hope that helps
Hello John,
If you have set Month as dimension and Sum([Quote No]) as expression, make sure that in your chart properties, both "No accumulation" and "Total Modes - No totals" are checked.
Hope that helps