Line chart

[Pujitha]

Data sample:

Date               Overdue

07/22/2017     1

07/23/2017      2

07/24/2017      3

07/28/2017    5

08/23/2017   5

08/25/2017    3

09/20/2017    2

09/11/2017      5

Need to calculate in line chart how many are 5's divided by how many are (1's,2's,3's,4's) in may month, June month, July month The graph I need to get like: 

horizantal x-axis will be may june july month  y axis will be the scale from 0 to 3, The line chart should come. Please suggest me good approach

[bharathadde · Accepted solution]

Dimension: Month of Date 

Month(Date)

Expression: 

=Count({<Overdue={'5'}>}Overdue)/Count({<Overdue={'1','2','3','4'}>}Overdue)

[Brett_Bleess]

Pujtha, did the comment from Bharath help you get what you needed?  If so, please be sure you give credit by using the Accept as Solution button on his post.  If you did something different, consider posting what you did and mark that, and if you are still working on things, please update.  I do recall seeing a 'duplicate' post too, please refrain from posting the same question multiple times, keep working on the first post, if you need further responses, add an update to the post, and that will move it back up in the list again...

Regards,
Brett