Create last change in value of status for present it in chart

Ask for Help
1

Hi all.
I can’t figure it out,
I have some charts and statistics about the work record of the call center.
there is a chart I want to show which is:
//Today

Num of leads enters the system. //new raw added
Num of closing //changed Status
Num of follow-ups //changed Status
Num of fails. //changed Status
Num of no answers //changed Status

I can get all this info if I could show in the chart the changes made in my STATUS column //Today
thanks for the help.

2

What type of chart do you want to show? Is your question “how to get those types of info” or something like “how to count how many times my status column changed”?

3

thanks for getting back to me. it was a simple solution and no code was required on the sheet, filter the data by date is today with a label on the content for status.
thanks again.

4

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.