Forum Discussion

erikzzy's avatar
erikzzy
Icon for Helper II rankHelper II
6 years ago
Solved

BciCalendar dont work for multipe count

Hello everyone,

 

I use this plug-in for visualization the calendar. I have a date field named "duplicate creatAt" with format date, another column named "id". 

I want to have the total of ID per date. But it does't work. I cant understand why this is "no Data". 

 

You can find more details in my printscreens. Thanks a lot!

Need Help
  • erikzzy's avatar
    erikzzy
    6 years ago

    I found solution,

     

    Use datavalue( ) to  change createdAt data type. And then, all is correct. 

5 Replies

  • erikzzy's avatar
    erikzzy
    Icon for Helper II rankHelper II
    6 years ago

    I found solution,

     

    Use datavalue( ) to  change createdAt data type. And then, all is correct. 

  • RichardJ's avatar
    RichardJ
    Icon for Responsive Resident rankResponsive Resident
    6 years ago

    Hi erikzzy,

    As a workaround, would it be possible to count the "duplicate creatAt" values instead of the ID's to see if that works?

     

    If that's not feasible can you try this to see if there is a problem with the data (or the visual being used)

    When you create a Matrix visual and add the columns

    "duplicate creatAt"

    then

    "ID"

    does the sum of the ID's show as expected in the matrix visual?

    Cheers,

    Richard

      • RichardJ's avatar
        RichardJ
        Icon for Responsive Resident rankResponsive Resident
        6 years ago

        Hi erikzzy,

        As Anonymous was suggesting it looks like there is an issue with the third party visual being used.

        It would be best to contact the provider of the third party visual in this case.

        Sorry I couldn't be of more help with this one.

        Cheers,

        Richard

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI erikzzy,

    It seems like you are work with third party custom visuals and faced the aggregate calculation issue.
    Since we not so clear for the backend calculate logics, I'd like to suggest you contact the visual author to report and confirm if any issue during these calculations.

    Regards,

    Xiaoxin Sheng