Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
so i have following field
StudentID | DateStamp | TimeStamp | |
---|---|---|---|
Eric | 3/22/2018 |
| |
Eric | 3/22/2018 | 3/22/2018 5:04 PM | |
Eric | 3/22/2018 | 3/22/2018 9:05 PM | |
Paul | 3/5/2018 | 3/5/2018 8:05 AM | |
Paul | 3/5/2018 | 3/5/2018 2:00 PM | |
Paul | 3//5/2018 | 3/5/2018 6:06 PM |
Combo chart:
dimension: StudentID & DateStamp
expression: count(TimeStamp)
My issue is that my date fields is not distinct and its not charting properly. How can i make dimension to only show distinct DateStamp
You can resolve this in script or use a calculated dimension
Script
Date(Floor(DateStamp)) as DateStamp
CalculatedDimension
Date(Floor(DateStamp))
Thanks
And how would you write expression that counts how many times Student access system on that date.
it shows total count, instead of per date total.
Not sure what you mean? For the sample, what is the expected output?