Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
This seems like a basic question as this feature seems to be common. I've seen this accross the top of most example dashboards.
How can I take a sales date column and create a listbox that contains unique values of the dates in both month spelled out (Jan) format and YYYY.
Also, how do you make the listbox horizontal instead of vertical?
Thanks.
The field names are the part in [] after "as" in each of the loads, or just the name given in the source file if there is no "as". You'll see them when you build a list box, so once you've run the script, it shouldn't be confusing. They'll be these for the above example:
ID
Term Date
Term Month
Term Year
The second script I gave includes the years associated with the months. The first does not.