Combined chart and formatting on graph and displaying essential data dose not work in SAP webi

[former_member611722]

Hi,

I have the following dataexcelpic.png.

Now here is the scenario:

I want to create a Combined chart based on the following scenario:

I want to compare the performance of different developers in terms of the number of days that it takes for them to resolve an issue based on the department that the ticket came from.
More info:
1- The issues are assigned to different categories new/edit/revision

2- Ideally, they should be able to resolve the issue in 7 days for the new ones from the time that they received a ticket till the time that the issue was resolved/ this will be 5 days for the edit/revisions

So far, I have created a combined column line chart. I created a numeric variable (threshold) and assigned it to number 7 and dragged it to the chart.
I have assigned the following to the chart:
chart.png, graph-wrong.png

I also have the following formula:
The formula for Avg_build_F=(Sum([Build Complete Date])/Count([Ticket ID])) In([Build Request Type])

Average Build Time (G)=If ([Build Complete Date]<= [Threshold]) Then [Avg_build_F]
and Average Build Time (R) =If ([Avg_build_F]> [Threshold]) Then [Avg_build_F]

Now, here are the problems:

Why Average Build Time (R) and Average Build Time (G) have the same value?
If the value is less than the threshold, the color should be green, otherwise red. now I see the values are greater than 7 but still I see different colors! for all the values greater than , the color should be red.

How can I see the customer department there? it is in the assigned data but I cannot group by the department name.

Also, what should I do if I have null in some rows of build complete date which will affect my average build time.

Thanks,

[Tom_N8]

Hi Mandana,

This is obviously a follow up to your question "Combined chart with multi value error in SAP webi". May I ask why you do not accept the solution provided in that question but create a follow up question which is based on the solution?

Regards,

Tom

[Tom_N8 · Accepted solution]

Hi Mandana,

That's fine. In general I just find it useful and rewarding if the enquirer signals when information provided in a response was helpful by accepting the answer.

To your new problems with your graph... Looking at the three screenshots you provided, excelpicand graph-wrong suggest to me that you queried all columns A to F. If this is true than - looking at the values in columns E and F - it explains why you have "wrong" data in your graph as the data is already wrong in your source. You should only query columns A, B and C, and let WebI do the calculations.

So, to reiterate from my previous answer in the other question, you need to build five variables: Threshold, RowIndex, ABT (short for Average Build Time), ABT (G) and ABT (R) (for the green and red value bars, respectively). You'll need the RowIndex for the correct calculation of the averages as there are no ticket numbers or similar in your data set.

So, create the following variables as follows:

• [RowIndex] =RowIndex()+1
• [Threshold] =7
• [ABT] =(Sum([BCD])/Count([RowIndex]))
• [ABT (G)] =If([ABT] <= [Threshold]) Then [ABT]
• [ABT (R)] =If([ABT] > [Threshold]) Then [ABT]

Now, when building the chart, only pull [BRT] and [Cust] into the category axis, plus [ABT (G)], [ABT (R)] and [Threshold] into the value axis:

Then adjust spacing, colours etc. as per the previous post and you are done:

Let me know how you got on.

Kind regards,

Tom

PS. You can view the dataset I used in avebuildtimedataset.png below

[former_member611722 · Accepted solution]

Thank you so much for taking your time to answer my question. I am totally new to SAP, so, please bear with me if I ask naive questions. I do have the tickets' numbers and the de elopers that work on each ticket. So, i don't need to creat Rowindex anymore and to see the results for each developer, should I create an input filter? (I want to create a dashboard that each developet gets an overview regarding their performance)

One again, thanks a lot.

[Tom_N8 · Accepted solution]

Hi Mandana,

Welcome to the wonderful world of Web Intelligence 🙂

You could either create an Input Control to allow individual developers filtering against their own name, or maybe consider running a query filter (prompt) that restricts performance data against a single developer? You could combine this with global data for all developers but this way (query filter) not allowing an individual developer to compare her/his performance against another individual but the entire team.

Kind regards,

Tom

[former_member611722 · Accepted solution]

Thank you Tom Kornfeld. Can you please explain what's the difference is using count of rowindex vs the count of the number of tickets? What does Rowindex() do here?

Thanks again,

[Tom_N8 · Accepted solution]

Hi Mandana,

When I offered the above solution I was not aware that you already have ticket numbers in your data set, which is why I used RowIndex() instead. So in your case, all you need to do is replace the formula of variable [ABT] with =(Sum([BCD])/Count([Tickets]))

The RowIndex() function simply returns the number of a row in a table. If your query returns 60 rows for instance, you will get one index number per row in your report.

Kind regards,

Tom

[former_member611722]

Hi,

I applied the solution, however, I faced several other challenges that made me creat another questions. The problems are listed in this question.

Thanks