Forum Discussion

acteno's avatar
acteno
New Member
10 years ago

Filtering by different data sources

Dear community,   after having set up a model that imports a time series (on 15min-base over at least one year) for one case I would like to extend that model now.   It would be neccessary to hav...
Need Help
Tutorial Requests
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi acteno,

 

Based on my understanding about your first question, the data model contains different users/customers/cases over a certain time. You want to query different results for different cases then present them in the report, right?

 

If that is a case, you can create multiple queries to retrieve data from one data model, then in Query Editor to modify each query to get expected data for each case.

Regarding the second issue, do you mean when you implement years from 2000 to 2010, actually only 2006 has data, but other years also contain the data? You can open Query Editor then find the column year, filter data only when year equals to 2006.

 

 

If issue persists, please share some screenshots to elaborate the issue.

 

Best regards,
Qiuyun Yu

acteno's avatar
acteno
New Member
10 years ago

Thank you Qiuyun_Yu,

 

this problem might be a bit difficult to explain and get, but fortunately we solved it by now.

Thanks for your kind help.

 

Best regards!

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    10 years ago

    Hi acteno,

     

    Glad to hear the issue has been resolved. :smileyhappy:

     

    Would you please share the solution here which will benefift the community who has the same issue?

     

    Thanks,
    Qiuyun Yu