Dynamic email body:How to refer individual cell values within particular field in report?

Question

Hi,

I am trying to send email with texts referring to particular cells in fields to end user. In report text tool you can only refer to entire column (field) not the individual cells in that column. I have attached sample data set I am trying to write text on. Kind of commentary that I want to write is given below. Also I want to customize numbers with $, %, +, - as the case may be.  Thanks

-Network VCPU: $2.16 for the week; 15.1% unfavorable vs. whole Jan Plan, +$0.032 vs Wk50
-Inbound UPH: 77.8 for the week, +2.6% vs. plan of 75.8; -4.7% vs. Wk50
-Outbound UPH: 26.6 for the week, -14.0% vs. plan of 31.0; +1.0% vs. Wk50
-Fixed (Support) Hours: 106k for the week, -3.0% vs. Wk50
-Total UPH: 34.5 for the week, +2.0% vs. plan of 33.9 (whole Jan); -1.6% vs. Wk50

sample workflow.yxmd

mbarone · Answer

You can filter for individual rows, yes.

I'd suggest checking out the Tool Mastery Index for the Filter Tool, Join, Union, and Report Text.  Hard to tell how to solve your specific problem but most likely will be done with a combination of those tools.

abhinasr · Answer

Ok so you mean to say that I can filter above data set to individual row level so as to have different column/field names for each value. Then how I will combine all the individual row data outputs to connect to one report text tool so that all fields are available for write up in one report text tool?

Also if my column headers in above dataset are also dynamic, how I can include that too in my email body i.e. report text tool?

mbarone · Answer

What do you mean by "cell"?  Do you mean filter for a particular row?  Can't you do that with a filter tool?