Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Average based on drill down or up when using a measure

I want to get the people that are ill visualized in a line graph diagram. Currently I can visualize the correct numbers for each day. Although when I drill up to the week level or even month level I ...
Need Help
CharbelArmaleh's avatar
CharbelArmaleh
Icon for Resolver II rankResolver II
3 years ago

Hello

 

try to use "isinscope"

ex: if(isnscope([day], [day measure], [month measure])

 

Did i answer your question? Please mark it as solution!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I actually don't know how to create the month measure for it. I know how to get the count of sick people per day but I don't know how to show the average of ill people per week or per month. Do you have any suggestions based on my measure I created above.