top in the chart

vladsn07 · Post by **vladsn07** » Wed Mar 29, 2017 4:19 pm

How to set the top in the chart. Those. In the diagram output only the first 10 or 15 conditions.

It is necessary to display only the first 10 data from the report

arbei · Post by **arbei** » Fri Mar 31, 2017 11:28 am

Setup "Records per page" to 10 and hide the paging section with jQuery .hide() function in Startup Script.

For example:
$(".panel-footer").hide();

vladsn07 · Post by **vladsn07** » Fri Mar 31, 2017 12:37 pm

Where do I set this parameter?

I need to output the amount in the diagram that is indicated in the panel-footer

Example

Page << < 1 > >> of 12878 Records 1 to 5 of 64389 5

On the table there are 5 lines, accordingly to deduce 5 positions in the diagram

arbei · Post by **arbei** » Sat Apr 01, 2017 11:42 am

Records Per Page is in [TABLE] -> [Table-specific Options].

And use the jQuery function in "Server Events and Client Scripts" -> "Startup Scripts"

Read help file topic: "Project Setup" -> "Table Setup" and "Server Events and Client Scripts" -> "Startup Scripts".

vladsn07 · Post by **vladsn07** » Tue Apr 04, 2017 4:49 am

I have 4 columns. Id, date, number1, number2. It is necessary to display in the table the sum of all numbers by number1 + number2 and display them on the diagram as a percentage number / number2, for example 30% and 70%. If the number of id is too much, then output only the first 10, coming from the sorted table.

In my case, the number 1 and the number 2 depend on other data that I specify in the filters.

t-sql:
Select dbo.we_OrgUnits.Description Department,
dbo.we_Computers.FriendlyName Inv â„–,
dbo.we_SummaryActivities.LogDate Date,
dbo.we_SummaryActivities.ActivityTime ActivityTime,
dbo.we_SummaryActivities.ForegroundTime ForgeroundTime
From dbo.we_Computers
Inner Join dbo.we_SummaryActivities On dbo.we_SummaryActivities.ComputerId =
dbo.we_Computers.ComputerId
Inner Join dbo.we_OrgUnits On dbo.we_OrgUnits.OrgUnitId =
dbo.we_Computers.ParentId

ActivityTime - number1
ForgeroundTime - number2

arbei · Post by **arbei** » Wed Apr 05, 2017 3:05 pm

If you want to show the value number1 + number2 and percentage of number1/number2, you can use the feature custom field.
Read help file topic: "Project Setup" -> "Custom Field" for more information.

arbei · Post by **arbei** » Mon Apr 10, 2017 11:29 am

To show the first 10 records in your database view, set up the "Records Per Page" is in [TABLE] -> [Table-specific Options].
Then hide the pager with the "Startup Script".

(Refer to the previous post)

And create 2 custom field to show the SUM and Percentage of the "ActivityTime" and "ForgeroundTime"

For example:
Field Name: Sum_Time
Caption: Sum_Time
Expression: ActivityTime + ForgeroundTime

Field Name: Percentage_Time
Caption: Percentage_Time
Expression: ActivityTime / (ActivityTime + ForgerounTime) * 100

Read help file topic: "Project Setup" -> "Custom Field" for more information.

vladsn07 · Post by **vladsn07** » Thu Apr 20, 2017 10:51 pm

I want to display only 5 first values from the view. Now everyone comes out, i.e. All 50

arbei · Post by **arbei** » Fri Apr 21, 2017 10:07 am

To show the specific number of records in your database view, set up the "Records Per Page" is in [TABLE] -> [Table-specific Options].

vladsn07 · Post by **vladsn07** » Thu Apr 27, 2017 10:18 pm

This concerns the table, how does this parameter pass the Chart?

arbei · Post by **arbei** » Fri Apr 28, 2017 12:36 pm

vladsn07 wrote:
This concerns the table, how does this parameter pass the Chart?

It is not supported.

vladsn07 · Post by **vladsn07** » Fri Apr 28, 2017 1:41 pm

Thanks, understand

vladsn07 · Post by **vladsn07** » Thu May 04, 2017 2:30 pm

I did not understand how to output a limited amount of data to the chart? Example: TOP 10

arbei · Post by **arbei** » Fri May 05, 2017 10:03 am

You cannot limit the number of records output to the chart, you can only filter the records. (The data for the report is the same as that for the chart.)

Or you can try to remove some node from the chartxml in Chart_Rendered Server Event.

Read the help file topic: "Server Events and Client Scripts" -> "Chart_Rendered" for more information.

vladsn07 · Post by **vladsn07** » Fri May 05, 2017 1:53 pm

Thanks, understand