Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a dashboard that counts numbers of downloads for YTD and prior YTD on a monthly level. So the current YTD expression is as follows:
count( {$<UsageYear = {$(=max(Year(MaxUsageDate)))},
UsageMonth = {"<=$(=max({<UsageYear={$(=max(Year(MaxUsageDate)))}>} Month(MaxUsageDate)))"} >} Downloads)
And the Prior year expression is
Count ( {$< UsageYear = {$(=max(Year(MaxUsageDate))-1)},
UsageMonth = {"<=$(=max({<UsageYear={$(=max(Year(MaxUsageDate)))}>} Month(MaxUsageDate)))"} >} Downloads)
****
What I'm trying to do is modify these expressions to track downloads on a daily basis and not monthly. The incoming data attributed to the 'Downloads' value in the expression above actually has data per day, but right now the current expressions above only count to the month level. Do if it's 4/15/12, you'll see all of April for prior year. What can I do to the prior year expression to count just the downloads of the current day/date within the month?
Thanks.
Hi,
Are you expecting this?
count( {$<UsageYear = {$(=Year(Max(MaxUsageDate)))},
UsageMonth = {"<=$(=Month(Max(MaxUsageDate)))"},MaxUsageDate={"=(Day(MaxUsageDate)=Day(Max(MaxUsageDate)))"} >} Downloads)
Celambarasan
Sorry that does not produce an result ...just blank...