Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Clusterd comun chart not showing correct data

Hello community,
I am posting an issue I've encountered while showing data coming from a Streaming dataset displayed in my Dashboard.
In the screenshot attached you can see how the highlighted date is not present in the posted data:

[
 {
"subscribed": 3,
"experimentName": "uniqueness_KxgcX",
"time": "2022-07-28T22:00:00.000Z"
 },
 {
"subscribed": 2,
"experimentName": "uniqueness_9ZVHo",
"time": "2022-07-28T22:00:00.000Z"
 },
 {
"subscribed": 1,
"experimentName": "uniqueness_VBeEk",
"time": "2022-07-28T22:00:00.000Z"
 },
 {
"subscribed": 2,
"experimentName": "uniqueness_VBeEk",
"time": "2022-09-16T22:00:00.000Z"
},
 {
"subscribed": 4,
"experimentName": "uniqueness_KxgcX",
"time": "2022-09-21T22:00:00.000Z"
 },
 {
"subscribed": 5,
"experimentName": "uniqueness_KxgcX",
"time": "2022-09-24T22:00:00.000Z"
 },
 {
"subscribed": 23,
"experimentName": "uniqueness_KxgcX",
"time": "2022-09-28T22:00:00.000Z"
 },
 {
"unsubscribed": "2",
"experimentName": "uniqueness_9ZVHo",
"time": "2022-09-28T22:00:00.000Z"
 },
 {
"subscribed": 23,
"experimentName": "uniqueness_VBeEk",
"time": "2022-09-28T22:00:00.000Z"
 },
 {
"subscribed": 23,
"experimentName": "uniqueness_9ZVHo",
"time": "2022-09-28T22:00:00.000Z"
 },
 {
"unsubscribed": "2",
"experimentName": "uniqueness_KxgcX",
"time": "2022-09-28T22:00:00.000Z"
 },
 {
"unsubscribed": "2",
"experimentName": "uniqueness_VBeEk",
"time": "2022-09-28T22:00:00.000Z"
 }
]
NOTE: we know there is an offset of 1 day but there is no mention of 24th.
 
Any suggestion are welcome,
thanks in advance!
 
 
Dashboard

6 Replies

  • please show the definition of your streaming dataset.  Are both "subscribed" and "unsubscribed" fields defined?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello lbendlin ,
    thanks for your reply.
    Yes, in the API definistion of my Streaming Dataset, both "subscribed" and "unsubscribed" fields defined, but only one at the time will be sent.
    Example:

    [
    {
    "subscribed": 23,
    "experimentName": "uniqueness_9ZVHo",
    "time": "2022-09-28T22:00:00.000Z"
     },
     {
    "unsubscribed": "2",
    "experimentName": "uniqueness_KxgcX",
    "time": "2022-09-28T22:00:00.000Z"
     },
    ...
    ]


    Here a screenshot on how my Streaming Dataset is configured:

    • lbendlin's avatar
      lbendlin
      Super User

      Keep in mind that the Power BI service runs on Zulu time (UTC) . Maybe your event got shifted to another day based on your viewer timezone.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hello lbendlin,
        I do not think that the timezone can be the cause in the issue I am describing because the difference in time between the data sent and the graph is of days.
        So, I am positive that the data above it's what I am sending to PowerBi but I am not able to see/debug what the Streaming Dataset is reiceving/interpreting. Do you know if there is a way to do that in PowerBi?