Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Line chart question

I’m trying to create a report and need some help. I have data for current user sessions for every minute. On the line chart I can currently show count of current of user sessions for every minute wit...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous,

 

It seems that you want to create the slicer with 15 mins, hour, day , week and month values to filter the value in line chart.

 

However, I'm a little confused about your scenario. Is the count column a calculated column or measure? Do you create the date range with Count column or createddatetime?

 

If it is convenient, please share your desired output so that we could help further on it. In addition, more data sample will describe your scenario better.

 

Best Regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

     

    Hi Cherry  (v-piga-msft)

    Thanks for your time.

     

    So the data is from Azure Analysis Services for current user sessions. I currently have data in minute granularity and count column is neither calculated column or measure it is a column resulted from Azure Metrics  for current user sessions.  So right now the data I get is like this for every minute(CreatedDateTime), number of users logged(count column) in . Now I want to add slicer for 15 mins , 30 mins, hour, day and month and Then this count column should show sum of count for 15 mins/30mins/hour. I will try to get more sample data by end of the day and will get screenshots of how output should be.

     

    Thanks,

    Sree