Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to aggregate the total value of the count result as below. but this is not happening
Sum(Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED}>} DISTINCT BILLTOCUSTEDP),OFFERNUM))
I am trying to aggregate the same offernumber
below is before aggregating:
below is after aggregating, the total should be 19 , but it still shows as 18
If(Len(Trim([FULLOFFERNAME])) > 0 or Dimensionality() = '6', Sum(TOTAL <OFFERNUM>Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED}
>} DISTINCT BILLTOCUSTEDP),OFFERNUM,FULLOFFERNAME)))
it is not aggregating as below
Do you mind sharing a sample of your app?
Preparing examples for Upload - Reduction and Data Scrambling
You can try this:
If(Len(Trim([FULLOFFERNAME])) > 0 or Dimensionality() <= 6, Sum(TOTAL <OFFERNUM>Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED}
>} DISTINCT BILLTOCUSTEDP),OFFERNUM,FULLOFFERNAME)))
or
If(Len(Trim([FULLOFFERNAME])) > 0 or Dimensionality() <= 5, Sum(TOTAL <OFFERNUM>Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED}
>} DISTINCT BILLTOCUSTEDP),OFFERNUM,FULLOFFERNAME)))
I have reduced the data and attached the app file to the original post.
Thanks a lot Sunny , I tried Dimensionalitiy() <=5 and also <=6 , but it didnot work.
This seems to be working, isn't it?
If(Len(Trim([FULLOFFERNAME])) > 0 or Dimensionality() <= 5, Sum(TOTAL <OFFERNUM>Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED},
ORDER_YEAR *= {">=$(vStartYear)"},
REPORTING_YEAR=,
REPORTING_MONTH =,
REPORTING_QUARTER=,
REPORTING_DAY=,
REPORTING_DATE=,
SHIP_YEAR=,
SHIP_MONTH=,
SHIP_QUARTER=,
SHIP_DAY=,
SHIPDATE=
>} DISTINCT BILLTOCUSTEDP),OFFERNUM,FULLOFFERNAME)))
Not sure, for some reason in my app its showing 0. please help me
Did you try to open the app I attached? you don't see 19 for total in that one also?
I opened the app you've attached, I think you have attached my original file. can you please post the correct one with your changes
Can you please attach your file changes.
I used the same , but still seeing 0
If(Len(Trim([FULLOFFERNAME])) > 0 or Dimensionality() <= 5, Sum(TOTAL <OFFERNUM>Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED},
ORDER_YEAR *= {">=$(vStartYear)"},
REPORTING_YEAR=,
REPORTING_MONTH =,
REPORTING_QUARTER=,
REPORTING_DAY=,
REPORTING_DATE=,
SHIP_YEAR=,
SHIP_MONTH=,
SHIP_QUARTER=,
SHIP_DAY=,
SHIPDATE=
>} DISTINCT BILLTOCUSTEDP),OFFERNUM,FULLOFFERNAME)))
In your app file I see Dimensionality()='6', and its not aggregating, and the total is 0
Attaching again