Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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) | AB | B-C | AB/(B-C) | |||||||
---|---|---|---|---|---|---|---|---|---|---|
Q8 | ||||||||||
Q7 | ||||||||||
Q6 | ||||||||||
Q5 | ||||||||||
Q4 | ||||||||||
Q3 | ||||||||||
Q2 | ||||||||||
Q1 |
Now i need to display my table in this format:
Metrics | Q8 | Q7 | Q6 | Q5 | Q4 | Q3 | Q2 | Q1 | Sparkline | |
---|---|---|---|---|---|---|---|---|---|---|
AB | ||||||||||
B-C | ||||||||||
AB/(B-C) | ||||||||||
I have attached a sample file.
Please let me know if anyone has any idea.
Regards
Sagar Gupta
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.
how many Quarter have you got? only this 8 or it should be automatic? (automatic will be more difficult)
Hi Pari,
I only have 8 Quarters
Q1
Q2
Q3
Q4
Q5
Q6
Q7
Q8
Regards
Sagar Gupta
as far as i'm concerned ...
there is no other option than :
- Q1, Q2,......Q8 must be expressions
and metrics should be dimensions