Error in order of data in progress component

Stimulsoft Dashboards.JS discussion
Post Reply
anderson_andrade
Posts: 8
Joined: Sun Mar 19, 2017 11:21 pm

Error in order of data in progress component

Post by anderson_andrade »

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
Attachments
With "Top N" settings
With "Top N" settings
error_progress2.png (57.68 KiB) Viewed 3059 times
Without "Top N" settings
Without "Top N" settings
error_progress1.png (42.03 KiB) Viewed 3059 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Error in order of data in progress component

Post by HighAley »

Hello,

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

Thank you.

Ticket reference: #2343
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Error in order of data in progress component

Post by HighAley »

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.
anderson_andrade
Posts: 8
Joined: Sun Mar 19, 2017 11:21 pm

Re: Error in order of data in progress component

Post by anderson_andrade »

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.
Attachments
ReportErrorSample.mrt
(11.78 KiB) Downloaded 198 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Error in order of data in progress component

Post by HighAley »

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.
anderson_andrade
Posts: 8
Joined: Sun Mar 19, 2017 11:21 pm

Re: Error in order of data in progress component

Post by anderson_andrade »

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.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Error in order of data in progress component

Post by HighAley »

Hello,

You could use the next expression in Filter:
TopYear.png
TopYear.png (7.01 KiB) Viewed 2721 times
Thank you.
Post Reply