5 Replies Latest reply on Aug 17, 2018 2:51 AM by Sankarmagesh Rajan

    Custome view

    Prajval T

      Hi Team,


      can any please help me to develop below custom view with side by side and lines (One dotted line and one solid line).

      PFB FYR.


      Note: Please response ASAP. this is critical for me.




        • 1. Re: Custome view
          Ritesh Bisht

          Hi Prajaval,



          Have you tried this


          Did you try a dual axis and instead of Line, you use circles stacked on it? That's one way.


          I'm sure you did that. Here's the next way.


          Drag and drop DATE on your PAGES. Then open the settings.


          Screen Shot 2017-12-05 at 12.48.22 PM.png

          You're going to want to play around with this box called 'Show History'

          Screen Shot 2017-12-05 at 12.48.29 PM.png

          Screen Shot 2017-12-05 at 12.46.59 PM.png


          Or try this calc and add to detail


          if last()=0 then 1

          elseif first()=0 then 2

          else 0



          Find more ---->Dotted Line Charts




          Please mark the answer as HELPFUL/CORRECT if it really helped you so that it can help others as well , help the community back

          • 2. Re: Custome view
            Peter Fakan

            Hi Prajval,


            Unfortunately this is about the closest I think you can get to the solution - its a dual axis with bars in measure names, then line on the dual axis, and a reference line approximating the dotted line you were after.


            But I'm questioning why you need to mark the value as a dotted line, where I come from dotted lines are only used in treasure maps, and in your case, you could use a light grey tone to denote something you aren't really meant to look at, or use the tooltips to indicate the actual value.






            • 3. Re: Custome view
              Prajval T

              Hi Peter,

              your solution is not helped.


              Because client want strictly side by side chart with lines like how I have mentioned.


              • 4. Re: Custome view
                Prajval T

                Hi Ritesh,


                No I did not tried, because I need side by side with lines. not only single dotted line.


                • 5. Re: Custome view
                  Sankarmagesh Rajan

                  Hi Prajval


                  dotted lines | Drawing with Numbers