Has anyone been able to display dynamic data on a button?  Let's say I want a dashboard of projects showing their status.  I may have "New", "Open" and "Closed".  I can use a KPI to display that in a nice dashboard format, but KPI's are not drillable (the enhancement is on the list!).  My thought is to have three buttons that will display the number of projects in those statuses, and, if the user clicks on the button, they can get a modal with the list of projects in that status (just like a regular modal when drilling).  

I found some reference to ApptioScripts, but there wasn't much information out there to help guide me.  

Any help is appreciated!

So not sure how to do what you are asking, but what I have done in the past is create a button underneath the KPI with a click me caption

I agree, and that was my first thought, but I didn't want the traditional KPI look.  Thank you for mentioning!  It's nice to hear other people using some of the same hacks.   

#

Hi Candace,

It is totally doable. Here are the steps:

1. Create an ad hoc table with a filter for projects with status = NEW (or any other filter) . Make sure there is only a single row in the table.

2. Right click the table and click on Show Full Datapath

3. Copy the Datapath text

4. Insert a button

5. Right click the button and click on Edit Datapath and paste the datapath you coped in step #3 and Click OK

6. Right Click the button and click on Properties 

7. In the Button Text field, enter: NEW <%=METRICNAME%>
where METRICNAME is the name of the column or metric that has the information you need.

Click Apply and you should see your metric.

Let me know if you are facing issues. Basically the steps are to give context to the button and then use apptioscript to show the dynamic value.

Good Luck!

Sanjay V.

Super cool Sanjay, thanks for this! Will probably be using it in the future

Thank you!  This is really close, but the button is displaying "New".  I was hoping to get the button to display the data from the table.  My table has one row, which is the count of projects in the "New" state.  At present, there are 46.  I would like the button to display the "46", or whatever the table shows at the time the report is viewed.