only showing trends for published and visualized charts in admin