nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculate Row count metric based on teh dimensions

Shraddha_3rzhr3

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

Accepted answers

Tracy Chow_f2gtzj

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.

All comments

Tracy Chow_f2gtzj

Hi Shraddha,

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.

Shraddha_3rzhr3

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_f2gtzj

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_3rzhr3

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

analytics