(Noob question) How do I change a field to display specific date ranges?

darielly — Sat, 16 Nov 2024 18:36:49 GMT

Hello all,

Apologies for the basic question, I'm quite new to this; I'm making a practice app using some sales data but of course have a great big history of sales (ranging back yeas!). For the sake of the app, I want to make it so that I can display certain years onward and was wondering what the best way of doing this would be?

I'm using our delivery date field as a guideline for when the sale was completed but want to use 2019 as an example range. Would I need to do this from the data load or simply as an expression in the delivery date field on the chart? Could I add a year/month filter so that I could quickly show other ranges?

Thanks for your time!

Re: (Noob question) How do I change a field to display specific date ranges?

Lisa_P — Thu, 21 May 2020 03:05:11 GMT

best place to limit the data is in the data load.

Use a condition in the load or select statement to do this like:

Load ...

Where Year([delivery date])>2018;

topic (Noob question) How do I change a field to display specific date ranges? in App Development

(Noob question) How do I change a field to display specific date ranges?

Re: (Noob question) How do I change a field to display specific date ranges?