Discussion
In a report How to calculate the number of days delayed
In a tabular report I want to have the number of days delayed at epic level based on the Planned End date and actual end date
How can i put this logic in the report?
- If planned end date is already due and still the actual end date is blank then
- the number of delay days = Now() - Planned end date
- Also If planned end date is less than the Actual end date then
- the number of delay days = Actual end date - Planned date
I have used the below mentioned code but it is wrongly calculating when planned end date = actual end date and also when planned end date is already due and still the actual end date is blank the number of days calculated is usually 1 day less
```
CASE
WHEN
[Planned End Date] < NOW()
THEN
DATEDIFF(
[Planned End Date],
NOW(),
'day'
)
WHEN
[Planned End Date] < [End Date]
THEN
DATEDIFF(
[Planned End Date],
[End Date],
'day'
)
```
Posted by Ritu 8 days ago
Can milestone date we accessed programatically

Hi, can I access milestone month programmatically, can you suggest how to solve this
Posted by Mandeep about 1 month ago
Group By TAGS
Hi
Am trying to create a custom features report where I will like to GROUP BY specific chosen Tags. So fore.g a feature are currently tagged by different geographies, tech, business units. When I group, I will only like for e.g to do so my geographies in my report. How do I do that , I tried exploring formulas (TagObjects.Select(Name)) however struggling to enable it. Will appreciate if you can help me with specific formula or different approach
Posted by Mandeep about 2 months ago
Is it possible to add images to Dashboards?
I would like to be able to add Images to Dashboards to share information with users and also make Dashboards more visually appealing.
Posted by Jack Kleinjan about 2 months ago
CustomReport
Is there a way to get a custom report by id via api?
https\://**\*\***.tpondemand.com/TpReports/ViewCustomReport.aspx?CustomReportID=34, for example
Posted by Jose Prada about 2 months ago
Quick Add field removal when grayed out
can a grayed out field in Quick Add be hidden or removed?
Posted by Dave Somick 2 months ago
https://.tpondemand.com/api/v2/Times?&access_token={acesstoken}&take=1000&format=json
For this api call i am getting the json data but i am not able to get the assignable userid , hours spent , full Name and sap project no . Can you help me to fetch those based on this Api call .This is the data which i am getting .
\[{"resourceType":"Time","id":483147},{"resourceType":"Time","id":483146},{"resourceType":"Time","id":483145},{"resourceType":"Time","id":483144},{"resourceType":"Time","id":483143}
Posted by null 3 months ago
Attachment Upload With File Name "Präsentationen_Projekt_X"
I am using the RestSharpExample provided on github I have a filename "Präsentationen_Projekt_X" when I try to upload it the filename on target process becomes "=?utf-8?B?UHL....." here is also the sample chunk of code
```
var client = new RestClient(uri);
await file.CopyToAsync(memoryStream);
var restRequest = new RestRequest(requestUri, Method.Post);
restRequest.AddHeader("Content-Type", "multipart/form-data;charset=utf-8");
string encodedFileName = Uri.EscapeDataString(file.FileName);
restRequest.AddFile("attachment", memoryStream.ToArray(), encodedFileName, file.ContentType);
restRequest.AddParameter("generalId", Id);
var response = client.Execute(restRequest);
```
Posted by Abdullah Saeed 3 months ago
Add task to user history with javas cript
I need to add "task" when a checkbox of the custom fields is clicked.
Can it be done with javascript?
thank you.
Posted by [email protected] 3 months ago
Pick the date of a particular state of an user story irrespective of current state
I want to report on which date user story was in In Progress irrespective of the current state
How to fetch the date of In Progress of an user story. I can find the date manually from the history of the user story. Which formula to use in order to fetch the date in the report automatically
Posted by null 4 months ago