topic Re: Bar Chart don't show proper graph in App Development

Bar Chart don't show proper graph

madnanansari — Wed, 29 Aug 2018 08:52:33 GMT

I have created a bar chart with the value list:

ValueList('CY', 'LY')

where CY stands for Current Year and LY stands for Last Year.

for values the below formula is used:

if(ValueList('CY', 'LY')='CY',

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesYTD)),0),[Unit Key])),

if(ValueList('CY', 'LY')='LY',

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesLYYTD)),0),[Unit Key]))

)

where vSalesLY is:

Sum({$<[Year] = {"$(=Year(Today())-1)"} >} [Sales])

and vSalesCY is:

Sum({$<[Year] = {"$(=Year(Today()))"} >} [Sales])

The graph is not showing properly. The first bar shows the rights size and figures but for the second bar it just shows zero.

If I switch the values for CY and LY; again the first bar shows the right values whereas the second bar is zero.

Re: Bar Chart don't show proper graph

shraddha_g — Wed, 29 Aug 2018 08:56:30 GMT

try This:

Pick(Wildmatch(ValueList('CY', 'LY'),'CY','LY'),

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesYTD)),0),[Unit Key])),

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesLYYTD)),0),[Unit Key]))

)

Re: Bar Chart don't show proper graph

shraddha_g — Wed, 29 Aug 2018 08:57:03 GMT

if(Wildmatch(ValueList('CY', 'LY'),'CY'),

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesYTD)),0),[Unit Key])),

if(Wildmatch(ValueList('CY', 'LY'),'LY'),

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesLYYTD)),0),[Unit Key]))

)

Re: Bar Chart don't show proper graph

madnanansari — Wed, 29 Aug 2018 09:13:37 GMT

it brings the same result as before

Re: Bar Chart don't show proper graph

madnanansari — Wed, 29 Aug 2018 09:14:52 GMT

it brings the same result as before. Even if I put the same :

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesYTD)),0),[Unit Key]))

for both CY and LY, the second bar is zero.

Re: Bar Chart don't show proper graph

shraddha_g — Wed, 29 Aug 2018 09:19:35 GMT

What does these expression do?

why you are not using

vSalesLY:

Sum({$<[Year] = {"$(=Year(Today())-1)"} >} [Sales])

and vSalesCY:

Sum({$<[Year] = {"$(=Year(Today()))"} >} [Sales])

Re: Bar Chart don't show proper graph

madnanansari — Wed, 29 Aug 2018 09:27:48 GMT

If I directly use these statements then the graph shows the right values.

The below statement actually covers a business requirement where we need to show CY Total and LY Total only for those stores (Unit Key) where there is sales in the current year as well as last year. It skip those stores where either last year or the current year sales dont exists.

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesYTD)),0),[Unit Key]))

Re: Bar Chart don't show proper graph

shraddha_g — Wed, 29 Aug 2018 09:36:44 GMT

Does this expression work in KPI object?

Re: Bar Chart don't show proper graph

madnanansari — Wed, 29 Aug 2018 10:02:08 GMT

Yes this works in KPI object. both of them.

Re: Bar Chart don't show proper graph

shraddha_g — Wed, 29 Aug 2018 10:04:23 GMT

what are the other dimensions you have in chart?

Re: Bar Chart don't show proper graph

madnanansari — Wed, 29 Aug 2018 10:07:03 GMT

there are no dimensions. Its a value list.