How can I get some data with expressions

Stimulsoft Dashboards.WEB discussion
ArnauINFR
Posts: 21
Joined: Fri Nov 05, 2021 10:01 am

How can I get some data with expressions

Post by ArnauINFR »

Hi I have a chart with some projects with the time spent in each project. And I would like to recover only the 3 projects with more time spent i know there's an expression site to write it but i don't really know how to build that expression.
Also can I put a filter for, for example instead of only see 3 projects be able to see more like the 5 projects or something like that?

The DataSource is a simple .xls
Sheet1.Time and Sheet1.Project are the columns.
Thanks for help.
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: How can I get some data with expressions

Post by Lech Kulikowski »

Hello,

Please send us a sample report with test data for analysis.

Thank you.
ArnauINFR
Posts: 21
Joined: Fri Nov 05, 2021 10:01 am

Re: How can I get some data with expressions

Post by ArnauINFR »

Here you have a sample. Its just a Chart with some data.
The case is that I just wanna only see the top 3 Projects or if I can be able to choose how many projects see in order of how many hours have each project.
Attachments
Sample.mrt
(13.05 KiB) Downloaded 185 times
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: How can I get some data with expressions

Post by Lech Kulikowski »

Hello,

You can use the Skip and Limit Rows option in the DataTransfromation for the Chart. It will work strat from 2022.3.4 build version.

Thank you.
Attachments
Screenshot 2022-08-02 103957.png
Screenshot 2022-08-02 103957.png (81.76 KiB) Viewed 2182 times
ArnauINFR
Posts: 21
Joined: Fri Nov 05, 2021 10:01 am

Re: How can I get some data with expressions

Post by ArnauINFR »

Hi, thanks for reply. Right now I'm using 2022.3.3
Where can I find 2022.3.4 build files to be able to test it by myself.
The online demo uses 2022.3.2 and I guess won't work too.
I saw the error in my version that doesn't save well the results when I apply the skip and limit rows.
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: How can I get some data with expressions

Post by Lech Kulikowski »

Hello,

The new build 2022.3.4 will be available within one or two days.

Thank you.
ArnauINFR
Posts: 21
Joined: Fri Nov 05, 2021 10:01 am

Re: How can I get some data with expressions

Post by ArnauINFR »

Ok, thank you for the information. Have a nice day!
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: How can I get some data with expressions

Post by Lech Kulikowski »

Hello,

You are welcome.
ArnauINFR
Posts: 21
Joined: Fri Nov 05, 2021 10:01 am

Re: How can I get some data with expressions

Post by ArnauINFR »

Hi, I saw you just uploaded the 2022.3.4 build I just only changed the files that were modified on the git (all css, all scripts, helper, all adapters, english language).
But in my Designer seems like I'm using 2022.3.3 build. I uploaded all files to the server and I checked manually all files start with

Code: Select all

/*
Stimulsoft.Reports.JS
Version: 2022.3.4
Build date: 2022.08.02
License: https://www.stimulsoft.com/en/licensing/reports
*/
Shall I change something more to be able to work with the new build?
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: How can I get some data with expressions

Post by Lech Kulikowski »

Hello,

We couldn't reproduce the issue.
Please send us a sample project that reproduces the issue for analysis.

Thank you.
Post Reply