Pivot tables in advanced Analytics

[Brian Fornelius]

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? 

Thanks,

--Brian

[Revathi15]

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