Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Count rows per month

Hi All, Very basic, yet I am strugling to get the correct result. I would like to create a trend line with countrows per month/year. Legend should be x-axis year/month. y-axis # of records. Then t...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

     

    For you requirement, I have made a test based on your information.

     

    Please check if the below image is your desired output.

     

     

    More details, please refer to the attachment.

     

    Best  Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous,

 

I have a little confused about your scenario.

 

What visual do you want to create? Line chart?

 

If is is convenient, could you share your data sample which could reproduce your scenario and your formula so that I can have a test with your data to get the solution.

 

Best  Regards,

Cherry