metric

Hello, I am using below formula in order to get the data from PIVOT but the thing is it is getting more bigger and bigger as I have to add the numbers of all the months. Can someone please suggest a smart way of doing so? =IFERROR(SUM(GETPIVOTDATA(T(P$6),Pivot_EBTDA!$B$5,"Substream Leader...

Hi, I've got what seems like a simple conversion task that I'm having trouble puzzling out. I have a column of product descriptions (text/html) that contain measurements (i.e. "Medium - 6.3cm x 7cm") and I need to find and convert them from cm to inches. I'm having trouble figuring out how to...

Hi I have various datasets in columns against week numbers over a period of time. I am looking for a way to graph the data in a single column that the user selects. The week number will always be the x axis and whichever metric is selected would need to be on the y axis. essentially, I want...

I am looking to display the percentile of a value based on multiple conditions. Column K is my score, Column E is my organization, and Column H is my metric. For these, I'd like to see the percentile for each score based on each individual organization and metric.

With Excel 2010 I had no problem populating and saving a Word template of a metric comprised of various charts, shapes, tables etc. to a .png file. This facility's monitors require image files and they were essentially a screen shot of the document. But when I upgraded to Office 2016 this week...

Hi All, I need assistance in entire code please.. It's easy to make the code b'coz, formats of the sheet are same.. I have 7-8 sheets. I want all data combine in single sheet.. Format of sheet like below-- Columns A, B, C, D & E are merged from row 2 to 24. i.e 23 row's. Column F contains...

I've been tasked with adding stupid arrows to our metrics per the governance of our metric process... yay!...... sigh.... So, what I essentially need to do is create an IF statement (I think), that says... When this metric (cell) stays the same, use the RIGHT Arrow shape and color it Yellow...

Hi All. I need an formula that will pull data from a sheet like this. <colgroup><col style="mso-width-source:userset;mso-width-alt:2157;width:44pt" width="59"> <col style="mso-width-source:userset;mso-width-alt:2084; width:43pt" span="5" width="57"> <col...

Hi, I have 3 sheets in a Workbook named in the brackets. 1. The main LOGIN sheet(Login) 2. Second sheet containing list of 101 usernames and passwords in column A and Column B respectively (Admin) 3. The sheet which you navigate to after logging in successfully. (Metric) I need a VBA code to...

I currently use the below code to split data by provider last name, from a list of quality metrics that are due. This is a multistep process to trim the csv file I receive with 60 columns of data and a variable number of rows, down to the 9 columns of data that I have sorted by what is...

Does anyone know how I might use DAX to calculate our “Frequent Caller” metric here at work?… we say that anyone of our members who has called us more than one time in a week is a “Frequent Caller”… the data set is made of rows, each row is a call, with the date of the call. The DAX calculation...

Hello, I have a large data set that is similar to the following. <tbody> Prod $ Sales Unit Sales Volume % Disc A $100 50 300 10 B $150 25 150 15 C $75 100 200 10 D $200 75 50 20 </tbody> What I ultimately want is a dynamic table (separate from the large data set and with all the same...

I am displaying three metrics in a pivot table for multiple employees. I have pulled each metric into the pivot table and displayed the second instance as a rank - largest to smallest. I want to rank each employee by the sum of their ranks, i.e. <tbody> employee metric 1 m1 rank metric 2 m2...

Hi All, I'm trying to do some conditional formatting that appears to be more complex than what excel wants to do: I have a set of about 10 metrics. For each metric I want to do the following: A) If the metric went up or down from the prior period, I want to see an arrow going up or down (or...

First post! I searched/read as many posts as I could but could not find that matching my problem. I have a work sheet that uses allot of =if() and =choose() formulas. Based on what a cells value is though I would like that to determine the number of decimal places shown in unlocked(manual...

Greetings, I have yet to come across anything quite like this and I will try to be as thorough as possible... I have been given a sheet of raw data that spans 6 months of time, consisting of 11 columns and 4000+ rows. I am focused on 4 very specific columns: "Ticket Priority" "Ticket...