topic Re: Reference line for Selected months in Visualization and Usability

Reference line for Selected months

KumaRan — Thu, 14 Sep 2017 09:29:00 GMT

Hi all

I need to show reference line in chart.following expression is working if i select any one month or 2 or 3 consecutive months. if i select random months answer was not correct. can anyone suggest?

(NetWorkDays(Date(min(Date),'DD-MMM-YYYY'),Date(max(Date),'DD-MMM-YYYY'),$(v_Holiday)) * 8.5))

for examlpe

apr-170 hrs

may-187 hrs

june-178.5 hrs

July-178.5 hrs

aug-178.5 hrs

Sep-76.5 hrs

From the above if i choose apr&may combination- 357

may&june combination-365.5

apr& june combination- 535.5(apr+may+june) (but i need to get 348.5 for Apr & june)

Re: Reference line for Selected months

mdmukramali — Thu, 14 Sep 2017 10:47:35 GMT

Hi,

Can you share sample data Application.

Thanks,

Mukram

Re: Reference line for Selected months

shraddha_g — Thu, 14 Sep 2017 10:48:57 GMT

Share sample app

Re: Reference line for Selected months

KumaRan — Thu, 14 Sep 2017 11:40:45 GMT

PFA

Re: Reference line for Selected months

Neymar_Jr — Thu, 14 Sep 2017 13:03:37 GMT

Hi,

Please find attached the updated app.!

Hope it meets your requirement.

Cheers!

Re: Reference line for Selected months

KumaRan — Fri, 15 Sep 2017 05:48:24 GMT

Hi Rajesh

Thank you for your time. its working fine. but my question is ,in future if months are added, do i need to modify expression isn't?

If answer for the above question is YES i need to automate it without adding any expression.Kindly can you suggest?