Average line over invoices per cost centre

[Anonymous]

Hello,

I have invoices with date and cost centre. Now I want to show the show the history of revenue based on these invoices over the year. That's easy, but how can you add a line that is showing the average of all cost centres as a additional dynamic line in a line chart ?

[AntoineTRICHET · Accepted solution]

HI @Anonymous 

I just figure out the solution, you just have to add your average line (in visualization panel) (see below the sreenshot)

Please accept it as a solution if it solved your issue

[V-pazhen-msft · Accepted solution]

@Anonymous 

Just not sure about what do you mean by dynamic, if you mean you want the average line change based on the filtered years, the average line provided by @AntoineTRICHET should work.

Paul Zheng _ Community Support Team

Best Regards

[AntoineTRICHET · Accepted solution]

HI @Anonymous 

I just figure out the solution, you just have to add your average line (in visualization panel) (see below the sreenshot)

Please accept it as a solution if it solved your issue

[AntoineTRICHET]

Hi @Anonymous 

A work around could be to create a second graph showing only the average of all cost centers (with the same axis ranges) and then place it on top of your first graph (you have to desactivate the background of your second graph.

Please accept it as a solution if it solved your issue