Hi Community,
I am using K2 Dynamic Chart control and want to display the count of requests by status (e.g., Draft = 2, Submit = 1).
Currently, my SmartObject returns individual request rows with fields like RequestId
and StatusText
. Since the chart sums the RequestId
, it shows incorrect values (e.g., Draft = 2, Submit = 3) instead of row counts.
Challenge:
-
I cannot modify the database (no SQL view or SP changes allowed).
-
The SmartBox SmartObject does not support advanced grouping
What I want:
To show accurate grouped counts in my Dynamic Chart without modifying the database directly. in chart control there is any feature related to it.