Adding multiple lines to a metric?

JDSpec13

Hi all is there a way to add multiple lines to a metric? As an example, I'd like to add a sum of the cost below the metric in the same bubble, I have both the sum of renewals & dollar amount in my pivot, just wondering if I can link both to one widget rather than creating another.

MariaCurtis

Hi! I think this is what you're asking. But there are 2 ways I've found you can do this:

One: You can make sure the data is next to each other in your metrics sheet or data table, and select it all together to add to the metric widget. It doesn't look as clean as #2.

Two: This was is more annoying to set up, but ends up looking better on the dashboard. You can add columns to your metrics sheet, and then put a formula in there to grab the value from your pivot / metrics table. In the red box below is what I selected to add to the metric widget, and it looks beautiful on the dashboard.

Hope this helps! Dashboards are fun! But sometimes I've had to have some super funky workarounds.