Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Guys, good afternoon, I'd like to know how you can help me.
I have the following table:
I need to create a Line chart for each REGIONAL where only the last photo of each month is always counted
In this way, I inserted the following specifications in the chart:
Dimension: DTFOTO
Expression: SUM({$<REGIONAL={'A'}>} PEND_TOTAL) / SUM({$<REGIONAL={'A'}>} CART_TOTAL)
With the above expression, I get the percentage calculation of all the photos, however I need the chart to only count the last photo of each month (11/30/2016 and 12/30/2016)
Can you help me?
=SUM(Aggr(FirstSortedValue({<REGIONAL = {'A'}>}PEND_TOTAL,-DTFOTO),MESFOTO,ANOFOTO))/
SUM(Aggr(FirstSortedValue({<REGIONAL = {'A'}>}CART_TOTAL,-DTFOTO),MESFOTO,ANOFOTO))
what could be the end result looks like?
Can you provide here?
May be this:
SUM({$<REGIONAL={'A'}>} Aggr(If(Only({$<REGIONAL={'A'}>} DTFOTO) = Max({$<REGIONAL={'A'}>} TOTAL <MESFOTO, ANOFOTO> DTFOTO), PEND_TOTAL), DTFOTO, MESFOTO, ANOFOTO)) / SUM({$<REGIONAL={'A'}>} Aggr(If(Only({$<REGIONAL={'A'}>} DTFOTO) = Max({$<REGIONAL={'A'}>} TOTAL <MESFOTO, ANOFOTO> DTFOTO), CART_TOTAL), DTFOTO, MESFOTO, ANOFOTO))
=SUM(Aggr(FirstSortedValue({<REGIONAL = {'A'}>}PEND_TOTAL,-DTFOTO),MESFOTO,ANOFOTO))/
SUM(Aggr(FirstSortedValue({<REGIONAL = {'A'}>}CART_TOTAL,-DTFOTO),MESFOTO,ANOFOTO))
I think it might not work because there are more than 1 DTFOTO for a combination of MESFOTO and ANOFOTO. FirstSortedValue will have trouble showing a single value here
Thanks guys, I worked with the received guidance