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
Resident 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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,
This is a dummy data below.
I am trying to create a line graph, or bars.

I want the x-axis to show the month/year (Date Column). y-axis to show the count of records in each month/year

I created a measure --> 

CountRecords = COUNTROWS('Table')
 
I also have a Date table, as explained in this blog.
 
Getting all kind of weird results and not the expected line chart.
 
Expecting to get something like this (with relevant data from my table...)
 
 
 
 
 
 
 
 
 
 
 
 
 
Also it would be nice to have a slicer/filter according to month, year and multiple select.
i.e. can select 2018, Jan, Feb, March. OR 2018 Dec, 2019 Jan, Feb.
etc.
 
Thanks a lot!
 
 
idDateTypeEnd Dateunique_idStatusDay DiffColumn XColumn YColumn Z
115/1/2019R 205Open175.136949-3.910960.586164
28/1/2019L 201Open241.359541-2.323210.60219
324/12/2018S 208Open396.243304-2.396230.982917
418/12/2018S 202Open451.510626-9.756080.456368
516/12/2018L 204Open473.868114-7.354110.89261
614/11/2018L 185Open794.008227-7.626580.141866
731/10/2018L 199Open931.022142-3.66570.579697
831/7/2018L 25Open1859.40272-9.365740.214208
930/7/2018L31/03/1721Closed1868.558588-8.811160.927714
1027/7/2018L 206Open1895.023559-9.985150.521363
116/7/2018L 117Open2105.424869-3.683950.605868
127/6/2018L 181Open2398.132357-4.603330.567406
1329/5/2018L 179Open2484.581901-8.420410.265024
1423/4/2018L 159Open2846.736259-9.821790.275311
1528/3/2018R14/06/1855Closed3107.567686-9.490270.734757
169/3/2018L 83Open3298.056153-0.552060.777119
179/3/2018L 91Open3290.207545-2.619120.578116

 

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello, 

       

      I tried to do the same chart than you in your PIBX 

      I put the same attributes on X and Y but I can not get the format YYYY-MM like you. I have just months. Can you show how to get this please ?

       

      Thank you !