Forum Discussion
Need help to implement a Chart
Hmm, seems like you need a hybrid of a clustered column chart and a stacked column chart. I would investigate third-party visuals perhaps. Actually, you might be able to do what you want with a Line and Clustered Column Chart. The line could add in the missing information.
Hello Greg,
Thank you for your prompt response.
Indeed, for the chart of my draft drawing, I looked quickly on the side of the 3 rd party, without really finding something that could match... If you have any suggestions ?
And for the second chart, the one with the red line that I added. I just thought of using a Line and Clustered Column Chart the problem is that I can't get the "Line Values" to be interpreted on the Level column for all the Type column.
When I try to put the "Level" column in "Line Values" an aggregate is done ... But also, the line that appear on the chart takes into account the group ThreatName and not the Type (C, I and A).We can clearly see in this screen that the line does not match in addition to being an calculate as an aggregate.
Thx again.
Regards.
Also here is additional information to help you better understand the data. I tried to represent the notion of Level (High, Medium and Low) in the LevelValue column which has the values 33 for Low, 66 for Medium and 100 for High. In order to try to place the points of the line in the right place in relation to the Y axis.
Hi again,
Any ideas, Any help on this ?...
I still don't have any solutions to do this chart. Maybe you have suggestion on how display data differently to have the same goal, or to change the data itself, ...
Thx again for your time !
Regards,
