Cross tab help
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm having an issue when I use the cross tab tool that I can't figure out. The input data looks like below and I'm using the Cross tab tool to group the data by Day going down and Time going across. So I would expect Day 01 Time 00:00 to be 0 and Day 01 Time 00:15 to be 19.91, however that's not the results after the cross tab tool (see second screenshot). It seems to only be incorrect on Day 1 and the other days are pulling correctly.
I have attached my workflow and input files, can someone please help!
Solved! Go to Solution.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sorting by day and time ascending shows that you have two rows being summed up to get that 29.44 value. So it is working as expected.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yep, that it what is happening. Thank you! Looks like it's being caused by the source data including 4/1 data.
