Pivot tables in advanced Analytics

Brian Fornelius
Tera Expert

Hi there,

 

this is a 2 part question.

1)

I have created a dashboard via the technical editor in platform analytics.  However, when creating a pivot table in UI Builder I see only 8 rows of data and a total of 14000.  there should be about 25 rows showing with a total of 43000.   If I click on the 14000 the report created gives me all 43000 rows.  so they data is there it's just not showing for some reason.  Am I missing a filter that says to only display 8 rows?

 

2) 

when creating a pivot table is there a way to get get these options at the top like you can when adding a list?  are you able to export a view of the pivot table or  do you always need to click into the list view before those options appear? 

Screenshot 2023-08-15 at 4.41.07 PM.png

Thanks,

--Brian

 

5 REPLIES 5

Hi Brian,

 

I am using just metric to display the count  and no option to select all rows.In my requirement I am fetching number of requests assigned to individual