Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear experts,
I am trying to create a bar chart with 2 dimensions, however I am ending up with duplicate values,
the expressions are as follows:
Bar chart .. Sum(cash)
line graph .. Sum({$<BDF_Type={"*profit*"}, YEAR = {'2015'} >} cash) / Sum({$<BDF_Type={"*revenue*"}, YEAR = {'2015'} >} cash)
I have attached screen shot for your reference.
Kind regards,
Royce
did you tried to check the supress null values in dimension tab?
HI,
instead you can go for a single dimension MonthYear like 2015-Jan, 2015-Feb etc.
Ex: MonthName(date-Field)
Yes I have, and it does not seem to work !
in screen shot its not there ..same do in presentation tab
It seems to be showing the value for every month, is there a way to code the expression in a way that it only selects the year and not the month ?
tried it out and it does not seem to work as well
I have just changed it, and it still does nothing, the same chart comes up
try to remove YEAR filter from your second expression. so that the amount will be divided based on specified time dimension values.
Sum({$<BDF_Type={"*profit*"} >} cash) / Sum({$<BDF_Type={"*revenue*"}>} cash)
try below expression for bar
=sum(Distinct Cash)