Discrepancy in results of cutom chart and USQL queries

[Anish]

My dashboard has few custom chart tiles which displays the no. of key user actions that have been performed over  a period of time .
Our is  a payment application so actions include
1:Loading of Home Page
2:Loading of Create Payment Page
3:Create Quote (custom action)
4:Create Payment (custom action)

I was trying to display the same details via a funnel chart using USQL.
But when I am comparing both the results over same time frame  there seems to be some discrepancy

The no of actions on tiles are mostly higher(and accurate when verified with the backend) than that displayed via the USQL query

Any specific reason for this?

[AntonioSousa]

There might be some reasons for that. One that typically applies is if you are in a timeframe where you have live sessions. Those are not visible in USQL results...

[Anish]

Thanks @Antonio

But even if I apply historical time frame there is a gap 

[Babar_Qayyum]

Hello @Anish 

Did you resolve/understand the situation behind this discrepancy?

Regards,

Babar

[PacoPorro]

USQL and Data Explorer use different data-sources. So some inconsistency is possible we can see such situation from time to time

USQL shows only completed user sessions. Data Explorer - I am not sure at 100%, but I think it shows live sessions too. So another possible reason why some inconsistency is happening.

[Babar_Qayyum]

Hello @PacoPorro 

Thank you for your comments.

Yes, we know about this, but how much inconsistency can we expect?

Also, another challenge is the count difference between the key user actions and service side requests.

Regards,

Babar