on 11-22-2016 2:55 PM
Hi ,
I need to show my report in the following format
Measure1 Name - Measure1 Actuals - Measure1 Target - Sparkline for Fiscal Year
Measure2 Name - Measure2 Actuals - Measure2 Target - Sparkline for Fiscal Year
.
.
.
Measure14 Name - Measure14 Actuals - Measure14 Target - Sparkline for Fiscal Year
I am trying to convert month level data for an yera into spark line but i get sum(totals) at right extreme and another issue is its not one measure in a row completely so converting row data in spark line using ;SL_L_C_[start Column]_[end column} will not let me compare the trend of actual and target
can anyone suggest possible ways to acheive this in web intelligence
Are chance to convert it into a vertical table instead of crosstab? You would need to create 12 variables for each month, but sparkline rendering should get more straightforward.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mahboob mohammed,
i cant give a sample data immediately but i can tell you how it should look in crosstab or any other tables in web intelligence
i have 12-14 measures
In the structure i gave measure actual and measure target are two different measures . Like if volume of goods is considered Actuals give goods sold in a perticular period and target gives the expected value to be sold
c1- c2- c3- c4
Volume c2:Actual 100Tons(in current year) C3:Target 110 Tons C$:sparkline or anything representing its value trend over 12 months in that year
c1,c2,c3,c4 are four columns in which i want data in above format
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Naveen,
Some sample data and/or snapshot of how it looks in a chart can help us to help you better.
Thanks,
Mahboob Mohammed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.