Charting two different variables over continous month/year axis [LINE CHART]

[Anonymous]

Dear all,

I would like to get something like this from Excel. On Axis I have date when it comes to inputing Value variables, I would like to map sum of errors + sum of costs for these errors. Is this possible?

I tried to work the way around with date hierachy in a way that I would try to put month above year, but it does not work like this.

Thanks in advance!

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please follow the below steps.

Select the visualization and go to the Fields Setting --> click on the arrow beside to the date field and select Date Hierarchy.

From the Data Hierarchy list, delete Quarter and Day.

Go to Format setting pane --> go to X axis --> change Type to "Categorical"

Click on the Expand all to one level down in the Hierarchy button.

That's it will, your expected results will be as in the below screenshot.

Hope this will helps you.

Please let me know if need any additional information.

Regards,

Pavan Vanguri.