This content has been marked as final. Show 7 replies
I have date column.So i set "DayName" column properties sort column order i selected "date" column.Now if i create pompt it repeated multiple times like Sun,Mon,Tue,Wed,Thu,Fri,Sat Again Sun,Mon,Tue,Wed,Thu,Fri,Sat............................
I trying to put distinct but it return error.How to avoid multiple entry.Is there any other way solution
I created Logical column dayName(date) and DayOfweek(Date).In DAYNAME column properties i set order by DAYOFWEEK.
After i selected new sample report selected DAYNAME then values displaying correct Sun,Mon,Tue....Sat. But same column i selected prompt.In prompt shows multiple values again.
Thanks for your reply veera.
Thanks a lot veera.Fixed.
I used like below
SELECT Time.DayName FROM "Sample Sales Reduced" Order by Time.DayOfWeek
Now working fine.
Yes i selected same dayName only in prompt.But when i select logic sort,It not displaying distinct values(Mutiple Values).
Anyway thanks.If you any idea then share us thanks.
You may go for distinct using SQL.
Sort by column is suppose to relevant to the column.
For day Names you used dayofweek since there are 7 day names and 7 from dayofweek.
Just in case you got 8 you may end up 2 sundays.
Since you have option to use SQL so got so many options.. just explore it.
for issues let me(us) know where are there to help :)