topic Re: Agregation Bar chart by period in App Development

Agregation Bar chart by period

EJeronimo — Tue, 08 Aug 2023 17:52:19 GMT

I'd like to create a bar chart by period as a example below using the agregation function, but is not working as i need.

I need to count the "ITEM", "DATE" and the "MaxString(STATUS)" OR "ITEM", "Max(DATE)" and "STATUS"

in this example below the correct information for March should be 02 Status "STEP 5":

CPPRAA163762 - 08/Mar/2023 - STEP 5

CPPRAA164308 - 31/Mar/2023 - STEP5

Re: Agregation Bar chart by period

BrunPierre — Tue, 08 Aug 2023 19:15:53 GMT

Like this I presume.

=Count(DISTINCT Aggr(If(MaxString(TOTAL <ITEM> DATE) = DATE, ITEM), ITEM, DATE, STATUS))

Re: Agregation Bar chart by period

EJeronimo — Tue, 08 Aug 2023 20:37:31 GMT

Hi @BrunPierre ,

It's working fine in March period but disapear the Feb bar period.

The qty should be:

Feb/2023: 2 (STEP 1 - 4)

Mar/2023: 2 (STEP 5) - correct your sugestion

Re: Agregation Bar chart by period

BrunPierre — Tue, 08 Aug 2023 20:50:22 GMT

=Count(DISTINCT Aggr(If(MaxString(TOTAL <ITEM, [Month/Year]> DATE) = DATE, ITEM), ITEM, DATE, STATUS, [Month/Year]))

Re: Agregation Bar chart by period

EJeronimo — Wed, 09 Aug 2023 12:44:10 GMT

Hi @BrunPierre

unfortunally doenst work as should be when grouped by period, only work fine with "DATE" with a format ("dd/mmm/yyyy") but the users decide / Select what format in X axle want to work.

- If the user want to see the X axle by month, the dimension is: Date#(Date(DATE,'MMM/YYYY'),'MMM/YYYY')

- If the user want to see the X axle by week, the dimension is: WeekName(DATE)

- If the user want to see the X axle by Year, the dimension is: Date#(Date(DAT_DATE,'YYYY'),'YYYY')

in this case the chart doesn't work, the chart only see the Max date