cancel
Showing results for 
Search instead for 
Did you mean: 

Analytics Stories

rodney_nadasen
Explorer
0 Kudos
466

Dear Team

I am working with the new functionality on Analytics Stories. We are trying to build a dashboard to show the Assigned Models for portfolio of skus? Example how many Skus have Constant model assigned to it? Is there a function to do a "count" ?

Thanks

Regards

Rodney

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi Rodney,

Create a new Analytics Story or open an existing one.

Add a visualization widget (such as a chart or table) to the story canvas.

In the data pane or data source for the widget, select the dataset that contains the SKU information and the assigned model.

Drag and drop the SKU dimension field into the Rows or X-axis area of the widget.

Drag and drop the Assigned Model dimension field into the Columns or Group by area of the widget.

Drag and drop the SKU dimension field again into the Values or Y-axis area of the widget.

By default, the aggregation method for the SKU field will be "Sum" or "Total." Change this aggregation method to "Count" to count the number of SKUs assigned to each model.

Customize the visualization settings as needed (e.g., chart type, labels, colors) to present the data in a meaningful way.

Preview or publish the Analytics Story to see the count of SKUs assigned to each model.

By using the "Count" aggregation function on the SKU dimension field, you can determine the number of SKUs associated with each assigned model in your dashboard.

I hope it helps.

Regards,

İbrahim

rodney_nadasen
Explorer
0 Kudos

Dear Ibrahim

Thanks for the feedback. I am very new to Analytics Stories and I am not sure where to find the aggregation method in order to change it. I attached the design builder options I see. Is it under the calculation options or filters? analytic-stories-calculation-measures.png analytic-stories-builder.png. I appreciate your feedback?

Thanks

Regards
Rodney