Customize the Period Summary chart

Gathering Feedback


1 comment

  • Avatar

    Hello Bacem,

    Thank you for your message.


    > 1- Can I add another hours tracking on the same chart (a certain project tracking for example and to be showed as the second screenshot indicate)

    Yes, this is possible with the usage of "workLogsWorkItems" endpoint and grouping by "WorkItem/System_TeamProject" property. See this for reference. I made the widget for you, here is the definition (you can copy and import it into your Report):

    {"type":"Line","title":"Period Summary","subTitle":"","endpoint":"workLogsWorkItems","id":"","query":"$apply=groupby((WorklogDate/ShortDate,WorkItem/System_TeamProject),aggregate(PeriodLength with sum as PeriodLength))&$orderby=WorklogDate/ShortDate","w":8,"h":3,"chartSettings":{"strokeWidth":3,"showLegend":true,"showDataForAllPeriod":true},"xAxis":{"type":"date","title":"","rotation":0,"granularity":"day"},"yAxis":{"type":"duration","title":""},"series":{"fieldY":"PeriodLength","fieldX":"WorklogDate.ShortDate","sliceField":"WorkItem.System_TeamProject"},"autoSubtitle":false,"timeframeFilter":null,"dataAdapters":[{"name":"FillMissingDatePoints"},{"name":"SumOverPeriod","params":"PeriodLength"}],"y":17,"x":0,"odataVersion":"v3.0"}

    Please, tell me if this widget fulfills your requirements.


    >2-How can I track a certain activity hours (only tasks for exemple or that the billing filed contains "true")

    Sorry, I'm not sure if I understood you correctly. Could you please expand your question with some examples (visual, if possible) to avoid misunderstanding. Thanks.


    Kind regards,

    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk