I currently have a multi select drop down that allows you to filter by category.
I also have a table that displays the category, category value and count with aggregation for count set as SUM- which gives me the rolled up sum for each category; so hair_products sum=550, etc.
I want a drop down using the Count field in my dataset but I don’t want it to give me the individual count break downs, which it currently displays. I want it to display the sum of that category.
hello @huda.h.yazgi hope this message finds you well!
my suggestion in this case is utilise the functionality of parameters and controls to create a dropdown that displays the total sum for each category, rather than showing individual count breakdowns. Something like this step by step:
Create a Parameter:
Create a new parameter, for instance, CategorySum.
Set the data type to Integer or Decimal, depending on the data type of your count field.
Create a Control for the Parameter:
Go to the controls section.
Add a new control and link it to the CategorySum parameter.
Select the control type as Dropdown.
Configure the Control to Display the Sum:
In the control settings, configure the list of values to be populated by an aggregation.
Use an aggregation function such as sum to calculate the total sum of count values for each category.
Ensure the control is set to display only the aggregated values.
Apply the Filter to the Visualisation:
Apply a filter to your table visualisation using the CategorySum parameter.
Configure the filter to use the calculated sum as the filtering criterion.
This way, the dropdown will display the total sum for each category, and you will be able to filter the table based on these aggregated values. Please tell me if it works!
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
