Forum Discussion

Stathis's avatar
Stathis
Frequent Visitor
7 years ago

Replace a table value with another based on a specific date (when refreshing or publishing)

Hi everyone,   I am new to the bi platform and I am trying to figure out a way to combe three different reports (daily,weekly,monthly) into one. The reports are more or less the same besides some v...
Need Help
Tips and Tricks
Stathis's avatar
Stathis
Frequent Visitor
7 years ago

Anonymous

Xiaoxin Sheng,

Thank's a lot for your reply. It really helped me understand Dynamic Attributes based on a slicer.
 
I tried to add to the dynamic slicers time intervals (day-week-month) and in this way to combine 3 different reports (daily-weekly-monthly) into one (this is my purpose).

This method, includes the creation of a table with static time intervals day,week,month (month=30 days), and I have the above limitations:
1) Changing the output of a visual: I would like to automatically demonstrate 2 basic metrics in my daily report, 3 metrics (the 2 basics plus 1 new) in my weekly report, and 4 metrics in monthly report. The purpose here is the columns of my visualization (matrix) to be adjusted by the choice of the slicer.
2) If I set up dynamic time slicers (for example month) the time interval is inaccurate in most cases (closing months are 28-31 days so the selection of 30 days is inaccurate).


Any extra help will be much appreciated!
Best Regards,
Stathis

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Stathis,

 

#1. I'm not so clearly for this requirement, can you please explain more detail?
#2. You can try to use date function to manually define dynamic month range.

 

For example:

Replace Column =
VAR currDate = xxx //specific date
RETURN
    CALENDAR (
        DATE ( YEAR ( currDate ), MONTH ( currDate ), 1 ),
        DATE ( YEAR ( currDate ), MONTH ( currDate ) + 1, 1 )
            - 1
    )

 

Above formula will dynamic get accurate month range based on inputted date dynamic.

 

Regards,
Xiaoxin Sheng