topic Re: Combo bar chart with sales and previous month sales in App Development

Combo bar chart with sales and previous month sales

tiger_01 — Wed, 13 Feb 2019 16:35:19 GMT

Hi,

I'm trying to make a combo bar chart with month as dimension, and two measures, sales and sales of previous month (two sub-bar in each bar).

I obtained it using SUM(SALES) as first measure and ABOVE(SUM(SALES),1) as second measure.

The problem is that the second measure is wrong, because if I select 2018, at January 2018 I'm not able to see Sales of December 2017, but I see value '0'.

How can I resolve it?

Thanks, David

Re: Combo bar chart with sales and previous month sales

sunny_talwar — Wed, 13 Feb 2019 16:38:42 GMT

When you say Month is a dimension, is just Jan, Feb or does it say Jan-2018, Feb-2018? Essentially, does your Month field a Month only field or MonthYear field?

Re: Combo bar chart with sales and previous month sales

tiger_01 — Wed, 13 Feb 2019 16:40:56 GMT

I've got date field. so i've made Month dimension with Monthname(date)

Re: Combo bar chart with sales and previous month sales

sunny_talwar — Wed, 13 Feb 2019 16:42:47 GMT

Try this and see if this works

Aggr(Above(Sum({<Month>} SALES), 1), (Month, (NUMERIC)))

Re: Combo bar chart with sales and previous month sales

tiger_01 — Wed, 13 Feb 2019 16:48:41 GMT

Thanks, it works in general chart, but if I select in a filter panel Year=2018, Sales of previous month (december 2017) become zero, whereas before of do selection they had a value.

Re: Combo bar chart with sales and previous month sales

sunny_talwar — Wed, 13 Feb 2019 17:14:00 GMT

Ignore selection of Year as well

Aggr(Above(Sum({<Month, Year>} SALES), 1), (Month, (NUMERIC)))

Re: Combo bar chart with sales and previous month sales

tiger_01 — Wed, 13 Feb 2019 18:28:37 GMT

Thanks man, you are great!