Setting a Target for Meter Chart does not work

Bharath Kumar shared this question 4 months ago
Answered

Hello Team,

I am trying to create meter chart in YF 8.0.4. I have Number of Incidents SLA met is 78% and Breached are 22%. I am trying to point the needle to 78 which SLA Met Inc. But meter chart always picks 100%.

- In my report, I have SLM Status(Breached/Met) and Number of incidents.

- Change Number of Incidents advanced function to analysis-percentage of total

- Added conditional formatting on Number of Inc.


Refresh Data.

You should get something like this:


% of Total of Number of Incidents 78 and Breached 22%.


Add a meter chart and put to measure the analysis field % of total of number of incidents.The needle always shows 100% on the meter chart. So I created a variance function in chart and dragged it in target. Defined the filter logic as SLM Status = Met. I assume it should display Num of Inc which are SLA met.


Attached screenshot. My question is how can I make the needle to display based one of the value like SLA Met incidents in my case.

Comments (19)

photo
1

Good Morning, Bharath,

I hope you are well!

At first glance of the screenshot you have provided, it looks like you may need to switch the fields arounds. % of Total number of incidents in the Target box and then the 'BMC' in the measure box.

Let me know what results this produces?

In the meantime - I will test out locally and let you know how it goes :)

Best Wishes,

Lesley

photo
1

Hey Bharath,

I just did a quick test to show my results when putting the total amount in the target field and the actual numbers in the measure field -

c6c2a20f8dec3ffd9c820fe6a9cfe8a5


In your screenshot, your target says '78' where this should be the measure.

Let me know how it goes! I hope this has helped :)

Best Wishes,

Lesley

photo
1

Hi Lesley,

We tried this, indeed the needle shows correct value, but the conditional formatting is lost in the report.

We defined different colors for % Number of Inc, but with approach the whole chart is turned to blue color.

Regards,

Bharath

photo
1

Hey Bharath,

Could you try applying the conditional formatting to the field put into the measure section? So if you use conditional formatting on the 'BMC' field, the same way you did it on the '% of' field, this should work :)

I hope that helps - Let me know

Best Wishes,

Lesley

photo
1

Hello,

The field BMC is a Set Analysis function from the chart. I cannot apply conditional formatting on it, I dont see way to apply conditional formatting on Set Analysis functions.

Regards,

Bharath

photo
1

chart turns blue with default coloring as I add Set Analysis function to Measure. Since it is a run time function, I guess it does not have ability to define conditional formatting.

photo
1

Hey Bharath,

I hope you are well!

I am so sorry, I missed the fact that this was a set analysis!

I tested this out and I believe this is expected behaviour, because the set analysis is independent from the report, so it will not have any formatting rules from the report to hold.

When testing this out, I used a date field as a filter in the set analysis for a specific year (2011) and received the same results as yourself, the whole colour band turns to the default colour. -

a97045f41b73eb87157b3d991aa58b42


However, when setting this up via the report builder an NOT the set analysis, I was able to receive the same results on the chart, but this time, the colour band will hold the conditional formatting -

60ebb7bc1a9752b9a15bdb7a84b41d24


So -

  • Instead of putting the field from the report in a set analysis, I put it in the 'measure' section
  • Instead of applying the filter in the set analysis, I put it in the 'Filter' Section of the report builder

Is this a viable option for you to try?


Let me know your thoughts :)

Best Wishes,

Lesley

photo
1

Hi Lesley,

If I put filter in report and pull Number incidents with SLA met, but I get 100% in chart.

Regards,

Bharath

photo
1

Hey Bharath,

Could you show me where you have placed the fields in the chart builder? and could you test switching them around?

Best Wishes,

Lesley

photo
1

Hey Bharath,

Hope you are well :)

Just wanted to check in on this ticket to see if you swapped the fields around in the chart builder and then adding the conditional formatting to the field in the measure box made any difference in helping you get the desired results?

