Share
ReportI had 2 date/Time fields, and wanted to know the duration of time between them. The start date would (should) always be there and the end date was entered later. If the end date is not there I use the current date. I created a calculated whole number field which calculates the difference in dates. Now I have a chart that is based on this value and I want to sort by this calculated field. This is how it sorts it
| 90 | item | |
| 221 | item | |
| 29 | item | |
| 197 | item | |
| 130 | item | |
| 129 | item | |
| 129 | item | |
| 165 | item | |
| 137 | item | |
| 102 | item |
Here is my Fetch XLM
<fetch mapping="logical" aggregate="true" top="10" >
<entity name="job" >
<attribute name="searchduration" alias="SearchDays" groupby="true" />
<attribute name="jobtitle" alias="JobTitle" groupby="true" />
<filter type="and" >
<condition attribute="status" operator="eq" value="100000007" />
<condition attribute="searchduration" operator="gt" value="0" />
</filter>
<order alias="SearchDays" descending="true" />
</entity>
</fetch>
Am I missing something?
*This post is locked for comments
All responses (
Answers (
6,210
