Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Graph, Percentage By month & YearToMonth in 1

Hello,

I'm looking for a way to show a percentage value (Avt vs budget) and the year to month value of the same calculation in 2 lines on one graph.

=(SUM({<[Date Year]={$(Dash_SelYear)} >} [TsDayTotal Tickets])-SUM({<[Date Year]={$(Dash_SelYear)} >} [TsForecast Tickets]))/SUM({<[Date Year]={$(Dash_SelYear)} >} [TsForecast Tickets])

This goes over the month dimension.

Totalizing the percentages resuls of course in a wrong value.



0 Replies