Chronological order in line graph

[Qudsia_DK]

I have a line graph that does not show months in order rather randomly distributed. How can i fix that

[ArkadyZagdan]

@Qudsia_DK 
Are you using time series chart or line chart?
Time series should allow you to sort it correctly assusming your dimensions is date type of field  and you are using it as your sorting field:))

Arkady Zagdan

[Qudsia_DK]

I am using line chart as i would just like to see the revenue combined in a month rather than everyday 

[ArkadyZagdan]

I would still use  time series but change date dimension from day to month. This way it should automatically remove any sorting issues assuming the field you  are using  is a correct date field.

Here is an examaple:
https://lookerstudio.google.com/u/0/reporting/fc021aef-6115-43d2-9ee4-07b47a7c1e1f/page/p_mwqjmaelad
It uses Month as dimension.

Regards
Arkady

[lauratilton]

Is your Year Month field a text field or a date field? If it's a date field, do you have it set to Year Month in the data source or in the chart? What is your Sort field for the line chart and what is the aggregation?

Basically you'll need a date type field set to Year Month, and you'll need to use this to sort the line chart in order to have them in the order you're expecting. If Year Month is a text field and you use it as your sort, it will sort alphabetically...or if the aggregation is set to CT or CTD it will sort in numeric order based on the number of records for each Year Month...and neither of those is what you want.

Feel free to share a screen shot of how your line chart is configured (the Dimension, Metric, and Sort) if you need more info.