Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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;