Forum Discussion

jpjeffery's avatar
jpjeffery
New Member
3 years ago
Solved

CSV formatted data

Hello   First dumb post from me.   We have a script which records out-of-hours logons by staff (e.g when staff log on at the weekend, or at 1.30am, that kind of thing). Each event is recorded as ...
Need Help
  • rsbin's avatar
    rsbin
    3 years ago

    jpjeffery ,

    Yes, your data is set up to get you started on your Report.

    Please refer to attached file - I have done a couple of Table Visuals to get you started.

    Hope you can take it from here....

    Good Luck and Regards,

     

rsbin's avatar
rsbin
Community Champion
3 years ago

jpjeffery ,

Yes, your data is set up to get you started on your Report.

Please refer to attached file - I have done a couple of Table Visuals to get you started.

Hope you can take it from here....

Good Luck and Regards,

 

jpjeffery's avatar
jpjeffery
New Member
3 years ago

Great stuff, rsbin. Thank you.

 

I'm trying to replace the existing dummy data with our real data, following this article: How to replace Data Source for existing report 

 

But when I get to the Data source settings dialogue it's proving somewhat uncooperative...

Is this the right way to replace the data, or is there another?

  • rsbin's avatar
    rsbin
    Community Champion
    3 years ago

    jpjeffery ,

    In my sample, I used the Enter Data option.

    You simply have to connect to your source using Transform Data -> New Source, then select Text/CSV.  

     

    Then select the path to where your CSV file resides.

    You can then delete the table I manually created.

    Regards,