I am using a data island to define: Day, Week, Month and use a list box set to the data island to toggle my graphs and text objects to change based on what has been selected. Currently I am able to include a specific date in the script, but I can't quite figure out how to include a date range.
My declaration of the data island is:
LOAD * INLINE [
The Exp column is used in text objects to change the outputs. An example of one of them is:
This counts the distinct number of SessionIDs and outputs the number in the text object. And this is where I am having problems getting the range to work, because with charts and graphs I just check conditional and re-write the expression based on whats selected.
I've tried declaring the Exp a few different ways: