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
Do you have any common ID between Active in Oracle and Active in mainframes?
Did you consider to use a custom record field to do a grouping first, and then use that data in a graph?
Hello ak0642,
I would recommend the approach Stefan has mentioned. Create a custom record field and utilize that. for the drilldown you can use the below referenceConfigure a Chart Drilldown to a Grid
I think the question is more on how to club 2 different status in one rather than on how to group. You would need an extra field for common status e.g. Active.
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.