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

mmr11408
edited February 11, 2022 in Analytics #1
<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>

Comments

  • GLO_FR
    edited January 13, 2017 #2
    <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 ipb