Unable to select array items from a Mongodb collection through ODBC BI connector in Power Query.
Hi, everyone. I am facing issues in PowerQuery while selecting/querying array items from the https://studio3t.com/knowledge-base/articles/sql-query/#querying-arrays link. I have a collection below, want to select the array elements in my power query. Please let me know if I missed anything. Below are the errors I am getting: Please help!Getting the wait time between times in different status and ids in the same column
Hey!! How're you doing? I'm creating a BI to analise some stuff, but i'm having some issues manipulating time values. The data was gettered from mongoDB in a connection with R and, with that all the data came in one, i mean, all de status and its updates came with it's respective time, so i can't calculate between columns for, as all the datatimes lies on the same column, and the power bi won't let me use simple "Datediff" ou calculate just with the column, when it asks for a previews operation like max('status'[datetime]), what i think would just give me the last data. My objective is to adquire the time beetween a change of status for each id on the table, or at least it's maximum and it's mean values. Here's a exemple of what i'm talking about: Id Status Datetime 5ff34563ebaa650023799723 ENTER_QUEUE 04-01-2021 16:42:11 5ff34566ebaa650023799725 IN_ATTEND 04-01-2021 16:42:14 5ff3457bebaa65002379972a FINISH_ATTEND 04-01-2021 16:42:36 5ff3456eebaa650023799727 ENTER_QUEUE 04-01-2021 16:42:23 I've tried to do many thing with that but it's getting weird to do, like i did a table for each status and then merged it's times to compare, and it's the closest I got to what I need. Sorry if it's too basic or not a proper topic to discuss, but i'm kind of new on power bi.
