Dynamic Report that Finally Answers Question "What Did I Do Today?"

  • 1
  • Question
  • Updated 4 years ago
  • Answered
I'd like to find a way to create a dynamic report that answers the question "What Did I Do Today?" that counts total Activity Types by User. I'd like to filter on different time periods Today, Yesterday, This Week, Last Week, This Quarter, Last Quarter, This Year, Last Year.

To build a Report Page in Skuid, I have done the following:

Added a text formula field with the value "1" (without the quotes) to the Activity Object called ActivityCountOne__c

Created a Model called ActivityHistory
Created an Aggregation TotalActivities - SUM(ActivityCountOne__c)
Created the Condition OwnerID= '' (inactive)
Created the Condition ActivityDate= (Filterable as ActivityDate) (inactive)
Created the Condtion OwnerId= (userinfo) User Id (filterable as OwnerId_ME) (inactive)
Created the Condition ActivityType= '' (filterable as ActivityType) (inactive)
Create a Grouping ActivityType-ActivityType

Created a Model Called ActivityOwner
Added Fields Name and Id
Created Condition Id - (userinfo) User Id

In a Table,
I addd Type and the Sum(ActivityCountOne_c) fields
I add Filter for ActivityDate with Model Condition to Effect set to ActivityDate
I set Manual Sources for the Filter ActivityDate: Today with Value TODAY. I create also one for Yesterday, This Week, Last Week, This Month, Last Month, This Year, and Last Year with the value in caps with an underscore, if needed, to connect two words.

I created about 4 activity histories for today to use for the test.

When I launch in preview, I get the error:
There were 1 problems with this Skuid Page. Click to display...
1. An error occurred while attempting to perform the following SOQL query: SELECT ActivityType ActivityType,SUM(ActivityCountOne__c) sumActivityCountOnec FROM ActivityHistory GROUP BY ActivityType LIMIT 101 Error:entity type ActivityHistory does not support query

What am I missing?
Photo of krista06880

krista06880

  • 816 Points 500 badge 2x thumb
  • missing something

Posted 5 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
You cannot query on the Activity History object (see http://community.skuidify.com/skuid/topics/can_i_create_a_list_of_activity_records

You should build your activity reporting on the task object itself.  This won't necessarily let you see churn on one particular task,  but if you do you filtering on last activity date,  or due date you can see at least one count for each task. 

I assume you are following along with Anna's tutorial at http://help.skuidify.com/s/tutorials/m/models-conditions-filters/l/102652-aggregate-models-make-dyna...


Photo of Eugene Yang

Eugene Yang

  • 290 Points 250 badge 2x thumb
I need to build something like this, but am not versed as well as you professionals. Any advice or information you can give me before I begin my journey?
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Eugene,  what Krista is doing above is on the right track.  She needed to go against the Task objects.  But other than that,  I believe you can follow her steps and get good results without being a professional.