Best practice to display first and last entry from a CSV data set

I will be creating 50+ reports from a few CSV files which will be similar in nature. Most of the reports will have a line or bar chart and would need to display the first and last day that data is available (which of course changes). I have gotten that working by defining two lists, assigning a group to them and in the group using “Bottom n” and “Top n” operators in a filter with the value of 1. Is there a better way to do that?


The easiest way that I have found to replicate that has been manually copying the lines for the lists from the xml file of an existing report and pasting them in the xml file of the new report before the <table>…</table>. Is there a better way to do that?


  • edited January 13, 2017

    Hi mmr1148,


    your solution is very good and BTW very easy.

    Another easy solution is to create 3 computed column

    1) name : row - type ; integer - Expression : 1

    2) name : runningcount - type ; integer - Expression : runningcount(row["row"])

    3) name : rowount - type ; integer - Expression : sum(row["row"])

    and a filter

    Expression row["runingcount"] == row["rowcount"] || row["runingcount"] == 1 - isTrue


    Example join

    Guillaume L.
    Solution Consultant
    OpenText Reporting & Analytics
Sign In or Register to comment.