yeah, the problem is I'm grouping all data into day of the week bins, so I have Sunday = cumulative data for every Sunday, etc.
Would you be able to paste your current search you're using? This will make it easier for search experts to help figure out your issue and work from there 🙂
sorry it's kind of messy, but here it is:
source=Ipc.Recon.Web New merchant. Redirecting to SWC. ServiceKey: 1846869E3691300C, AppPid: 0F4633D95001300C NOT M66128 | dedup MPID | chart count AS auth.net BY datewday | appendcols [search source=Ipc.Sync.Web New merchant. Redirecting to SWC. ServiceKey: 970A36376A11300C, AppPid: A476DC90C001300C | dedup MPID | chart count AS clover BY datewday ]
it just seems if you chart By date_wday, you would want it to come out sunday, monday, tuesday, etc., and not the days alphabetically
I think this is not the cleanest wat, but this should work. Have a CSV lookup for datewday to daynumber. After chart, do the lookup then the result will be 3 columns. Sort based on daynumber and then ignore the daynumber.
I will be eager to know if there is any clean way to get this done
@strive Thanks for chiming in. I was hoping you or another search guru would take a stab at it 😛 I definitely want to learn from the different solutions to this.
@strive that worked!...thanks very much...a lot better than prefixing a 0-6 in front of every weekday name!