Filter data in chart (OData)

[l.kozien]

Hi,

After spending 2 days searching for the answer I decided to create this post.
I need help with following problem:
I created table based on OData DataSource. Content of the table is filtred by 6 different values requested by users. Next I created chart to display the table.
The chart displays whole datasource. I want to filter the chart the same way I filter my table.

I tried creating new datasource based on datasource used in table with aggregation functions. I tried to use the same variables to filter this datasource, but nothing seems to work so far. Is there any possibility to solve this problem?

Thanks in advance for any answers.

[Alex K.]

Hello,

Please try to set the DataSource and Filter properties for the Chart component.

Thank you.

[l.kozien]

Hello,

Filters in chart datasources support only filtering by value and expression, but the expression I used to filter datatable doesn't work (checking if my list variable contains argument of series).

[Alex K.]

Hello,

Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

[l.kozien]

Hello,

Thank you for response, we resolved this problem by using complicated filter (comparing to boolean value of expression - ListVariable.Contains(fieldFromDatasource)).

[HighAley]

Hello.

Great.
Let us know if you need our help.

Thank you.