Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have in my data model the dates with hours, so there is more than one different value for each day.
This is an issue when I make a table with this date as a dimension, because I have more than one register for each day.
Is it possible group all the registers of one day in one unique value without using the script?
Thank you,
Sara
Sure, while you create this in the script, use Floor() function
LOAD Date(Floor(DateField)) as Date
Or you can use the same in the list box expression:
=Date(Floor(DateField))
Sure, while you create this in the script, use Floor() function
LOAD Date(Floor(DateField)) as Date
Or you can use the same in the list box expression:
=Date(Floor(DateField))
You can also use
DayName(yourtimestampfield) as Date
Regards
Marco