Let me know - I will be happy to continue looking into this with you if you need!

Best Wishes,

Lesley

photo
1

Hi Lesley,

No luck so far, I will share my screenshots today.

Regards,

Bharath

photo
1

Good Morning, Bharath!

Thanks for letting me know :)

Once you send across the screenshots we can see whats going on, could you also send across a screenshot of the report builder too?

Best Wishes,

Lesley

photo
1

Hi Lesley,

Are you available for a short call today, I am not able to follow your last 2 steps. I will show you what I am trying to do.

Regards,

Bharath

photo
1

Good Morning, Bharath!

Yes, of course -I am available for a screen share from 12pm UK time onwards - let me know a time that best suits you and I will send across the ring central meeting details :)

Best Wishes,

Lesley

photo
1

Hi Lesley,

Sure, lets connect at 12 PM UK time. Please share the meeting link.

Regards,

Bharath

photo
1

Hi Lesley,

Please confirm whether 12 PM is ok for you?

Regards,

Bharath

photo
1

Hey Bharath,

Apologies, yes 12pm is great!

Please find the details below - look forward to speaking with you shortly :)

Best Wishes,

Lesley


Hi there,


Lesley-Anne Goggin is inviting you to a scheduled RingCentral meeting.


Topic: Lesley-Anne Goggin‘s RingCentral Meetings

Time: Jul 16, 2020 12:00 PM London


Join from PC, Mac, Linux, iOS or Android: https://meetings.ringcentral.com/j/1486426237

For the best audio experience, please use computer audio.


Or iPhone one-tap :

US: +1(469)4450100,,1486426237# (US South)

+1(470)8692200,,1486426237# (US East)

+1(623)4049000,,1486426237# (US West)

+1(646)3573664,,1486426237#

+1(650)2424929,,1486426237#

+1(720)9027700,,1486426237# (US Central)

+1(773)2319226,,1486426237# (US North)

+1(213)2505700,,1486426237#

+1(312)2630281,,1486426237#

+1(346)9804201,,1486426237#

AU: +61370188280,,1486426237#

+61(261)890600,,1486426237# Australia

+61283108040,,1486426237#

+61283109682,,1486426237#

GB: +442038754507,,1486426237#

+442038851310,,1486426237#

+441613027099,,1486426237#

+44(203)7446581,,1486426237# London, UK

+44(203)7446776,,1486426237# United Kingdom

JP: +81645602947,,1486426237#

+81345711358,,1486426237#

+81(345)907467,,1486426237#

Or Telephone:

Dial(for higher quality, dial a number based on your current location):

US: +1(469)4450100 (US South)

+1(470)8692200 (US East)

+1(623)4049000 (US West)

+1(646)3573664

+1(650)2424929

+1(720)9027700 (US Central)

+1(773)2319226 (US North)

+1(213)2505700

+1(312)2630281

+1(346)9804201

AU: +61370188280

+61(261)890600 Australia

+61283108040

+61283109682

GB: +442038754507

+442038851310

+441613027099

+44(203)7446581 London, UK

+44(203)7446776 United Kingdom

JP: +81645602947

+81345711358

+81(345)907467

Meeting ID: 148 642 6237

International numbers available: https://meetings.ringcentral.com/teleconference

photo
1

Hey Bharath,

Thank you for joining the call and I am sorry, I started to lose my voice at the very end of it!

I am very pleased we managed to find a solution for this! To instead use the Max aggregation in the chart which allowed for the target to display the max value :)


Let me know know if you do have any further questions - I am, of course, happy to help! If not, I will mark this question as answered.

Best Wishes,

Lesley

photo
1

Hey Bharath,

I hope you are well!

As you did not get back with any further questions, I will go ahead and mark this as 'Answered' - Again, I am pleased we were able to resolve this issue during the screen share! :)

I hope you enjoy the rest of your week!

Best Wishes,

Lesley