Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Calculate Row count metric based on teh dimensions

Hello Team,

I build a report based out of Assets metadata in the schema. Since the columns are pivoted meaning they are attribute values for a column "Name" i am unable to develop an aggregate formula based on the logical grouping.

See the attached report screenshot

Screen Shot 2023-11-15 at 4.13.33 PM.png


I want something like this where the Hardware Name(assets) are grouped by Hardware Type, Status and Stockroom. (PDX is the Stockroom example value and In Stock : New is the status and the associated count)


Screen Shot 2023-11-15 at 4.15.19 PM.png

Also how to further add controls for "Stockroom"  and " Status" in the dashboard given these columns are attribute values.

Looking forward to the support help. Thanks

1 answer

0 votes
Tracy Chow
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Nov 16, 2023

Hi Shraddha,

If you would like to group by Stockroom, you can add a "Group & Aggregate" step and do a "Count of unique" aggregation for the Stockroom column. Can you give that a try and see if it generates what you're looking for?

Secondly, to add a control for an attribute value, you can add a dropdown control and select Switch to control editor to further customize the control.

From there, you can add the "Attribute value string" column to get the attribute values and then add the "Name" column from the "Assets type attribute metadata" table to filter it by attribute name.

Screenshot 2023-11-16 at 5.30.06 PM.png

Please let me know if you have further questions or if I can clarify anything.

Thanks @Tracy Chow 

How does the controls(filter) associate with the chart. They seem to be created separately as in when dropdown values are selected that filter value does not reflect in chart.

I am curious how to pass filter(dropdown) value for a attribute value string?

Tracy Chow
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Nov 22, 2023

Yes, a control needs to be connected to your chart in order for it to filter according to the control selection. This article walks through some examples of connecting a "Dropdown" control to charts.

You can either add a filter in the Filters section of your visual mode query, or add a "Filter" step after your query to filter it by the control.

Feel free to open a support ticket with us to look at your chart together or schedule a call if desired.

Hi @Tracy Chow 

Thank you for the information.

My issue with having control filter connect to a chart is that , I have attribute value string pivoted as columns in the chart.

To be able to connect control filters in charts those need to be real columns in the schema.

I could not find document and help in the community for that case. How can i get further assistance.


Tracy Chow
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Nov 27, 2023

Hi @Shraddha, thanks for the clarification. Do you mind opening a support ticket (selecting "Atlassian Analytics" as the product) and granting data access so I can look at your dashboard further? 

I believe it's possible to achieve what you're looking for, but without seeing how your chart and controls are set up, it's difficult for me to recommend a solution.

Happy to schedule a call as well so we can look at it together.

Like Tracy Chow likes this

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events