Hello! I have a bar chart in which I would like to add infornation on the number of rows present by category and ideally this would be in a for.at in which the label reads "Category (num of rows)". The problem is that I can't seem to find a way to introduce this info. I have created a calculated field to count the number of rows, but when I try to concat to the label name it says that it is not possible to join these two different types of variable. Also tried to add the number as a label, but can't find any oltion to peesonalize labels. ChatGPT was not helpful here, as most of what it says doesn't seem to be implementable for various reasons. Any idea on how could I attain this?
@HugoTorres if the goal is to make it dynamic ( for example adjust to filters) then at the moment you can only have numeric data labels.
If its a static need and bar wont move you can use a trick and add a Simple text above bars on your chart.
You can also try to toy with a combinations od text Field and scorecard or a 1 row table showing concatenated dimension and casted number to text. You can put it on top od the chart and it will look like a label. Unfortunately it wont change its position dynamically to changed height of the bar.
Also i ma bit confused about this need. The bar chart showing dimension name on the Axis and metric value as a label looks very good to me;)
The need for this comes from the fact that I cannot combine in the same visualization the average and the count of the same dimension, at least not when I want to break down the average by another category. So basically, my idea was to either try to combine the count with the label somehow, or display the count as a secondary label, if possible. I will try your suggestions and then come back at you
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |