Please add both "Inclusions" and "Day of the Week" to the data set for MinimPurchaseItemDetail
A
Agate Alpaca
If you have not resolved this by now, here is how you can do it.
There are 2 ways of achieving this in Analytics:
- (Simplest) In the Tabular view, in the "View mode", highlight the Date column you are interested in. There is a "Format" button to the top of the page. Click on the Format and you will be given the option to set the Date format you want. If you want:
Fri, 07/04/2025
use
EEE, MM/dd/yyyy
OR for
Friday, 07/04/2025
EEEE, MM/dd/yyyy
- You can modify the Query to add 1 more line such as
"MinimItineraryDetail"."arrivedate" as "Start Date Day",
I am not sure what the database you are using is called. for me, I am using the "MinimItineraryDetail" for my report. It should be similar for you.
That should give you a separate column that you can use in your Tabular report and Format the day of the week as described above with the code:
EEE for Fri
or
EEEE for Friday.
Good luck!