Ok, I think I understand what you want. You would like to apply one filter, picking a person (Id in your example) and showing how many calls that person has created and closed.
I suggest you reshape your data into more of a flatted structure, creating one column for the person rather than the multiple you have in your dataset. Something like:
CallId PersonID Record Type etc
1 1 Create
2 2 Create
1 2 Close
2 2 Close
I can not reshape the data it's in production i just have to create some simple reports using this data only.
Even they want me not to use even Custom SQL query.
Can i write some condition in by formula so that
for sheet one use this field
and for 2nd sheet use ...... field ?????
I assume you would like to be able to filter the person and return their created and closed counts? In which case you can use a parameter or reshape the data.
An alternative, which would also introduce some challenges, would be to use an action filter. You would put one of your Person fields - which would need to contain all people - into a table as a list.
Drag this on to a dashboard and set up a couple of 'on click' action filters. In this screenshot that's what I've done. You can see the table which is a filter on the right and how I've set up one of the action filters, with an important bit highlighted. The other action is simpler, the target fields are ClosedById = ClosedById. Note the data type needs to be the same - I changed them all to integers.
1 of 1 people found this helpful
I would suggest. Try to calculate counts (All Calls & Closed calls) using ID field and use ID as quick filter and make it global filter. As per my understanding you're tracking records of all call and closed calls made by which ID. If I'm not wrong your Created by field contains information of ID field. Like in your Closed Records calculated field you can do something like this
COUNTD(IF [Status]='Closed' THEN [Id] END) . Let me know if you've any query.
e.g; global filter