I'm trying to create a report with a column that includes the number of issues on a project with a certain custom form attached. I figured the best place to start was with an IF statement that looks for a value in the custom form, but from there I'm a little stumped on to count/accumulate the returns. I also saw the "number of open issues" field, but I need to check closed issues for the form and count as well.
Does anyone have any advice how to do this?
Topics help categorize Community content and increase your ability to discover relevant content.
Hey Chris,
Would this work?
displayname=test
linkedname=direct
namekey=totalOpTaskCount
querysort=totalOpTaskCount
textmode=true
valueexpression=IF(ISBLANK({DE:<your custom field name>}),"",{totalOpTaskCount})
valueformat=HTML
Views
Replies
Total Likes
No luck. Here is what I'm using:
displayname=test
linkedname=direct
namekey=totalOpTaskCount
querysort=totalOpTaskCount
textmode=true
valueexpression=IF(ISBLANK({DE:Control Number - PCR})," ",{totalOpTaskCount})
valueformat=HTML
and I'm validating it by comparing against a nested list snippet to make sure there should be counts. This is returning results, but it's a list instead of a count:
displayname=All CRs
listdelimiter=<p>
listmethod=nested(issues).lists
textmode=true
type=iterate
valueexpression=IF(ISBLANK({DE:Control Number - PCR})," ",CONCAT("- ",{name}))
valueformat=HTML
So I'd expect any project with a list showing for the nested snippet would then display a count for the new column (again, using this as a way to validate). But so far, I can't seem to get a return on the count column. Any other tips?
Views
Replies
Total Likes
Hey Chris,
Sorry, I thought the custom form was at the project level. The nested calculation will only return one line per result (ie issue) and there is no way to sum these. I'm stumped on this one!
Anyone else have any ideas?
Views
Replies
Total Likes
The summing is really what I'm looking for (if it exists). I know enough to check for the form on the issues, but trying to figure out how to convert those returns to a number and sum them is where I get lost.
Views
Replies
Total Likes
if the only thing you wanted was the count of issues per project, would it be feasible to just use an issue report and filter by the cat ID, group by project name, and then display the summary tab?
Views
Replies
Total Likes
I'm trying to show it on an existing status report with other data. That's why I'm trying to make it a custom column.
Views
Replies
Total Likes
Views
Likes
Replies