I have a chart that is mixing lines and columns on two axes. One of the lines (solid orange) is being hidden by the column. The lines are on the default axis and the column is on axis 1. Am I able to specify how the series are overlayed so the lines are on top of the colum? Here is a snapshot of the chart
Thank you!
Dave
@dcuozzo
To change the order of series in chart, switch temporarily to table view and drag with mouscelick the measure to the left.
Then switch back to the chart view and check the changes.
Martins / eazyBi
Thank you @martins.vanags, but I am not trying to change the order of the series. Maybe it would help if I show the table. Lines are “Avg Hours per Person per Day”, the colum(s) “Workdays”. For some reason the solid orange line for RxN A, All Tempo Work Types, Avg Hours per Person per Day, is falling behind the Workdays bar while every other line is shown in front.
@dcuozzo
My only guess is that you have tried to change axis or somebody else set axis (I can also see a secondary vertical axis).
That could change the default behavior.
Can you export and share the definition of your report either here or to support@eazybi.com
Martins
Thank you for the reply @martins.vanags. I am using multiple axes. The lines are all grouped on the left axis and the columns (Workdays) are on the right axis. It’s confusing to me why only one of the lines on the left axis falls behind the column(s). I’ve included an export of the report below. Thank you! - Dave
{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “Hours Logged / Person / Day Comparison by Team”,
“folder_name”: “D Cuozzo”,
“result_view”: “line_chart”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Logged by Team”,“selected_set”:["[Logged by Team].[RxN Cambria]","[Logged by Team].[RxN Synerzip]"],“members”:[],“bookmarked_members”:[]},{“name”:“Tempo Work Type”,“selected_set”:["[Tempo Work Type].[All Tempo Work Types]","[Tempo Work Type].[CAPEX Work Types]"],“members”:[],“bookmarked_members”:[]},{“name”:“Measures”,“selected_set”:["[Measures].[Avg Hours per Person per Day]","[Measures].[Workdays]"],“members”:[{“depth”:0,“full_name”:"[Measures].[Workdays]",“format_string”:"## days",“report_specific”:true,“name”:“Workdays”,“calculated”:true}]}]},“rows”:{“dimensions”:[{“name”:“Time”,“selected_set”:["[Time].[Month].Members"],“members”:[],“bookmarked_members”:[]}],“filter_by”:{“conditions”:[{“expression”:"[Time].CurrentHierarchyMember",“operator”:“between”,“value”:“13 complete months ago, yesterday”,“value_type”:“date”}]}},“pages”:{“dimensions”:[{“name”:“Project”,“selected_set”:["[Project].[All Projects]"],“members”:[{“depth”:0,“name”:“All Projects”,“full_name”:"[Project].[All Projects]",“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false}],“bookmarked_members”:[],“current_page_members”:["[Project].[All Projects]"]},{“name”:“Logged by Team”,“duplicate”:true,“selected_set”:["[Logged by Team].[All Logged by Teams]"],“members”:[{“depth”:0,“name”:“All Logged by Teams”,“full_name”:"[Logged by Team].[All Logged by Teams]",“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false},{“depth”:1,“name”:“RxN Cambria”,“full_name”:"[Logged by Team].[RxN Cambria]",“parent_full_name”:"[Logged by Team].[All Logged by Teams]"},{“depth”:1,“name”:“RxN Synerzip”,“full_name”:"[Logged by Team].[RxN Synerzip]",“parent_full_name”:"[Logged by Team].[All Logged by Teams]"}],“bookmarked_members”:[],“current_page_members”:["[Logged by Team].[RxN Cambria]","[Logged by Team].[RxN Synerzip]"]},{“name”:“Tempo Work Type”,“duplicate”:true,“selected_set”:["[Tempo Work Type].[All Tempo Work Types]","[Tempo Work Type].[CAPEX Work Types]"],“members”:[{“depth”:0,“name”:“All Tempo Work Types”,“full_name”:"[Tempo Work Type].[All Tempo Work Types]",“drillable”:true,“type”:“all”,“expanded”:false,“drilled_into”:false},{“depth”:0,“name”:“CAPEX Work Types”,“full_name”:"[Tempo Work Type].[CAPEX Work Types]",“calculated”:true}],“bookmarked_members”:[],“current_page_members”:["[Tempo Work Type].[All Tempo Work Types]","[Tempo Work Type].[CAPEX Work Types]"]}]},“options”:{},“view”:{“current”:“line_chart”,“maximized”:false,“line_chart”:{“area”:false,“swap_axes”:false,“data_labels”:true,“series_options”:{“RxN Synerzip;CountLoggedUsers”:{“type”:“column”,“separateAxis”:1},“RxN Cambria;CountLoggedUsers”:{“type”:“column”,“separateAxis”:1},“RxN Cambria;Hours spent”:{“dataLabelType”:“top horizontal”},“RxN Synerzip;Hours spent”:{“dataLabelType”:“top horizontal”},“RxN Synerzip;CAPEX Work Types;CountLoggedUsers”:{“separateAxis”:1,“type”:“column”},“RxN Cambria;All Tempo Work Types;CountLoggedUsers”:{“separateAxis”:1,“type”:“column”},“RxN Synerzip;All Tempo Work Types;CountLoggedUsers”:{“separateAxis”:1,“type”:“column”},“RxN Cambria;CAPEX Work Types;CountLoggedUsers”:{“separateAxis”:1,“type”:“column”},“RxN Cambria;All Tempo Work Types;Workdays within Time Period”:{“type”:“text”,“separateAxis”:2},“RxN Synerzip;All Tempo Work Types;Hours spent”:{“dataLabelType”:“top horizontal”},“RxN Synerzip;All Tempo Work Types;Workdays within Time Period”:{“type”:“text”,“separateAxis”:2,“dataLabelType”:false},“RxN Cambria;All Tempo Work Types;Hours spent”:{“dataLabelType”:“top horizontal”},“RxN Cambria;All Tempo Work Types;Hours Spent Integer”:{“dataLabelType”:“top rotated”},“RxN Synerzip;All Tempo Work Types;Hours Spent Integer”:{“dataLabelType”:“top rotated”},“RxN Cambria;All Tempo Work Types;Hours Logged”:{“dataLabelType”:“top rotated”},“RxN Synerzip;All Tempo Work Types;Hours Logged”:{“dataLabelType”:“top rotated”},“All Tempo Work Types;Workdays”:{“type”:“text”,“separateAxis”:3,“dataLabelType”:“top horizontal”},“All Tempo Work Types;CountLoggedUsers”:{“type”:“column”,“separateAxis”:2,“color”:"#9043C2"},“All Tempo Work Types;Hours Logged”:{“dataLabelType”:“top rotated”,“color”:"#2F579C"},“All Tempo Work Types;Avg Hours per Person per Day”:{“dataLabelType”:“top rotated”,“type”:“line-Dash”,“separateAxis”:1,“color”:"#2F579C",“symbol”:“circle”},“CAPEX Work Types;Hours Logged”:{“symbol”:“triangle-down”,“color”:"#B31238",“dataLabelType”:“top rotated”},“CAPEX Work Types;Avg Hours per Person per Day”:{“symbol”:“triangle-down”,“separateAxis”:1,“type”:“line-Dash”,“dataLabelType”:“top rotated”,“color”:"#B31238"},“CAPEX Work Types;Workdays”:{“dataLabelType”:false,“type”:“text”,“symbol”:false,“separateAxis”:3,“color”:"#00875A"},“CAPEX Work Types;CountLoggedUsers”:{“type”:“column”,“separateAxis”:2,“color”:"#FFBC29"},“RxN Cambria;All Tempo Work Types;Avg Hours per Person per Day”:{“color”:"#FF7119",“dataLabelType”:“top rotated”},“RxN Cambria;CAPEX Work Types;Avg Hours per Person per Day”:{“color”:"#FF7119",“type”:“line-Dash”,“symbol”:“triangle-down”,“dataLabelType”:false},“RxN Synerzip;All Tempo Work Types;Avg Hours per Person per Day”:{“color”:"#2F579C",“symbol”:“circle”,“dataLabelType”:“top rotated”},“RxN Synerzip;CAPEX Work Types;Avg Hours per Person per Day”:{“color”:"#2F579C",“symbol”:“triangle-down”,“type”:“line-Dash”,“dataLabelType”:false},“RxN Synerzip;All Tempo Work Types;Workdays”:{“type”:“text”,“separateAxis”:1,“symbol”:false,“dataLabelType”:“top horizontal”,“color”:"#00875A"},“RxN Cambria;All Tempo Work Types;Workdays”:{“separateAxis”:1,“type”:“column”,“symbol”:“square”,“color”:"#DEEBFF",“dataLabelType”:“top horizontal”},“RxN Cambria;CAPEX Work Types;Workdays”:{“separateAxis”:1,“type”:“text”,“symbol”:false,“dataLabelType”:“top horizontal”,“color”:"#00875A"},“RxN Synerzip;CAPEX Work Types;Workdays”:{“type”:“text”,“separateAxis”:1,“symbol”:false,“dataLabelType”:“top horizontal”,“color”:"#00875A"}},“y_axis”:{“0”:{“title”:“Avg Hours / person / day”,“min”:“0”,“max”:“8”,“step”:“1”},“1”:{“title”:“Workdays”,“min”:“1”,“max”:“24”,“step”:“4”},“2”:{“title”:“Headcount”},“3”:{“title”:“Workdays”}},“height”:600,“font_size”:“medium”},“table”:{“freeze_header”:false}},“calculated_members”:[{“dimension”:“Measures”,“name”:“Hours Logged”,“formula”:"[Measures].[Hours spent]",“format_string”:"#,##0"},{“dimension”:“Measures”,“name”:“Workdays”,“formula”:"[Measures].[Workdays within Time Period]",“format_string”:"## days"}]}
} ],
“calculated_members”: [{“name”:“CAPEX Work Types”,“dimension”:“Tempo Work Type”,“formula”:" [Tempo Work Type].[Analysis \u0026 Business Requirements] +\n [Tempo Work Type].[Build \u0026 Coding] +\n [Tempo Work Type].[Design] +\n [Tempo Work Type].[Implementation] +\n [Tempo Work Type].[Testing (QA)] +\n [Tempo Work Type].[Data Conversions (CapEx)] +\n [Tempo Work Type].[Infrastructure Installation] +\n [Tempo Work Type].[Labor for Config/Install Computer Equip] +\n [Tempo Work Type].[Analysis \u0026 Bus Requirements/SOFT EXT] +\n [Tempo Work Type].[Build \u0026 Coding/SOFT EXT] +\n [Tempo Work Type].[Design/SOFT EXT] +\n [Tempo Work Type].[Implementation/SOFT EXT] +\n [Tempo Work Type].[Testing (QA Testing)/SOFT EXT] +\n [Tempo Work Type].[Data Conversions (CapEx)/SOFT EXT]\n\n",“format_string”:""},{“name”:“CountLoggedUsers”,“dimension”:“Measures”,“formula”:“NonZero(Count(\n Filter(\n [Logged by].[User].Members,\n [Measures].[Hours spent] \u003e 0\n )\n))”,“format_string”:"#,##0"},{“name”:“Avg Hours per Person”,“dimension”:“Measures”,“formula”:"[Measures].[Hours spent]/ [Measures].[CountLoggedUsers]",“format_string”:""},{“name”:“Workdays within Time Period”,“dimension”:“Measures”,“formula”:“CASE\nWHEN DateCompare(“Yesterday”,[Time].CurrentHierarchyMember.NextStartDate) = -1\nTHEN\n DateDiffWorkDays(\n [Time].CurrentHierarchyMember.StartDate,“Today”\n)\nELSE DateDiffWorkDays(\n [Time].CurrentHierarchyMember.StartDate,\n [Time].CurrentHierarchyMember.NextStartDate\n)\nEND”,“format_string”:""},{“name”:“Avg Hours per Person per Day”,“dimension”:“Measures”,“formula”:"[Measures].[Avg Hours per Person]/\n[Measures].[Workdays within Time Period]",“format_string”:""}]
}
