Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to count by selected year where the "Created" year equal to YEAR.
Currently using the calculated dimension as below:
=Aggr(Only({$<Year={"$(=Date(Created,'YYYY')"}>} [User Name]), [User Name])
Expression:
Count([AR ID])
But its returning me null.
Can you please advise where I am having the issue.
Please see the attached sample qvw file.
Thanks & Regards,
Farrukh
Created is a timestamp field... convert this into just date before you create your calendar and also create this into date in your tblInfoPath table
Date(Floor(Created)) as Created in both places is needed
1)
2)
Hi Youssef,
Please see the below snapshot:
User_1 has many ARIDs. and AssignTO is a key value which is link to Info table.
Farrukh
here it is ok.. but on your table you have:
dimension = user_name
measure: AR_ID
the green data are ok
the red data cannot work
Maybe I'm missing something..
Thanks Sunny,
Now its giving me the correct counts. but its still not showing the dimension:
=Aggr(Only({$<Year={"$(=Year(Created)"}>} [User Name]), [User Name])
And giving me //Error in caluculated dimension.
Farrukh
Can you re-attach please
Thanks Sunny, This has been sorted, instead of calculated dimension I use just a normal field as a dimension.
Thanks for all you great help.
Kind regards,
Farrukh