Hello for the past month i have been trying to learn how to do dashboard, my knowledge has become better, but one thing im trying to do and enhance my report.
So, i have metrics around 7 of them and i have been trying to use a chart and using the Y axis as date and X axis as company (brand)
and using the metrics as lets say brand communication as the first metric.
i would like instead of putting 7 charts i would like to make it easier for the viewer to i put the metrics as selectable option and they can press the option they desire so they can see the change instead of bloating the dashboard.
The issue im facing is when put a dimension control or any type of control the chart will make the X axis as the first metric (brand communication) and would show metrics that are confusing and wrong for the purpose of the dashboard.
TLDR:Is it possible to create a single chart where clicking a metric changes the data entirely (different metrics), while keeping the X and Y axes the same?
I hope i made some sense.
LinkedIn
Twitter
