Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to plot a line chart without aggregating

Good Day. I am trying to make a project that models COVID-19.   I have the following data:   Where column 1 is text - date is in the date format, -  columns from total_cases  to total_re...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Anonymous ,

    In your screen shot, it shows "Count of total cases by Year", it means the count of date which has case in the year 2020, 2021, 2022. So in your screen shot line chart there's only three value.

    Just keep the Summarization of the total cases column Sum.

    The Values should also be Sum.

    The Axis should be date, not year.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

     

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

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

In your screen shot, it shows "Count of total cases by Year", it means the count of date which has case in the year 2020, 2021, 2022. So in your screen shot line chart there's only three value.

Just keep the Summarization of the total cases column Sum.

The Values should also be Sum.

The Axis should be date, not year.

I attach my sample below for reference.

 

Best Regards,
Community Support Team _ kalyj

 

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