Line Chart

[Pujitha]

Hello

I want to create a line chart with the data I have like- 'Date column' which is having dates from May to Sep(Format :5/11/2017-9/31/2017) and other column I have is 'Overdue' which contains numbers  like-  1,2,3,4,5 with repetition. 

So I want to calculate -how many are 5's in 'Over due' for particular month( Suppose May) /how many are overall numbers(1,2,3,4,5) like wise each month I need to calculate and create line chart. I took dimension as date column and in Expression how to write to achieve the above scenario. Please help me out as soon as possible. Thanks!

[prabhu0505]

if possible share app with sample data

[Victor_Alumanah]

Hi Pujitha,

I would recomend a bar chart as a line chart could get messy very quickly.

1. Create a bar chart

2. add calculated dimension  =MONTH([Date Column])

3.  add dimension Overdue

4.  add expression =Count(Overdue)

5. If you want to change the style, go to the style tab and select Stacked

Thanks

Victor

[Pujitha]

Data sample:

 

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 onth july month The graph I need to get like this. Please advice me as soon as possible.

[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

[Victor_Alumanah]

I think it may be a bit difficult to understand without seeing a sample of what you are trying to do.  The initial solution I posted can be changed to a line graph, and then add "Overdue" to the dimensions and then you have your lines.  I don't understand the part you mentioned about dividing 5 by the other numbers.