Forum Discussion

giovissimo's avatar
giovissimo
Helper I
5 years ago

Problem Calculating the Kilometers driven

Hello, first of all, sorry if my problem has been solved already; I found a similar question, but not exactly the same. My table contains the following fields: Date (which is not relevant), Driver,...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

You are welcome.  The Index column was created in the Query Editor.  See the steps in the Query Editor. 

giovissimo's avatar
giovissimo
Helper I
5 years ago

Thank you again for devoting your time to the solution of my problem.

I've just taken a look at all the steps in the query editor, but unfortunately I can't understand the meaning of that Index column (it's obviously my fault). As far as I can see, it's not linked to the driver, neither to the car.

Isn't it possible to solve the problem without resorting to that Index column ? Just asking.

 

Giovanni

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    You are welcome.  The only reason we need the Index column is to get the 0's that you have shown in the intiial post.

  • giovissimo's avatar
    giovissimo
    Helper I
    5 years ago

    I see, but it's not an automatic counter, right ? So, when I have to add another row, what value am I supposed to write for the Index column ?

     

    Giovanni

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    It is automatic.  You just need to add data to your raw data sheet and click on Home > Refresh All.