Skip to Content
avatar image
Former Member

Bex Query Aggregation

Hi Team,

I have date key figure shown as below

capture.jpg

and I created report but this date field is giving results with summing( Please check Last field).I tried Exception aggragation but not worked.Could you any one please help on Exception aggregation.

sc.png

Thanks and regards,

Uma

capture.jpg (59.3 kB)
sc.png (64.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Mar 07, 2017 at 09:26 AM

    Hi team,

    I tried all exception aggregaations but still I am getting data with aggregating values.Any suggestion.

    Thanks and Regards,

    Uma

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 07, 2017 at 09:26 AM

    Hi team,

    I tried all exception aggregaations but still I am getting data with aggregating values.Any suggestion.

    Thanks and Regards,

    Uma

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 09, 2017 at 02:09 AM

    Hi,

    Can you explain it more? Why did you use a KF with DATE option? What do you want to do? Can you check the AGGREGATION tab in your CAPTURE.JPG if the option is SUMMATION? Then you may replace it with the option you wanted.

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 09, 2017 at 01:56 PM

    Hi Uma,

    what is the most detailed char for your date?

    did you define exception aggregation in query or in backend?

    please post picture of the exception aggregation that you tried...

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded