Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I've problem to show value data in 100% stacked bar
For example in my expression:
My dimension in chart is CountryField
and 2 expressions:
Expression 1: SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE))"}>}VALUE)/(SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE))"}>}VALUE)+SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE2))"}>}VALUE))
Expression 2: SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE2))"}>}VALUE)/(SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE))"}>}VALUE)+SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE2))"}>}VALUE))
And I want to show value of Expression 1 is
SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE))"}>}VALUE)
and value of Expression 2 is
SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE2))"}>}VALUE)
how I can change data value on my bar chart?
Thanks for your answer
SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE))"}>}VALUE)
May be use Dual function like this
Dual(Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE))"}>} VALUE), Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE))"}>} VALUE)/(Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE))"}>} VALUE) + Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE2))"}>} VALUE)))
Dual(Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE2))"}>} VALUE), Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE))"}>} VALUE)/(Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE))"}>} VALUE) + Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE2))"}>} VALUE)))
And select Expression Default on the number's tab for formatting and see if that works for you.
May be use Dual function like this
Dual(Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE))"}>} VALUE), Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE))"}>} VALUE)/(Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE))"}>} VALUE) + Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE2))"}>} VALUE)))
Dual(Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE2))"}>} VALUE), Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE))"}>} VALUE)/(Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE))"}>} VALUE) + Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE2))"}>} VALUE)))
And select Expression Default on the number's tab for formatting and see if that works for you.
Thanks Sunny, I forget to set expression default number.