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
Try this expression:
count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} PRUEFLOS)
/count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}, Decision>} Total <name1> PRUEFLOS) * Avg(1)
can you try this
count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} PRUEFLOS)
/sum(aggr(count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} PRUEFLOS),name1))
No luck,its not working
try to add decision as well in expression
count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} PRUEFLOS)
/sum(aggr(count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} PRUEFLOS),name1, decision)
i did add Decision ,but it says NO DATA TO DISPLAY
count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} PRUEFLOS)
/sum(aggr(count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} PRUEFLOS),name1, Decision)
Any helps or suggestion to achieve this task plz
can try this or post the sample application so you will get the quicker answer
count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} PRUEFLOS)
/count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} Total <name1,decision> PRUEFLOS)
yes i will try to post my sample application,but it is about 13mb so plz gives me few time to upload it
Would you be able to share your application?
Hello plx find the attachment