Chart showing data for last 7 days from date selected
I am trying to create a bar chart like the one below showing data from the last 7 days from the date selected. In the past I have accomplished this by creating an alternate state for the chart(s) and having a separate date selection, and then setting up an "on open" event with logic to select the last 7 days. This approach is very clunky for the users. I would like them to be able to drive the charts off of one date selection, which is usually defaulted to the current date, but the user is able to change it.
I have tried the following expression: =if(CLNDR_DT >= Today()-7 and CLNDR_DT < Today(), CLNDR_DT)
This works but only if no CLNDR_DT is currently selected. Would it be possible to do something like this, for example, if only the current date is selected? Thank you in advance for your help!
Best I have is a specific Design Blog post on Set Analysis, which does have some related links at the bottom of it, and I will include the base URL for that Community area too such that you can search further if you wish for more posts, as this is our repository for our how-to related items that our internal people have written.
Sorry I am not more help, I tend to struggle with the development items, but this will kick things back up, so maybe someone better than me will leave an additional post clarifying something for you perhaps.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.