In Q&A, tried queiries below, cannot get distinct count or order id.
Show Distinct Number of Order IDs on by Order Year
Show Number of Distinct Order IDs on by Order Year
Show Number of Order IDs Distinct on by Order Year
Go to Solution.
I fixed by myself, it was becasue not sure why the column Order ID wass disabled:
1. Click right upper corner cogweel
2. Field synonmyms
3. Expend the table fields
4. Enable the Order ID column
View solution in original post
HI @Todayboy ,
I glad to hear you solved it!Thank you very much for share solution!
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!