Trial - Needing Help Formating Data


https://www.nevron.com/Forum/Topic8291.aspx 		Print Topic | Close Window

By Justin Payne - 11 Years Ago
I am in the process of trialing Nevron Chart for SharePoint. I am trying to basically do a proof of concept with our Help Desk Data. I would like to do a chart that shows number of open tickets by Tech. The fields I believe I need to use are ASSIGNEES (Tech) and STATUS (Closed, Working, etc) my thought process is do get a row count on status (Filtering by "Working") then do a category (group) of ASSIGNEES. However it doesn't show any data. So I am struggling here..

For the count here is what my value looks like Count(Fields!mrSTATUS) my categories value is =Fields!mrASSIGNEES then my filter is =Fields!mrSTATUS="Working"

I am sure it's my syntax but I just don't know... Can anybody provide some good direction/documentation on the how the expressions/values should look.

Thanks For Any Help
By Nevron Support - 11 Years Ago

Hello Justin,
All functions in the Nevron Pivot should be with capital letters, for example:
=COUNT(Fields!mrSTATUS)

Take a look at the Help Documentation at: http://helpsharepointvision.nevron.com/
Pivot Engine >> Functions

Hopefully this helps. Let us know if you have any questions or if you meet any problems.