Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dynamic Legends in Line chart

In my table I have Group, Subgroup, SubSubGroup, Date and Values
When doing a line chart (X = Date, Y = Values) I set as legend the Groups column and it displays X lines according the number of groups, but when filtering wether Group, Subgroup or SubSubGroup it shows me only one line.
So the question is, is it possible to change the Legend so when I apply the filters it shows me the same amount of lines of the corresponding subgroups... 
Ex:

-When I dont apply Group filter, it shows the same number of lines than the amount of Groups

-When I apply a Group filter, it shows the same number of lines as the amount of Subgroups within the Group selected
-When I apply a Subgroup, filter it shows the same number of lines as the amount of SubSubGroups within the Subgroup selected.

 

Thanks in advance!