Setting a Target for Meter Chart does not work

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

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 -

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

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

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

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

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.

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. -

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 -

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

Hi Lesley,

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

Regards,

Bharath

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

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

Hi Lesley,

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

Regards,

Bharath

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

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

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

Hi Lesley,

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

Regards,

Bharath

Hi Lesley,

Please confirm whether 12 PM is ok for you?

Regards,

Bharath

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

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

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