Author Topic: Flexible Reporting (within CCM/ PrairieFyre)  (Read 7917 times)

Offline PuntsWorth

  • Contributer
  • *
  • Posts: 11
  • Karma: +0/-0
    • View Profile
Flexible Reporting (within CCM/ PrairieFyre)
« on: July 31, 2012, 09:58:18 AM »
Hi,

Does anyone know how to add rows to give a total.

I have tried the expression

=Fields!EmpGrpByEmpOutCount.ValueFields!EmpGrpByEmpExternalACDCount.ValueFields!EmpGrpByEmpInternalNonACDCount.Value

but doesn't work  ???


Offline kvnmiss

  • Contributer
  • *
  • Posts: 12
  • Karma: +2/-0
    • View Profile
Re: Flexible Reporting (within CCM/ PrairieFyre)
« Reply #1 on: August 13, 2012, 06:14:59 PM »
Hi PuntsWorth,

Sorry for the delay in my response. Can you provide a bit more details of what exactly you want to do? For example, this is what I would do to add a column in Flexible Reporting to do the sum of certain fields;

1. Launch Flexible Reporting and either create, modify a report.
2. Choose all the report/device types necessary.
3. Once you are in the report builder, right click on the last column and choose Insert Column > Custom. A blank Column will appear.
4. In the bottom field, right click then choose "Expression". The Expression builder will appear.
5. In the expression builder, you will have many options (Fields, Functions, Operators) to choose from to build the right expression for the report you are tailoring.
6. For example: If I want to have the sum of EmployeeGroupByAgentACDCount, EmployeeGroupByAgentNonACDCount and EmployeeGroupByAgentOutCount, here's what to do;
  • In the Expression field, start by putting the "=" sign.
  • Click on Functions > Aggregate then double-click on Sum. You will see =Sum( appear in the Expression field.
  • Click on Fields > Employee Group > double-click on EmployeeGroupByAgentACDCount.
  • Click on Operators > Arithmetic > double-click on "+"
  • Click on Fields > Employee Group > double-click on EmployeeGroupByAgentNonACDCount.
  • Click on Operators > Arithmetic > double-click on "+"
  • Click on Fields > Employee Group > double-click on EmployeeGroupByAgentOutCount.
  • Close the expression with a bracket ")"
  • Click Ok - Then you can test by using
That is one example, but you can easily see how simple and flexible the expression builder truly is.

If you need more information, feel free to PM me or continue posting on this thread.

Kind regards,

Kevin Middlemiss
prairieFyre Software inc.

Offline PuntsWorth

  • Contributer
  • *
  • Posts: 11
  • Karma: +0/-0
    • View Profile
Re: Flexible Reporting (within CCM/ PrairieFyre)
« Reply #2 on: August 22, 2012, 08:53:43 AM »
Hi PuntsWorth,

Sorry for the delay in my response. Can you provide a bit more details of what exactly you want to do? For example, this is what I would do to add a column in Flexible Reporting to do the sum of certain fields;

1. Launch Flexible Reporting and either create, modify a report.
2. Choose all the report/device types necessary.
3. Once you are in the report builder, right click on the last column and choose Insert Column > Custom. A blank Column will appear.
4. In the bottom field, right click then choose "Expression". The Expression builder will appear.
5. In the expression builder, you will have many options (Fields, Functions, Operators) to choose from to build the right expression for the report you are tailoring.
6. For example: If I want to have the sum of EmployeeGroupByAgentACDCount, EmployeeGroupByAgentNonACDCount and EmployeeGroupByAgentOutCount, here's what to do;
  • In the Expression field, start by putting the "=" sign.
  • Click on Functions > Aggregate then double-click on Sum. You will see =Sum( appear in the Expression field.
  • Click on Fields > Employee Group > double-click on EmployeeGroupByAgentACDCount.
  • Click on Operators > Arithmetic > double-click on "+"
  • Click on Fields > Employee Group > double-click on EmployeeGroupByAgentNonACDCount.
  • Click on Operators > Arithmetic > double-click on "+"
  • Click on Fields > Employee Group > double-click on EmployeeGroupByAgentOutCount.
  • Close the expression with a bracket ")"
  • Click Ok - Then you can test by using
That is one example, but you can easily see how simple and flexible the expression builder truly is.

If you need more information, feel free to PM me or continue posting on this thread.

Kind regards,

Kevin Middlemiss
prairieFyre Software inc.

Hi Kevin,

Cheers for the info, it worked but didn't give me the outcome I needed, as I don't think I have explained what I wanted correctly.

We need to add across the rows, for example;

Agent         ACD Calls         Non ACD Calls    Total
Jon                   5                         5                 10
Garry               20                        3                 23
Sarah               0                          2                 2


On your guide, it seems to count on the columns.

Is the above possible?

just to let you know, I used the following;

=Sum(Fields!EmpGrpByEmpExternalOut.Value+Fields!EmpGrpByEmpExternalACDCount.Value+Fields!EmpGrpByEmpInternalNonACDCount.Value)

Cheers
« Last Edit: August 22, 2012, 09:37:18 AM by PuntsWorth »

Offline kvnmiss

  • Contributer
  • *
  • Posts: 12
  • Karma: +2/-0
    • View Profile
Re: Flexible Reporting (within CCM/ PrairieFyre)
« Reply #3 on: August 22, 2012, 05:17:33 PM »
Hi PuntsWorth,

Thank you for the clarification. What you are attempting to do if definitely achievable. Attached to this post is an image with the right expression to use.

If you have any questions, please reply to this thread!

Cheers,

Kevin Middlemiss
prairieFyre Software Inc.


Offline PuntsWorth

  • Contributer
  • *
  • Posts: 11
  • Karma: +0/-0
    • View Profile
Re: Flexible Reporting (within CCM/ PrairieFyre)
« Reply #4 on: August 29, 2012, 08:52:51 AM »
Hi PuntsWorth,

Thank you for the clarification. What you are attempting to do if definitely achievable. Attached to this post is an image with the right expression to use.

If you have any questions, please reply to this thread!

Cheers,

Kevin Middlemiss
prairieFyre Software Inc.

Hi Kevin,

That worked 100% :) however the totals are incorrect.

the expression I am using is

Code: [Select]
=(Fields!EmpGrpByEmpExternalOut.Value+Fields!EmpGrpByEmpExternalACDCount.Value+Fields!EmpGrpByEmpExternalNonACDCount.Value)
External       External      External            Total
outbound     ACD count   Non ACD
count                               Count

5            3             0          8
7            3             0       11
8            3                 0       11
22            2             1                   24
14            2             0                   16
5                       2             0                     7
16            2             0                   18
20            1             0                   22
0            0             0        1
10            1             2                  14
3                  1             0        4
0           0             0        0
15           0             0        16
0           0             0       4
8           0             0        8
8           0             0        10

Offline boycey9

  • Full Member
  • ***
  • Posts: 182
  • Karma: +4/-0
    • View Profile
Re: Flexible Reporting (within CCM/ PrairieFyre)
« Reply #5 on: September 07, 2012, 10:33:15 AM »
Im no expert on flexible reporting but at a guess from your results i would say there is some rounding up/down going on for some reason.
In Excel there are ways of using whole integers only, maybe this will set you in the right direction.


 

Sitemap 1 2 3 4 5 6 7 8 9 10