Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Line chart display value over duration

Hi All,

 

I have some project data (sample below) which I'd like to display on a line chart, where the Y axis would display hours per month for the duration of the project (between start date and go-live) for each of the below. 

For example, I would like the chart to show 125 hours for 12 months (between 30.10.2019 and 30.10.2020), 230 hours over 13 months, and so on as per the table below. 

Seems like I've tried everything to get this right: date intelligence, expanding rows, etc - any tips on how I can get the visual I need?

 

start datego-livemonthshours per month
30.10.2019  30.10.2020  12125
31.07.2019  29.09.2020  13230,7692308
29.09.2016  30.10.2020  4920,40816327
24.09.2019  29.09.2020  1220,83333333
26.04.2020  27.10.2020  6666,6666667
30.11.2020  30.06.2021  7335,7142857
27.11.2020  30.06.2021  742,85714286
18.06.2019  01.01.2020  640
30.04.2019  30.09.2019  50,2

 

Need Help

2 Replies

  • VijayP's avatar
    VijayP
    Community Champion
    5 years ago

    Anonymous 

    I hv Created at Custom Column with the help of Start Date and Months and I have used the Line  Chart

    Added respective picture , have a look to understand

    let me know if this solves your problem

    Vijay Perepa

     

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Would you please try to explain more about your requirements? What did you want to show on x-axis?

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai