Skip to main content
Solved

Can we create charts for Tables with different Metrics as Series of the chart?

  • June 21, 2022
  • 4 replies
  • 184 views

Forum|alt.badge.img+7

Can we create charts for Tables with different Metrics as Series of the chart?

Best answer by francois

Sure @Dastan !

Here’s what I’ve done with two simple metrics (one dimension), with the metrics in rows and the other dimension as columns.

 

4 replies

francois
Employee
Forum|alt.badge.img+13
  • Employee
  • 171 replies
  • Answer
  • July 1, 2022

Sure @Dastan !

Here’s what I’ve done with two simple metrics (one dimension), with the metrics in rows and the other dimension as columns.

 


Forum|alt.badge.img+7
  • Author
  • Master Author
  • 19 replies
  • July 1, 2022

Hi Francois,

 

Thanks for showing the example. This is exactly what I want to achieve, but, in my table, whenever I switch from Grid to Chart, it automatically selecting only the first metric in the table (Revenue), and I cannot see the option to add other metrics to the chart.


francois
Employee
Forum|alt.badge.img+13
  • Employee
  • 171 replies
  • July 2, 2022

In that case you probably have something more complicated than two metrics?
First checks I’d do:

  • make sure both are metric (maybe one is a Show Value As?)
  • prepare your grid so that it’s only in 2D (so metrics in rows, and one dimension in columns)

If it still doesn’t work, could you maybe attach a screenshot of your configure panel?


Forum|alt.badge.img+7
  • Author
  • Master Author
  • 19 replies
  • July 4, 2022

Yes, I had several metrics and duplicated some and showed them as. I tried to do it with two metrics only, and now it works the way I wanted.

So, is this limited only with 2 metrics at a time, or as many metrics as possible, as long as the formatting is the same?