Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
my requiremnt is to show % of each decision filed value of same supplier ,to achieve this in a bar chart
i took dimension: 1)name1 //(supplier name filed)
2)decision //(accepted,rejected,exception)
and expression i wrote is:
count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} PRUEFLOS)
/count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} Total <name1> PRUEFLOS)
so problem is while i am showing all the supplier i am getting different values
but if i choose one supplier then i am able to get what i am looking
this is what i am looking ,so i think i need to do a changes in my expression ,any one suggest me what changes should i need to do plz
if i am right ,this expression is getting percentage
Num(count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} PRUEFLOS)
/count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} Total <name1> PRUEFLOS) * Avg(1) * 100, '##.##% (')
this one is getting value...... right
Num(count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} PRUEFLOS) * Avg(1), '##)'),
count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} PRUEFLOS)
/count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} Total <name1> PRUEFLOS) * Avg(1))
Percentage for display:
Num(count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} PRUEFLOS)
/count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} Total <name1> PRUEFLOS) * Avg(100), '##.##% (')
Value for display:
Num(count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} PRUEFLOS) * Avg(1), '##)')
Percentage for plotting the chart:
count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} PRUEFLOS)
/count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} Total <name1> PRUEFLOS) * Avg(1)
The display and calculations are combined together using the Dual function
you believe r not i am trying to replay the brackets to % instead of values from last 15 min and i am still not succeed
You want to show like this -> 32 (94%)
ya
Try this:
Dual(Num(count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} PRUEFLOS) * Avg(1), '## (') &
Num(count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} PRUEFLOS)
/count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} Total <name1> PRUEFLOS) * Avg(100), '##.##%)'),
count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} PRUEFLOS)
/count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} Total <name1> PRUEFLOS) * Avg(1))
Everything is resolved, right? This came up through moderation now?
yes , everything is resolved