Why does Kusto | render timepivot bin to a single data point?

Kovács, Ferenc 61 Reputation points
2022-01-20T10:53:52.613+00:00

I am having trouble figuring out exactly how the timepivot from Kusto.Explorer splits horizontally the data slices.
Created a demo query to illustrate the question:

range dt from startofday(ago(25d)) to startofday(ago(1d)) step 1d
| extend fx = case (rand() > 0.5, "Heads", "Tails")
| render timepivot

If I start from 25 days ago, I get >50 bins on X axis (which I want and always expect), but if I increase it to 26 or more days ago, the horizontal axis collapses always to a single bin for all data.
How can I control this so it does not collapse everything into a single cell?
I expect that the number of bins have a monitor size/screen resolution dependent constant value (how many fit on the screen) and the input time range is split into that many equal intervals.
See screenshots:

166811-timepivot1bin.png166763-timepivot50plusbins.png

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
577 questions
{count} votes

Accepted answer
  1. HimanshuSinha-msft 19,491 Reputation points Microsoft Employee Moderator
    2022-02-10T15:59:26.053+00:00

    Hello @Kovács, Ferenc ,
    This issue is fixed , I just checked and it is working as expected .

    173271-image.png

    Thanks
    Himanshu

    -------------------------------------------------------------------------------------------------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.