Hi,
I am using devexpress dashboard designer to create dashboards in our project. In that, i have one issue in creating a calculated field using CountDistinct function. I have created the following expression in my project.
CountDistinct([REPORTDATE])
After creating this expression, it shows the exclamation symbol for the calculated field. I am not able to drag & drop that field in my dashboard. For you reference, I have attached the sample project with data. In that project, click the grid dashboard item. Now you can see the calculated field - "Calculated Field 3". Or else create a new expression using the above formula. See what happens.
Please help me to solve this issue. I want to use this calculated field in various dashboard items.
Thanks & Regards,
Pradeep
I have managed to reproduce the described problem on my side. The problem likely appears because this function is not loaded property:
System.InvalidOperationException occurred
HResult=-2146233079
IsTransient=false
Message=Custom function 'dashboarddistinctcount' not found.
Source=DevExpress.Data.v15.1
StackTrace:
at DevExpress.Data.Filtering.Helpers.CriteriaCompilerCore.MakeCustom(FunctionOperator fn)
InnerException:
It will require some time to research it in greater detail. I have passed this issue to our developers for further research. We will update the thread once we have any results.
Hi,
Can you check COUNT function also? Because i am facing this same problem for COUNT function also.
Thanks & Regards,
Pradeep
I was unable to replicate the issue with the Count function. Would you please clarify which expression you use?
Create new calculated field using Count([REPORTDATE]) in the same sample project.
The Count summary function does not require any parameters. Use the following expression to resolve the issue "Count( )"
Got it. Thanks!
Please update me once the CountDistinct() related issue is fixed.
Thanks,
Pradeep.
Any updates on this? I need the hotfix as soon as possible. Please update.
Thanks & Regards,
Pradeep.
Hi,
We haven't yet found a suitable solution. We will continue working on this issue and keep you informed of our progress. Please bear with us.
Hi Alex,
Any update on this? It's bit urgent. We need to give fix to our customers. Please let us know the status on this.
Thanks & Regards,
Pradeep
We have not found a solution to this issue yet. I have notified our developers that this task is urgent for you. We will process the issue with higher priority. We will update the thread once we have any news regarding.