# My Unfinished Dashboard

**URL:** <https://forums.knack.com/t/my-unfinished-dashboard/19124>\
**Category:** Show & Tell\
**Created:** [April 4, 2025, 5:20pm UTC](https://forums.knack.com/t/my-unfinished-dashboard/19124 "2025-04-04T17:20:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![JAINI](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/jaini/32/4803_2.png) [@JAINI](https://forums.knack.com/u/JAINI)\
**Post date:** [April 4, 2025, 5:20pm UTC](https://forums.knack.com/t/my-unfinished-dashboard/19124/1 "2025-04-04T17:20:47Z")

</div>

![Screenshot 2025-04-04 121618](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/4/42ec8b37e3da4e59e38cebc78c2b87ef36ffe945.png)

updated to :

 ![Dashboard One](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/b/bda8060f97b0b24fd667624fa6a102245d00a03d.png)

---

<div class="post-metadata">

**Author:** ![Quynh-Tram](https://avatars.discourse-cdn.com/v4/letter/q/e9c0ed/32.png) [@Quynh-Tram](https://forums.knack.com/u/Quynh-Tram)\
**Post date:** [April 14, 2025, 2:17pm UTC](https://forums.knack.com/t/my-unfinished-dashboard/19124/2 "2025-04-14T14:17:20Z")

</div>

That’s pretty neat! How did you do the card views in white, green, red, blue, and yellow, to show one aggregated value?

---

<div class="post-metadata">

**Author:** ![JAINI](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/jaini/32/4803_2.png) [@JAINI](https://forums.knack.com/u/JAINI)\
**Post date:** [April 17, 2025, 3:18pm UTC](https://forums.knack.com/t/my-unfinished-dashboard/19124/3 "2025-04-17T15:18:16Z")

</div>

To implement the desired changes, target the specific view using its unique ID selector (e.g., `#view_xxx`) and apply the appropriate background color styling. Additionally, adjust the Flexbox direction for the inner columns as needed to achieve the desired layout. Aggregated values can be retrieved using a count function formula applied to the “Account User” field, assuming each user is properly linked to the relevant data table.

```auto
/* Targeting the specific view and applying background color */
#view_xxx {
  background-color: #f5f5f5; /* Replace with your desired color */
  padding: 20px;
  border-radius: 8px;
}

/* Modifying the direction of inner columns using Flexbox */
div#view_xxx {
  display: flex;
  flex-direction: column; /* Use 'row' or 'row-reverse' as needed */
  gap: 16px;
}

```

Aggregated Value Calculation:

To extract an aggregated count, apply a `count()` function to the **Account User** field. Ensure each user is correctly linked to your primary data table for accurate results.

Example:  
`count(Account User)` – This returns the number of linked users per record or view grouping.