Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to show a line graph where it displays Year over year by month of count of invitations.
I want to show graph for previous and current year.
I have tried with
Dimension : year and Month
Expression :
count({<DateType = {invitation},Year = {$(=max(Year))}>}invitation_id)-count({<DateType = {invitation},Year ={$(=max(Year)-1)}>}invitation_id)
I think there is wrong in my expression.So it is showing negative values I have attached qvf file .
Please help me in this regard.Any kind of help is appreciated.
Regards.
Like in below image i need to show graph. For both current(Green) and previous year(red) of invitations and Course Completed YOY Counts.
this?
Yes.
But it has to show for both current and previous year.
add two expression for current and previous year
cuu yr:
count({<DateType = {Completed},
Canon_Year = {"$(=year(max(CanonicalDate)))"}>}course_completed)
pre Yr:
count({<DateType = {Completed},
Canon_Year = {"$(=year(max(CanonicalDate))-1)"}>}course_completed)
I am not able to add one more expression, ADD button of Measures is not Highlighted.Thats the problem i am facing.
in line chart u can add measures as u want. check properly under expression
Check by adding two Dimension.
You wont be able to add Expression more than one
try the option add alternative measure
Nothing get displayed if i add in Alternate measure, in line graph
Hi,
I need to Show counts YOY of completions and Invitation in Line Graph.
I have dimension : Year and Month
Expression:
fabs(count({<DateType = {invitation},
Year = {$(=max(Year))}>}invitation_id)-count({<DateType = {invitation},
Year = {$(=max(Year)-1)}>}invitation_id)
)
Here i need to add one more expression, but i am not able to add onemore expression.
Can we add more than one expression while calculating YOY by month??