Solved

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

  • 21 June 2022
  • 4 replies
  • 104 views

Userlevel 3
Badge +8

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

icon

Best answer by francois 1 July 2022, 18:21

View original

4 replies

Userlevel 6
Badge +14

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.

 

Userlevel 3
Badge +8

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.

Userlevel 6
Badge +14

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?

Userlevel 3
Badge +8

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?

Reply