Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
if possible share app with sample data
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
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.
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
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.