# Best option for Displaying Metric with $ Value for YeartoDate, MonthtoDate in Dashboard **URL:** \ **Category:** Metrics\ **Created:** [August 18, 2021, 5:37pm UTC](https://discuss.elastic.co/t/best-option-for-displaying-metric-with-value-for-yeartodate-monthtodate-in-dashboard/281863 "2021-08-18T17:37:42Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Athul\_Devkar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/athul_devkar/32/93241_2.png) [@Athul\_Devkar](https://discuss.elastic.co/u/Athul_Devkar)\ **Post date:** [August 18, 2021, 5:37pm UTC](https://discuss.elastic.co/t/best-option-for-displaying-metric-with-value-for-yeartodate-monthtodate-in-dashboard/281863/1 "2021-08-18T17:37:42Z")
Dear All, I am trying to find the best option to display sum of $value for YtD, MtD and QtD in Dashboard. Tried multiple options. However, running in to some issues. Currently issues with these 2 options #1: Created from Metric Viz. Dont have option to add $ and also display multiple entries for each year or month. I need only the current. #2: Created from TSVB, only option to filter the date range is having customized time range, but not able to hide that and it doesn't look good. Please help. ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/7/579bef434352347f43fde0cfb7bf57e7939df490.png) ---
**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\ **Post date:** [August 18, 2021, 6:29pm UTC](https://discuss.elastic.co/t/best-option-for-displaying-metric-with-value-for-yeartodate-monthtodate-in-dashboard/281863/2 "2021-08-18T18:29:53Z")
Not sure what the end result you are looking for but I would look at creating a scripted or runtime field that uses the [currency formatting](https://www.elastic.co/guide/en/kibana/current/numeral.html#_currency)? ---
**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\ **Post date:** [August 18, 2021, 6:44pm UTC](https://discuss.elastic.co/t/best-option-for-displaying-metric-with-value-for-yeartodate-monthtodate-in-dashboard/281863/3 "2021-08-18T18:44:14Z")
Perhaps just go into the index pattern and set the default format for that field (I did this a metric that is not even a currency) Note : A side effect of this is it will show with the `$` in all places... ![Screen Shot 2021-08-18 at 11.43.23 AM](https://us1.discourse-cdn.com/elastic/original/3X/b/e/be477a0679f227e5df8332fd1d04b270e8e48fbf.jpeg) Here is the lens Metrics Now ![Screen Shot 2021-08-18 at 11.41.12 AM](https://us1.discourse-cdn.com/elastic/original/3X/0/5/05aca4110026bfde37ffb19c71f8dc9e138d9872.jpeg) ---
**Author:** ![Athul\_Devkar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/athul_devkar/32/93241_2.png) [@Athul\_Devkar](https://discuss.elastic.co/u/Athul_Devkar)\ **Post date:** [August 18, 2021, 7:36pm UTC](https://discuss.elastic.co/t/best-option-for-displaying-metric-with-value-for-yeartodate-monthtodate-in-dashboard/281863/4 "2021-08-18T19:36:11Z")
Thanks, I will try that! Is there any way I can filter just those metrics by YtoD/MtD when displaying on the dashboard? Currently when I try the Metric viz option. It shows like this. Where as I would like just the current month or year. ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/3/d3867520517c550bb1be45b591df1472268853be.png) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 15, 2021, 7:37pm UTC](https://discuss.elastic.co/t/best-option-for-displaying-metric-with-value-for-yeartodate-monthtodate-in-dashboard/281863/6 "2021-09-15T19:37:49Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.