Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a min value in a variable ( May -2018). I have a max value in a variable ( 0ct-2019). I have a column in a table with the months from 2017 to 2020. I need to create a bar chart within this range ( min value to max value). Can anyone help me fix this.
Thanks in advance.
Here is a quick and dirty example:
=If(DateField >= $(vMinDate) and DateField < $(vMaxDate), DateField)
Note: In my examples the variables themselves contain single quotes around the values and that I purposely showed >= to the MIN date, but just < the MAX date. Change accordingly.
Be sure to uncheck the "Include null values" box to avoid showing the others as a gray bar