Combined chart with multi value error in SAP webi

[former_member611722]

test-dashboard.pngHi everyone,

I want to create a gauge line 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:
Category Axis:
-Customer Department
-New Category
Value Axis1:
-Avg_bld_days
- Threshold

Now, here are the problems:

As you can see on the image, there is triangle indicating that there is an error and avg(bld_days) has multi values! why is it like that?
Also,if took less than 7 days to resolve an issue, I want to have it displayed in green, otherwise in should be highlighted in red.
However, with this one that I've created, I only see a straight line

[Tom_N8]

Hi Mandana,

Not sure how you built your measure calculating average build time. This is how I defined it and I get no error warning: [Average Build Time] =(Sum([Build_Days])/Count([Ticket_ID])) In([New_Cat])

Conditional formatting on graphs does not work. You will need to create a couple of helper variables, e.g. [Average Build Time (G)] =If((Sum([Build_Days])/Count([Ticket_ID])) In([New_Cat]) <= [Threshold]) Then [Average Build Time] for your green bars and [Average Build Time (R)] =If((Sum([Build_Days])/Count([Ticket_ID])) In([New_Cat]) > [Threshold]) Then [Average Build Time] respectively for your red bars. You use these two variables as values in your value axis, not the [Average Build Time] variable. In Format Graph (Global | Measure Properties) define both these measures as bars and then format their individual series colours (Format Data Series...) accordingly. Finally, format the Plot Area Design and adjust spacing within/between groups to make the bars appear as centric as possible.

Kind regards,

Tom