# Dashboard for outstanding tasks

**URL:** <https://forums.knack.com/t/dashboard-for-outstanding-tasks/8330>\
**Category:** Get Answers\
**Created:** [October 14, 2020, 12:37am UTC](https://forums.knack.com/t/dashboard-for-outstanding-tasks/8330 "2020-10-14T00:37:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![LukeWillia45739](https://avatars.discourse-cdn.com/v4/letter/l/b5a626/32.png) [@LukeWillia45739](https://forums.knack.com/u/LukeWillia45739)\
**Post date:** [October 14, 2020, 12:37am UTC](https://forums.knack.com/t/dashboard-for-outstanding-tasks/8330/1 "2020-10-14T00:37:28Z")

</div>

Hi,

We're currently creating a portal, and I'd like to have a dashboard type area, that displays outstanding tasks. This way, when a user logs in, they have an immediate overview of the required tasks for the day.

E.g.

Invoices requiring approval:&nbsp; 5

Opportunities needing action: 1

Sales to Prepare: 0

&nbsp;

But I'd like these to be clickable, so that when you click on the item, it takes you through to a table with these items shown.

Is there any functionality to do this?

---

<div class="post-metadata">

**Author:** ![LukeWillia45739](https://avatars.discourse-cdn.com/v4/letter/l/b5a626/32.png) [@LukeWillia45739](https://forums.knack.com/u/LukeWillia45739)\
**Post date:** [October 27, 2020, 4:41am UTC](https://forums.knack.com/t/dashboard-for-outstanding-tasks/8330/2 "2020-10-27T04:41:45Z")

</div>

Hi Julia,

I tried the Pivot table, but I'm try to show how many "Pending" user accounts there are for different User Roles.&nbsp; It won't let me filter on the user roles though.

Do you know how to do this for roles?

E.g. Pending User accounts:

- Operations: 5

- Finance: 2

- Etc.

&nbsp;

Thanks&nbsp;

Luke

---

<div class="post-metadata">

**Author:** ![LukeWillia45739](https://avatars.discourse-cdn.com/v4/letter/l/b5a626/32.png) [@LukeWillia45739](https://forums.knack.com/u/LukeWillia45739)\
**Post date:** [October 26, 2020, 12:54am UTC](https://forums.knack.com/t/dashboard-for-outstanding-tasks/8330/3 "2020-10-26T00:54:17Z")

</div>

Thanks Julia,

I'll give it a crack.&nbsp; I'm new to Knack, but already loving the features!

---

<div class="post-metadata">

**Author:** ![JuliaGlowa31189](https://avatars.discourse-cdn.com/v4/letter/j/53a042/32.png) [@JuliaGlowa31189](https://forums.knack.com/u/JuliaGlowa31189)\
**Post date:** [October 26, 2020, 12:52am UTC](https://forums.knack.com/t/dashboard-for-outstanding-tasks/8330/4 "2020-10-26T00:52:40Z")

</div>

Knack's pivot table report should give you what you want. It works similar to excel's pivot tables.

Good luck!