Creating reports and dashboards | Stimulsoft community forum

When I'm using a progress without defining "Top N", the ordering is ok. But, when I define a "Top N" value, the ordering does not follow the series nor the Data Transformer

Can reproduce with this example
https://demo.stimulsoft.com/#Net/Dashbo ... Statistics

Hello,

We will discuss your team and will let you know about results.

Thank you.

Ticket reference: #2343

Hello,

The color is not connected to the value.
The TopN feature show highest values not percentage.

We will discuss with our team if this behavior right and will let you know about our decision later.

Thank you.

Hello,

The color is not the problem.

The value is the problem.

When I use Year in series with TopN, I want to show the years in order (2020, 2019, 2018), but the value change the order (2020, 2017, 2019).

If i disable TopN the component respect the "Data Transform" I'm using.

I tink, the component should respect the "Data transform" when i use TopN too.


@edit
including an attachment with an example.


Thank you.

Hello,

The TopN feature looks at the Value.
It will not work by checking the Series.
If you need to show data for several years you could set the Filter.

The TopN feature is added for cases when Filter can't be applied.

Thank you.

Hello,

Got it.

In the example above, how could I filter the last 3 years, without setting the fixed values (2020, 2019, 2018)?

Because on my dashboard, these will not always be the last 3 years, so I need something dynamic.

Thank you.

Hello,

You could use the next expression in Filter: Thank you.