Limiting bars on a chart?

Hi, I have a chart control that is working very nicely indeed.
Is there a simple way to limit the number of bar that are drawn? I.e. I only
want say the top 10 bars showing. My dataset is large and displayed 300 bars
is too much/a mess.
I dont want to filter the dataset, as the bars are constructed from
aggregate data (sums and counts). I do not see a simple limit, or am I
missing something?
Any tips appreciated!
Kind regards
TazYou can use the TOP(N) on the dataset then link ht echart to that dataset.
"Tarun Mistry" <nospam@.nospam.com> wrote in message
news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
> Hi, I have a chart control that is working very nicely indeed.
> Is there a simple way to limit the number of bar that are drawn? I.e. I
> only want say the top 10 bars showing. My dataset is large and displayed
> 300 bars is too much/a mess.
> I dont want to filter the dataset, as the bars are constructed from
> aggregate data (sums and counts). I do not see a simple limit, or am I
> missing something?
> Any tips appreciated!
> Kind regards
> Taz
>|||Hi Ben, thanks for the response below.
I have tried this and am having problems, please see my post below. What
would you suggest? How can I use the TOP N syntan on an aggregate field?
Thanks
Taz
"Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
news:%23FmNoPe0GHA.5072@.TK2MSFTNGP03.phx.gbl...
> You can use the TOP(N) on the dataset then link ht echart to that dataset.
> "Tarun Mistry" <nospam@.nospam.com> wrote in message
> news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Hi, I have a chart control that is working very nicely indeed.
>> Is there a simple way to limit the number of bar that are drawn? I.e. I
>> only want say the top 10 bars showing. My dataset is large and displayed
>> 300 bars is too much/a mess.
>> I dont want to filter the dataset, as the bars are constructed from
>> aggregate data (sums and counts). I do not see a simple limit, or am I
>> missing something?
>> Any tips appreciated!
>> Kind regards
>> Taz
>|||go to your category group in you chart that you want to limit and edit it
and click the filter tab. In the expression enter the value formula then us
e the top N in the formula column, and =10. That just worked for one of my
charts. If you have any problems i will explain it better.
"Tarun Mistry" <nospam@.nospam.com> wrote in message
news:OMNq%23re0GHA.5100@.TK2MSFTNGP05.phx.gbl...
> Hi Ben, thanks for the response below.
> I have tried this and am having problems, please see my post below. What
> would you suggest? How can I use the TOP N syntan on an aggregate field?
> Thanks
> Taz
> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
> news:%23FmNoPe0GHA.5072@.TK2MSFTNGP03.phx.gbl...
>> You can use the TOP(N) on the dataset then link ht echart to that
>> dataset.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Hi, I have a chart control that is working very nicely indeed.
>> Is there a simple way to limit the number of bar that are drawn? I.e. I
>> only want say the top 10 bars showing. My dataset is large and displayed
>> 300 bars is too much/a mess.
>> I dont want to filter the dataset, as the bars are constructed from
>> aggregate data (sums and counts). I do not see a simple limit, or am I
>> missing something?
>> Any tips appreciated!
>> Kind regards
>> Taz
>>
>|||Let me try to explain again. Put your sum or count formula from your value
field into the expression column. Use the Top N from the operator column
and put =10 in the value column. DO all of this in the category group that
you want filtered.
"Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
news:uEOrEye0GHA.1256@.TK2MSFTNGP04.phx.gbl...
> go to your category group in you chart that you want to limit and edit it
> and click the filter tab. In the expression enter the value formula then
> us e the top N in the formula column, and =10. That just worked for one
> of my charts. If you have any problems i will explain it better.
> "Tarun Mistry" <nospam@.nospam.com> wrote in message
> news:OMNq%23re0GHA.5100@.TK2MSFTNGP05.phx.gbl...
>> Hi Ben, thanks for the response below.
>> I have tried this and am having problems, please see my post below. What
>> would you suggest? How can I use the TOP N syntan on an aggregate field?
>> Thanks
>> Taz
>> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
>> news:%23FmNoPe0GHA.5072@.TK2MSFTNGP03.phx.gbl...
>> You can use the TOP(N) on the dataset then link ht echart to that
>> dataset.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Hi, I have a chart control that is working very nicely indeed.
>> Is there a simple way to limit the number of bar that are drawn? I.e. I
>> only want say the top 10 bars showing. My dataset is large and
>> displayed 300 bars is too much/a mess.
>> I dont want to filter the dataset, as the bars are constructed from
>> aggregate data (sums and counts). I do not see a simple limit, or am I
>> missing something?
>> Any tips appreciated!
>> Kind regards
>> Taz
>>
>>
>|||Ben, I am SUCH an idiot.
Your advise is flawless and what you state is correct. Unfortunately, this
is what I was doing and wasn't seeing the results I wanted. The reason why?
Many of my columns have the same value (e.g. 4) so when limiting to the top
10, i wondered why I could still see 16+, the last 8 fields were all the
same value.
I wonder if this should be happening. I would like to purge my set to
exactly 10, not 12, 13 etc etc. Any ideas? Possibly a second filter that
filters on date?
Taz
"Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
news:%23Bx$v0e0GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Let me try to explain again. Put your sum or count formula from your
> value field into the expression column. Use the Top N from the operator
> column and put =10 in the value column. DO all of this in the category
> group that you want filtered.
> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
> news:uEOrEye0GHA.1256@.TK2MSFTNGP04.phx.gbl...
>> go to your category group in you chart that you want to limit and edit it
>> and click the filter tab. In the expression enter the value formula then
>> us e the top N in the formula column, and =10. That just worked for one
>> of my charts. If you have any problems i will explain it better.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:OMNq%23re0GHA.5100@.TK2MSFTNGP05.phx.gbl...
>> Hi Ben, thanks for the response below.
>> I have tried this and am having problems, please see my post below. What
>> would you suggest? How can I use the TOP N syntan on an aggregate field?
>> Thanks
>> Taz
>> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
>> news:%23FmNoPe0GHA.5072@.TK2MSFTNGP03.phx.gbl...
>> You can use the TOP(N) on the dataset then link ht echart to that
>> dataset.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Hi, I have a chart control that is working very nicely indeed.
>> Is there a simple way to limit the number of bar that are drawn? I.e.
>> I only want say the top 10 bars showing. My dataset is large and
>> displayed 300 bars is too much/a mess.
>> I dont want to filter the dataset, as the bars are constructed from
>> aggregate data (sums and counts). I do not see a simple limit, or am I
>> missing something?
>> Any tips appreciated!
>> Kind regards
>> Taz
>>
>>
>>
>|||I have a report that does the exact same thing. I still couldnt get it
quite perfect but i did narrow it down by setting a filter on the chart that
said my value needed to be greater than a specific amount and that took some
off.
"Tarun Mistry" <nospam@.nospam.com> wrote in message
news:uF5ETCf0GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Ben, I am SUCH an idiot.
> Your advise is flawless and what you state is correct. Unfortunately, this
> is what I was doing and wasn't seeing the results I wanted. The reason
> why? Many of my columns have the same value (e.g. 4) so when limiting to
> the top 10, i wondered why I could still see 16+, the last 8 fields were
> all the same value.
> I wonder if this should be happening. I would like to purge my set to
> exactly 10, not 12, 13 etc etc. Any ideas? Possibly a second filter that
> filters on date?
> Taz
>
> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
> news:%23Bx$v0e0GHA.1252@.TK2MSFTNGP04.phx.gbl...
>> Let me try to explain again. Put your sum or count formula from your
>> value field into the expression column. Use the Top N from the operator
>> column and put =10 in the value column. DO all of this in the category
>> group that you want filtered.
>> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
>> news:uEOrEye0GHA.1256@.TK2MSFTNGP04.phx.gbl...
>> go to your category group in you chart that you want to limit and edit
>> it and click the filter tab. In the expression enter the value formula
>> then us e the top N in the formula column, and =10. That just worked
>> for one of my charts. If you have any problems i will explain it
>> better.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:OMNq%23re0GHA.5100@.TK2MSFTNGP05.phx.gbl...
>> Hi Ben, thanks for the response below.
>> I have tried this and am having problems, please see my post below.
>> What would you suggest? How can I use the TOP N syntan on an aggregate
>> field?
>> Thanks
>> Taz
>> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
>> news:%23FmNoPe0GHA.5072@.TK2MSFTNGP03.phx.gbl...
>> You can use the TOP(N) on the dataset then link ht echart to that
>> dataset.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Hi, I have a chart control that is working very nicely indeed.
>> Is there a simple way to limit the number of bar that are drawn? I.e.
>> I only want say the top 10 bars showing. My dataset is large and
>> displayed 300 bars is too much/a mess.
>> I dont want to filter the dataset, as the bars are constructed from
>> aggregate data (sums and counts). I do not see a simple limit, or am
>> I missing something?
>> Any tips appreciated!
>> Kind regards
>> Taz
>>
>>
>>
>>
>