Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to compare 2 distinct counts and to show them as a primary and secondary KPI's.
a. the number of Branch_ID that exists in a Table in a certain month. Have the month as a variable
b. the number of Branch_ID that exists in the same Table in the month before it. Have it also as a variable.
I dont understand why this expression doesn't work:
Count({<max([Contract_Open_Date]) = $(vPrevMonthes) >} distinct Branch_Id)
while vPrevMonthes holds the previous end of month
TNX
Hi
please find the file in the attachment
Hope it helps
Thanks