Dynamic Fluid Tile
My goal is to create a tile on the ESS homepage that will show all of our hourly employees their average hours worked. If I have a query that returns emplid and the avg Hours number, is there a way to display that number on a tile. I have been able to 'link' the tile to the query - meaning, if the user clicks on the tile, it'll show them the query results, but I want to simply have the number displayed as if it was a pivot grid type dynamic tile.
Any thoughts on how to accomplish?
My first attempt was creating a content reference using a PS Generic URL that pointed to the query. I then used the TIle Wizard with the data source of PS/SQL...which prompted me to use KPI's.... Again this only led me to have a tile that, when clicked on, opened to the query results.