BciCalendar dont work for multipe count

[erikzzy]

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!

[erikzzy · Accepted solution]

I found solution,

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

[v-shex-msft]

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

[RichardJ]

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

[erikzzy]

Thanks Richard. But it doesn't work.

[RichardJ]

Hi @erikzzy,

As @v-shex-msft 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