Avatar

sivan Zohar Avda

  • Total activity 9
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 2
  • Subscriptions 2

Activity overview

Latest activity by sivan Zohar Avda
  • Avatar

    sivan Zohar Avda created a post,

    avg score with null values

    Hii,   I have a problem when I calculate the avg score between 2 survey for each dimension and on of them has null values the avg is wrong.   For example :   dim Score survey   type 1 Score...

  • Avatar

    sivan Zohar Avda created a post,

    filter by formula in pivot

    Answered

    Hii, I have a table of branches that contain the branches in my organization and I want to show on each branch if there was a log in instace in a certain month or not (boolean) The log table contai...

  • Avatar

    sivan Zohar Avda commented,

    It worked :) thanks

  • Avatar

    sivan Zohar Avda commented,

    hi, Thanks for the reply. I want to calculate a single indicator the shows the avarage of usage ("days of use" divded by"num of days in month") for all of the branch in the orga...

  • Avatar

    sivan Zohar Avda created a post,

    Average of distinct values

    Answered

    Hii, I have problem.  I have a table of log times per user. the user is connect to a branch. for every branch i calulated the distinct values of days that the users loged in divided by the number o...