Forum Discussion

EagerLearner's avatar
EagerLearner
New Member
3 years ago

Matrix report with Multiple dates

I have a visual below which is a Matrix report. For Rows, I have Current date - 1 as 1st row, Current month - 1 as Row 2, Current month in Row 3 and Current year in Row 4. This should be dynamic every month it should be changed Automatically.  Please help me with this. Reference pictures are below Any Idea on this amitchandak  

 

Thank you!

 

#matrixreport

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    EagerLearner , A calculation group of This day, This month , Last Month, This Year.

    Then all measure in another calculation group and edit table for that and add column for inbound, outbount and agent

     

    I have done something similar here. See if this can help

    Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

     

    if you do not like, this month, this day etc. We need have independent or extended table with today, this month, last month and year data and join with date table and use in visual

     

    Union (

    row("Date", today(), "Type", format(today(), "mm-dd-yyyy")),

    addcolumn(calendar(eomonth(Today(),-1)+1 , eomonth(today(),0) ), "Type", format([Date], "mmm-yyyy"))
    addcolumn(calendar(eomonth(Today(),-2)+1 , eomonth(today(),-1) ), "Type", format([Date], "mmm-yyyy"))
    addcolumn(calendar(eomonth(Today(),-1* month(Today()) )+1 , eomonth(today(),12 -1* month(Today())) ), "Type", format([Date], "yyyy"))
    )

     

    Join this table with the date table and from the visual remove the blank for this table. this should avoid the need for a calculation group of day and month formula . But the second one is still needed to group the measures