You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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
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)
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
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.
Please let me know if you have further questions or if I can clarify anything.
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.
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.