Forum Discussion

LewisElliott's avatar
LewisElliott
Frequent Visitor
3 years ago
Solved

Setting up a Metric for Future Data

Hi,   I am trying to create a connected metric that will count surveys booked in the next month. I have a visual, below, that displays surveys that are booked on our system by month.      ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, LewisElliott 

    Make sure you have a calendar table and then add custom measure to calculate the number of surveys based on "YearMonth" field in the calendar table.

    If it doesn't work, please share a sample file for further research.

     

    Best Regards,
    Community Support Team _ Eason

LewisElliott's avatar
LewisElliott
Frequent Visitor
3 years ago

Hi,

Thanks for your reply. That's a nice solution and it makes sense. Can I select the measure directly when I am choosing what to connect my metric to, or do I still need to put that measure in a visual so that I can select it in this UI?

 

(apologies for my poor quality censorship)

v-easonf-msft's avatar
v-easonf-msft
Community Support
3 years ago

Hi， LewisElliott 

I'm not sure if the former is possible.

I would probably lean toward the latter.

 

Best Regards,
Community Support Team _ Eason