Skip to main content
R
rupaa0642
Known Participant
January 18, 2024
Question

Graph with custom grouping

  • January 18, 2024
  • 5 replies
  • 6 views

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

    5 replies

    harshitb6843
    harshitb6843
    Brainy
    January 18, 2024

    Do you have any common ID between Active in Oracle and Active in mainframes?

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    January 18, 2024

    Did you consider to use a custom record field to do a grouping first, and then use that data in a graph?

      harshitb6843
      harshitb6843
      Brainy
      January 19, 2024

      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. 

      konduruc733182
      konduruc733182
      Inspiring
      January 18, 2024

      Hello rupaa0642,

      I would recommend the approach Stefan has mentioned. Create a custom record field and utilize that. for the drilldown you can use the below reference

      Configure a Chart Drilldown to a Grid

      abhayd3663
      abhayd3663
      Brainy
      January 18, 2024

      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. 

      Terms & ConditionsAccessibility statement