Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Can any one please help me on below requirement.
I have a requirement to show max of month to last 6 months Trends in a Bar chart with Single Measure.
I have Taken
Dimension 1 : =If(MonthDiff<7,[Year-Month],null())
Dimension 2: Flag (Yes/No)
Measure : Sum(Trades)
By these getting the bar chart like below.Here need to add one Average Bar which shows last six months avg without considering the current month
Avg calculation highlighted in yellow
Please help me on this.
Thanks in advance.
Hi @sunny_talwar , @tresesco , @swuehl
could you please help me on above requirement.
Would you be able to provide a sample application where you are trying to do this?
Sorry I cant share the application due to Confidential data.
oh okay... I am sure somebody might be able to help.