Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all
i'm new with charts.
I have bar chart. In dimention months field inserted. in expression count something.
And i want to show avarage line of months. I checked trendline avarage but it's now showing right.
Any suggestion pls.
regards
I also tried this on combo chart but failed.
Might be a versioning Problem - which version are you running?
Just tried with 10SR2 and works without a problem.
Does someone knows, how to upload a sample-file?
HTH
Peter
Please can you post the QV document with some sample data?
I checked trendline avarage but it's now showing right (Please can you explain this...)
Thanks - DV
Peter - Please click on Use advanced editor (top right on reply window). Then you will see Attach Files Option on bottom left.
Cheers - DV
in replay to proper there is use advanced editor on top right side.
ok. my expression is
count({$<month_field = {">-1<16"}>} distinct id_field)
this month_field calculated from 2 date. And it's contains some negative numbers also hight month numbers. maybe that's why trendline avarage not showing right.
Here goes the attachment (advanced - huh? )
Peter
Thanks Peter for some charts.
I realized that trendline avarage will not solve my problem. It will show only count(value) avarage right?
I don't want avarage of some counted values i want avarage of the month. If is it possible to show.
Muncho
I mean is it possible to show avarage line of dimention. In my case it's month numbers. Not avarage line of expression.
I don't get the missing point?
Peter