Hi, I have a requirement to create a graph with the following.
Active in Oracle - 1(ID) - count 2
Active in mainframes - 2(ID) - count 3
Pending - 3(ID) - count 4
Cancelled - 4(ID) - count 7
Now I need to create a graph with Active, Pending, Cancelled in X axis and in 5 ,4, and 7 in graph. Basically need to group 2 status in one and show the sum of count.
And then on drilldown we need to show the records associated with them in grid.
How can I achieve this.
Thanks
Discussion posts and replies are publicly visible
Did you consider to use a custom record field to do a grouping first, and then use that data in a graph?
I think custom record fields won't work here as he needs to club 2 statuses in one, which means two status IDs in case of "Active" and CRF cannot contain two IDs unless you concat them into one.