Created a date dimension that includes 30 rolling days. I want to use this dimension in a graph that will have time on x axis and sales as response. Is there any way to make this dimension interact-able? I think the issue may be on the axis, continuous scale stuff, but do not know what is needed in expression to be able to change this. Any help?
The expression I have so far is:
(if(([completed_date])>=(today())-30 and([completed_date])<= (today()),[completed_date]))
Thanks in advance