Applying Filter on Chart's

Hi all,

In one of my reports, I have a table which I am using as a data source for a chart.

The problem lies with the filtering of data within this chart. I want to display only first 10 rows in the table and want to create a chart for only these 10 rows.

The filtering is not working in the table, thus I use the visibility option as an alternative and tried to hide the rows based on the required parameters. It worked as expected ( Although I think it's a bad approach).

But now, when I tried to use the same condition as a filter in the chart, it does not work. I am not sure why the expression works in visibility field but not as a filter. As per me, the reason chart is not taking only 10 rows could be because the rows are not filtered at all.. they're just hidden..

Any ideas would be highly appreciated.

Many Thanks,

Abhi

Find more posts tagged with

Comments

mwilliams

Hi Abhi,

What filter condition are you using on the table that's not working?

abhipro

Hi mwilliams,

To one of my previous questions, you suggested to make the aggregate column for having each row auto-numbers.

To select the first 10 rows, I am applying the condition on this column.

The visibility condition looks like:

if(row["aggregation"] > 10)
{
true
}
else
{
false
}

I assume this statement gets true whenever the row number gets greater than 10.

Now, since the filter lists all the properties separately, a similar filter would look like:

row["aggregation"] greater than 10

But this doesn't seem to work...

Regards,

Abhi

mwilliams

Abhi,

Can you reproduce your issue with the sample database so I can see exactly what your setup is? Thanks.

abhipro

Hi,

Thanks mwilliams for the reply.

I will try to generate a sample scenario and will get back to you.

Many Thanks,

Abhi