Search Results

Search results 1-3 of 3.

  • User Avatar

    Transform avg

    EstherA - - Jedox Integrator

    Post

    Hello, I wanted that for the grouping of TodosProyectos with one of the measures (Productividad) make the average. I think that is achieved in TableTransforms and the extent to avg agregaccion right? Without making SQL Thanks

  • User Avatar

    Transform avg

    EstherA - - Jedox Integrator

    Post

    Hi, The file contains: Proyecto / / horasIncurridas / / horasFacturadas / / Productividad / / idTiempo A single project appears multiple times with different idTiempo I have done: TableTransforms a Normalization Thanks

  • User Avatar

    Transform avg

    EstherA - - Jedox Integrator

    Post

    Hi, I extract a csv file. Proyecto(text) // HorasIncurridas(numeric) // HorasFacturadas(numeric) // Productividad(numeric) TablaTranforms: Field name = Proyecto(text) Measure = HorasIncurridas (Aggregation=sum) HorasFacturadas(Aggregation=sum) Productividad(Aggregation=avg) But "Productividad" failure to perform AVG Why? because I made the sum Thanks