How can I extract a 3 month data from a 5 year module .

meshivam
meshivam
in Academy Discussions

Best Answers

  • Dikshant
    Dikshant
    Answer ✓
    Can you share move details ? Like you can do TIMESUM if you want to aggregate the data for those 3 months, or you can use IF ELSE Statement if you want to fetch the data by time dimension.

  • Javvaji45
    Javvaji45
    Answer ✓

    @meshivam

    You can create a Saved View for which three months of data is required. Use the export action to extract the data. If you need it for future use, save the option. To make the Saved View dynamic, use the filter from the SYS Time Setting module. Create a Boolean line item dimensioned by months and use that Boolean to apply the filter in the Saved View. This will help you make the Saved View dynamic

    do let me know further any help required

  • PulkitChawla
    PulkitChawla
    Answer ✓

    @meshivam - For extracting data for only 3 months, we need to create a saved view and a dynamic filter to select which months data you want.

    These boolean formatted months will be dynamic and data can be extracted for any months.

Categories