Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all
i've a issue and i can't fid the solution myself . thanks for helping.
I load data contain the fuel statement by date of my véhicle like this
affectation,vehicle registration, date, kilometrage, amount, volume
i made a table like below to calculate the différence (Ecart) in km like that (firstsortedvalue (Kilométrage, -Date2)-firstsortedvalue (Kilométrage, Date2)
i would like to aggregate the Ecart for a special dimension but i can achieve this . (sum of the "Ecart" by "affectation")
for example i would find
EST = 153 344 km
OUEST = 58 258 km
can someone help me please
Hi @francois_974 ,
Can you please share the sample dataset
Hello
thanks for your reply
the data file join here . it's a fuel statement that i encrease monthly .
i've got few pb because we change the fuel provider thats why i use the "date2" instead of "date de transaction"
do not hesitate ti join me if it wasen't clear
Francois