https://community.splunk.com/t5/Getting-Data-In/How-to-filter-by-dimension-and-include-names-in-mstats-result/m-p/325076#M60464 <P>Hi All,</P> <P>I am looking for a way to filter by dimensions and include their name in mstats result so that down the line I can have charts per metric and dimension. What is the way of referencing custom dimensions?</P> <P>Regards,<BR /> Bartosz </P> Tue, 10 Apr 2018 07:43:29 GMT bdjoulica 2018-04-10T07:43:29Z https://community.splunk.com/t5/Getting-Data-In/How-to-filter-by-dimension-and-include-names-in-mstats-result/m-p/325076#M60464 <P>Hi All,</P> <P>I am looking for a way to filter by dimensions and include their name in mstats result so that down the line I can have charts per metric and dimension. What is the way of referencing custom dimensions?</P> <P>Regards,<BR /> Bartosz </P> Tue, 10 Apr 2018 07:43:29 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-filter-by-dimension-and-include-names-in-mstats-result/m-p/325076#M60464 bdjoulica 2018-04-10T07:43:29Z https://community.splunk.com/t5/Getting-Data-In/How-to-filter-by-dimension-and-include-names-in-mstats-result/m-p/325077#M60465 <P>Can you provide some sample data?</P> Tue, 10 Apr 2018 14:05:08 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-filter-by-dimension-and-include-names-in-mstats-result/m-p/325077#M60465 p_gurav 2018-04-10T14:05:08Z https://community.splunk.com/t5/Getting-Data-In/How-to-filter-by-dimension-and-include-names-in-mstats-result/m-p/325078#M60466 <P>I'm not really sure what you want to accomplish directly.<BR /> But if you use mstats like this:</P> <PRE><CODE>| mstats latest(_value) AS last_value WHERE index="my_metrics" metric_name="*" by custom_dimension, metric_name </CODE></PRE> <P>You are able to use metric_name as well as the custom_dimension field after this command. As well as metric_name and the values of all the metrics.<BR /> hope that helps.</P> Tue, 29 Sep 2020 23:10:29 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-filter-by-dimension-and-include-names-in-mstats-result/m-p/325078#M60466 effem 2020-09-29T23:10:29Z