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,

     

jpjeffery's avatar
jpjeffery
New Member
3 years ago

Using Transform Data as you described threw up some difficulties, BUT, looking carefully at your sample file (it took me a few goes) showed me how you added those COUNT columns, at which point I was on my way!

 

Look at this thing of beauty...!

 

 

So, thanks for your help, rsbin! I really appreciate it.