Status Box!

[#1]

Date	A end count	B end count	C end count
9/28/2016	143	172	28
9/28/2016	127	173	37
9/29/2016	120	219	41
9/30/2016	245	219	20
10/3/2016	75	220	20
10/4/2016	0	223	0

Hi!!

this is the same data for my question.this is a task tracker. and work comes into my tasktracker as i am working. so I just log the number of tasks that I have on my queue at the end of the day. so that the next day, i can start with something that has most volume in the task tracker.

what i want to do is make a small box that contains the most recently logged end count for the three jobs.

so today is 5th Oct and I did not log any anything. but the most recent task tracker log says that i have 0 task for project A 223 tasks for project B 0 tasks for project C

I want them to float in a box with caption name project A and contents with larger sized numbers.

Please help!!

Thank you in advance!!

[sunny_talwar]

You are looking to display the most recent information for the three projects in a text box object? Is that what you are looking to get?

[#3]

Yes! exactly!

they are the numbers I want to have pop out so that it is easy to tell which of the three I have to prioritize.

it will be literally a status box

[#4]

for our dataset. it will look like this!

[sunny_talwar]

Status box? What is a status box? I am not sure I understand

[sunny_talwar]

May be three text box objects like this::

='Project A' & Chr(10) & Sum({<[Project Name] = {'A'}, Date = {"$(=Date(Max(Date), 'M/D/YYYY'))"}>} Count)

='Project B' & Chr(10) & Sum({<[Project Name] = {'B'}, Date = {"$(=Date(Max(Date), 'M/D/YYYY'))"}>} Count)

='Project C' & Chr(10) & Sum({<[Project Name] = {'C'}, Date = {"$(=Date(Max(Date), 'M/D/YYYY'))"}>} Count)

[sunny_talwar]

Sample attached

[#8]

For this dataset, I do not have column named Project Name.

like the above dataset that I provided, the name of the column is just A end count, B end count, C end count.

[#9]

thank you for the sample attached! but the dataset looks exactly like I provided!

[sunny_talwar]

Then try these expressions:

='Project A' & Chr(10) & Sum({<Date = {"$(=Date(Max(Date), 'M/D/YYYY'))"}>} [A end count])

='Project B' & Chr(10) & Sum({<Date = {"$(=Date(Max(Date), 'M/D/YYYY'))"}>} [B end count])

='Project C' & Chr(10) & Sum({<Date = {"$(=Date(Max(Date), 'M/D/YYYY'))"}>} [C end count])