Profile Picture

Trial - Needing Help Formating Data

Posted By Justin Payne 7 Years Ago
Author
Message
Justin Payne
Posted 7 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: Forum Members
Last Active: 7 Years Ago
Posts: 1, Visits: 1
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

Nevron Support
Posted 7 Years Ago
View Quick Profile
Supreme Being

Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)

Group: Forum Members
Last Active: Last Month
Posts: 2,892, Visits: 3,094

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.



Best Regards,
Nevron Support Team





Similar Topics


Reading This Topic