Skip to Content
avatar image
Former Member

Issue in Stacked Bar Chart SAP MII 12.2.6

Hi All,

     I am using SAP MII 12.2.6(Build 54).

     I create one chart with follwing details:

Query Output:

if i mapp this query to Bar Chart means i got output like below:

If i use stacked Bar Chart Means i got output like,

 

In this chart, I am really get confused at what basis it got stacked.

In query result, the reason code is not repeated to other machine.

The query gives unique distinct values.

As per query result the chart shows wrong.

the configuration is given by,

I expect the same result as bar chart. When query gives result as reason code repeated for 2 or more machine means then only the chart gets stacked.



Kindly Help me this issue.



Regards,

Santhosh K

1.PNG (131.1 kB)
2.PNG (37.1 kB)
3.PNG (37.6 kB)
5.PNG (14.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 16, 2013 at 04:58 AM

    Hi All,

         Thanks for tour response.

         If i include reasoncode in label column means i got output like,

    Regards,

    Santhosh K


    1.PNG (12.6 kB)
    2.PNG (14.6 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Let me understand your graph, in above sample for each reason desc or reason code, there is set of downtime values for machines(suppose if 5 machines are there, in that there can be downtime only for 3 like that which varies). correct know?

      You have following data.

      1. You will have what is no of machines available.

      2. Set of reason code.

      3. and Downtime values (if there) for that reason and for the machine.

      If this is your above requirement, Then you need to construct the output like below

      Reason code 340 315 323 317 593 1477 0 0 0 1443 0 1380 0 0 1447 960 0 0 0 555 777 0 888 0

      So give 0 as downtime value to the machine which has no downtime for that reason.

      If you check last row see 555 is reason which has downtime for 2 machine so it will stack.

      Plot Reasoncode as X axis and map all the other columns in value column.

  • avatar image
    Former Member
    Oct 15, 2013 at 09:16 AM

    Hi Santhosh,

    The XML structure for a Bar Chart and a Stacked Bar chart is different.

    The bar chart you have plotted as depicted in the picture above is Downtimes again each reason code, but in order to get the stacked bar chart, your XML needs to be structured accordingly.

    Few things are a bit unclear as per your explanation for a stacked bar chart. Can you please elaborate how you want to plot your stacked bar chart, may be after that I can help you out with the XML structure for the same.

    Attaching a basic stacked bar chart for a XML output for your reference.

    Warm Regards,

    Anuj

    Message was edited by: Anuj Suryawanshi


    Add comment
    10|10000 characters needed characters exceeded

  • Oct 15, 2013 at 11:42 AM

    Hi Santhosh,

    Here, you have kept the label column as machine name and hence it is showing stacked bars for distinct dates with a set of machine name each. If you see the legends in the chart, it says that bars are for 340-->315-->323-->317 from bottom to top and it shows values that lie on a particular day(grouped by date).

    You want to see bars stacked only when there is multiple entry for one "resourcecode" and that too when lies on a particular day, you can give resource code as label column.

    Hope this helps.

    Regards,

    Swaroop

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 17, 2013 at 06:26 AM

    Hi Santhosh,

    Remove MachineName from Label columns and keep it in value.

    You should be able to see different reasurce codes and machine name mounted on top of it.

    Hope this helps.

    Regards,

    Swaroop

    Add comment
    10|10000 characters needed characters exceeded