Variables to drive charts

[#1]

Hello Experts,

I have a dates to variables question. I have date Dimension field called History_Date in the format of DD/MM/YYYY. I want to create 2 variables History_Date_From and History_Date_To, so that a end user makes a selection of 2 dates, then the chart should calculate the sum(sales). Earlier I have done something similar using AutoGenerate function for just weeks... but here its a full date format, so a bit confused as to how to do it.

Any suggestions are welcom and Thanks in advance

Mady

[magavi_framsteg · Accepted solution]

Hi again.

Usually when I want to do this, I create a button with a series of actions:

- 1. Clear all or clear certain fields

- 2. set variable vFromDate = (blank)

- 3. set variable vToDate = (blank)

- 4. some other action