Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am having an issue when I am using a straight table. What am I missing?
Data correctly displays fine in tablebox like below. Customer came on 2015-11-02 and left on 2015-11-05. Then came back on 2015-11-08 and left on 2015-11-10. Then came back on 2015-11-11.
ReVisit | OverRallID | Name | CheckIn | CheckOut |
---|---|---|---|---|
2015-11-08 | 100 | Johnson,James | 2015-11-02 | 2015-11-05 |
2015-11-11 | 100 | Johnson,James | 2015-11-08 | 2015-11-10 |
But in Straight table, it displays like below. It seems like it is confused since there are 2 revisits to pick from which will be 2015-11-08 and 2015-11-11. When I select 8th or 11th revisit date from the master calendar(day), then all values pops-up in the below straight table for that specific revisit. However, I want it to display all the rows like in table box above without me manually picking either 8th or 11th.
ReVisit | OverRallID | Name | CheckIn | CheckOut |
---|---|---|---|---|
- | 100 | Johnson,James- | - | - |
I also confirmed that I have not checked "Supress when value is null". How can I fix this? I want to use the straight table so that I can add more calculated fields. Please assist. Thanks a lot.
I got it. I was using only OverRallID as the dimension but I added VisitID in the dimension as well and that did the trick. Since OverallID remains the same for the specific customer but VisitID changes every time they revisit. Just updating if anyone else comes across this issue. Thanks.
I got it. I was using only OverRallID as the dimension but I added VisitID in the dimension as well and that did the trick. Since OverallID remains the same for the specific customer but VisitID changes every time they revisit. Just updating if anyone else comes across this issue. Thanks.
Awsome
Go ahead and mark your own answer as correct to close the thread.
-Rob