How can I get some data with expressions
How can I get some data with expressions
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.
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.
-
- Posts: 6302
- Joined: Tue Mar 20, 2018 5:34 am
Re: How can I get some data with expressions
Hello,
Please send us a sample report with test data for analysis.
Thank you.
Please send us a sample report with test data for analysis.
Thank you.
Re: How can I get some data with expressions
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.
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 200 times
-
- Posts: 6302
- Joined: Tue Mar 20, 2018 5:34 am
Re: How can I get some data with expressions
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.
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 (81.76 KiB) Viewed 2293 times
Re: How can I get some data with expressions
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.
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.
-
- Posts: 6302
- Joined: Tue Mar 20, 2018 5:34 am
Re: How can I get some data with expressions
Hello,
The new build 2022.3.4 will be available within one or two days.
Thank you.
The new build 2022.3.4 will be available within one or two days.
Thank you.
Re: How can I get some data with expressions
Ok, thank you for the information. Have a nice day!
-
- Posts: 6302
- Joined: Tue Mar 20, 2018 5:34 am
Re: How can I get some data with expressions
Hello,
You are welcome.
You are welcome.
Re: How can I get some data with expressions
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
Shall I change something more to be able to work with the new build?
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
*/
-
- Posts: 6302
- Joined: Tue Mar 20, 2018 5:34 am
Re: How can I get some data with expressions
Hello,
We couldn't reproduce the issue.
Please send us a sample project that reproduces the issue for analysis.
Thank you.
We couldn't reproduce the issue.
Please send us a sample project that reproduces the issue for analysis.
Thank you.