Group: Forum Members
Last Active: 11 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
|
Group: Forum Members
Last Active: 2 hours ago
Posts: 3,054,
Visits: 4,009
|
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
|