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>
<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>
0
Comments
-
<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>
Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 105 General Questions
- 142 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management