1 Reply Latest reply on Oct 2, 2018 12:19 AM by Binod Naik

    Line graph to completed week

    Tony Smith

      Hi All


      Can someone please help me with the query below.


      I have a line graph that shows the Current year, Last year and Budget sales figures.  The line showing on the graph is up to the BBCA FISCAL week in year.


      But what I want to see is 52 weeks line for Budget figures and Last year sales figures.  I also want a line for the current year up to the completed week.


      Please see attachment for report.






        • 1. Re: Line graph to completed week
          Binod Naik

          Hi Tony,


          Plz see attached wrkbook, 2nd Sheet "Chart 1 (2)".

          - Updated the Calculation for "Current Year Sales", created new Calculated field - "Current Yr Sales", used 'NULL' instead of '0'. Used this Cal Field in Viz instead of "Current Year Sales"

          - Removed "Filter Fiscal Week YTD" from filter shelf


          Now Capturing Sales data for complete 52 Wks. Hope this helps.




          1 of 1 people found this helpful