Is there a way to arrange data in a Metric Widget?
On my Dashboard, I have 3 metric widgets displaying metrics from 3 different departments via summary data from a sheet. 1 of the 3 widgets displays the information in an ABCD order while the other 2 display it in a DABC order. How can I reorder the data so that it is consistent and in the order I want? I would not think that this would be too difficult but after much searching, I cannot find any mention of how to do this!
Thanks!
Best Answer
-
Paul Newcome ✭✭✭✭✭✭
If you hover over the data point, you should be able to grab the button on the right and click and drag it up and down.
Answers
-
Paul Newcome ✭✭✭✭✭✭
If you hover over the data point, you should be able to grab the button on the right and click and drag it up and down.
-
情景应用程序ardy ✭✭
I knew this had to be an easy fix but I just couldn't find it. Thank you so much, Paul!
-
Paul Newcome ✭✭✭✭✭✭
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/106723/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/106723/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p> Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
<\/p>