Forum Discussion

MrJames76's avatar
MrJames76
Frequent Visitor
4 years ago
Solved

Concatenate and summarize a field based on dynamic input

Hi all,   I'm trying to figure out if I can pass a date from a date slicer into a measure, calculated field, or calculated table that concatenates the relevant rows and allows me to count/sum other...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my solution workbook from here.

    Hope this helps.

danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

Hi MrJames76 ,

By "table", do you mean as a visual or a calculated table? The latter is static and will not change until you modify the formula behind or refresh the dataset.

MrJames76's avatar
MrJames76
Frequent Visitor
4 years ago

Thanks danextian! I mean as a visual (I think). At it's simplest there are only two elements on the tab/page - a date slicer which defines the specific date I'm interested in, and a table or matrix that shows the product combinations, customer count, and ARR.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    Is it fair to assume that you will select a particular month (such as April 2021) or do you want to be able to select a spsecific date such as April 23, 2021?  Please clarify.

    • MrJames76's avatar
      MrJames76
      Frequent Visitor
      4 years ago

      Ideally I can pick a particular date, but if that's not reasonable I could live with a period - would just have to decide on date within the month presents the month (i.e., if a customer cancels on April 15th are they counted in April or not - very much a run-rate analysis vs. a recognized revenue analysis).

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        4 years ago

        Hi,

        You may download my solution workbook from here.

        Hope this helps.