Calculate Row count metric based on teh dimensions

[Shraddha]

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

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

[Tracy Chow · Accepted solution]

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.

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

[Shraddha]

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]

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.

[Shraddha]

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.

Thanks

[Tracy Chow]

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.

[Shraddha]

Hi @Tracy Chow raised the support ticket with data access -

https://support.atlassian.com/requests/JST-940138/