7 Replies Latest reply on Oct 10, 2018 8:04 PM by Deepak Rai

    How to filter only Minimum and Maximum in a chart for a date column

    Vignesh Srinivas

      Hi All,

       

      I made a bar chart which typically shows last 3 months data. (Bar for every week) I want to apply a filter in my worksheet, that typically shows only Minimum and Maximum of the date field. For example, currently it has data from July 8 to October 8, and bar chart for every week. I want to show only 2 bar charts, one for maximum date (October 8) and one for minimum date(July 8). This max and min filter should keep changing based on current data's max and min values of date field.

       

      how do I achieve this? Appreciate any suggestions.