How can I create this cross-tab report without aggregations?
16 December, 2013
I am trying to create a cross tab report where I want to have a date completed and score value in cross section without any aggregate functions.
Can you pleasesuggest me how can I do this? You can see my report in below image.
Hi,
There is no way to have a cross-tab with aggregations being applied, this is just how this report works.
When creating cross-tab reports, a lot of extra processing is done, as the data is first returned by the SQL statement (which is what you are testing), though the data is then processed and aggregated within Yellowfin itself.
If you do not want to get aggregated data, you will need to choose another table type, such as row/column. The following wiki may help you decide on what type of table will give you the results you were after: When to Use Column/Row/Cross-tab reports
Sometimes it's a matter of applying report sections, co-display or drill down/through reports to get everything just right ;).
Hope this helps, and please let us know how you go.
Regards,
David
There is no way to have a cross-tab with aggregations being applied, this is just how this report works.
When creating cross-tab reports, a lot of extra processing is done, as the data is first returned by the SQL statement (which is what you are testing), though the data is then processed and aggregated within Yellowfin itself.
If you do not want to get aggregated data, you will need to choose another table type, such as row/column. The following wiki may help you decide on what type of table will give you the results you were after: When to Use Column/Row/Cross-tab reports
Sometimes it's a matter of applying report sections, co-display or drill down/through reports to get everything just right ;).
Hope this helps, and please let us know how you go.
Regards,
David