Home Analytics Designing reports
The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

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

<p>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?</p>
<p> </p>
<p>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?</p>


  • edited January 13, 2017
    <p>Hi mmr1148,</p>
    <p> </p>
    <p>your solution is very good and BTW very easy.</p>
    <p>Another easy solution is to create 3 computed column</p>
    <p>1) name : row - type ; integer - Expression : 1</p>
    <p>2) name : runningcount - type ; integer - Expression : runningcount(row["row"])</p>
    <p>3) name : rowount - type ; integer - Expression : sum(row["row"])</p>
    <p>and a filter</p>
    <p>Expression row["runingcount"] == row["rowcount"] || row["runingcount"] == 1 - isTrue</p>
    <p> </p>
    <p>Example join</p>
    Guillaume L.
    Solution Consultant
    OpenText Reporting & Analytics
Sign In or Register to comment.