Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.