changed api query for graphical overview