4 Replies Latest reply: Aug 7, 2012 7:43 AM by Wojciech Parzyszek

# COULDN'T SOLVE THIS FROM PAST 1 WEEK : How to make a straight table with sparkline when more than one calculated metrics are present?

Hi All,

I want sparkline representation in my straight table, plz let me know if it is possible when 3 different calculated metrices(AB, B-C, AB/(B-C)) are present.

Quarter(Dimenssion)ABB-CAB/(B-C)
Q8
Q7
Q6
Q5
Q4
Q3
Q2
Q1

Now i need to display my table in this format:

MetricsQ8Q7Q6Q5Q4Q3Q2Q1Sparkline
AB
B-C
AB/(B-C)

I have attached a sample file.

Please let me know if anyone has any idea.

Regards

Sagar Gupta

• ###### Re: COULDN'T SOLVE THIS FROM PAST 1 WEEK : How to make a straight table with sparkline when more than one calculated metrics are present?

Sagar

Mini-charts do not like expressions that reference other expressions. Re-do your mini-chart expression using only field names and it should work.

• ###### Re: COULDN'T SOLVE THIS FROM PAST 1 WEEK : How to make a straight table with sparkline when more than one calculated metrics are present?

how many Quarter have you got? only this 8 or it should be automatic? (automatic will be more difficult)

• ###### Re: COULDN'T SOLVE THIS FROM PAST 1 WEEK : How to make a straight table with sparkline when more than one calculated metrics are present?

Hi Pari,

I only have 8 Quarters

Q1

Q2

Q3

Q4

Q5

Q6

Q7

Q8

Regards

Sagar Gupta

• ###### Re: COULDN'T SOLVE THIS FROM PAST 1 WEEK : How to make a straight table with sparkline when more than one calculated metrics are present?

as far as i'm concerned ...

there is no other option than :

- Q1, Q2,......Q8 must be expressions

and metrics should be dimensions