Skip to main content
Solved

Using something similar to the formula Today() in Excel

  • August 23, 2022
  • 8 replies
  • 831 views
J
Master Trendsetter
Forum|alt.badge.img+2
  • JoseMaster Trendsetter
  • Master Trendsetter
  • 22 replies

Dears,

 

I am trying to filter by the current month in each of the metrics, I would use TODAY() function in excel, but since there is no function like that on Pigment. 

As a workaround I created a metric that I called Current Date (Month Dimension) , which I will update monthly, so that I can filter by that metric and automatically update all the other metrics.

 

IF('MRR Be Churn Analysis'=1,TRUE)[FILTER:'Data Hub'::Month='Current Date']

 

However, I did not work, do you have any suggestion or guidance?

 

Thank you very much in advance!

 

Jose

Best answer by Benoit

Hi Jose, 

This is a good workaround that should work given you have the month dimension in your metric’s structure.

[filter:Month='Current month'] or even [Month='Current month'] should filter the data on your current month.

When you say ‘it did not work” what error message do you have?

 

Furthermore, please note we are working on a solution for this TODAY() function 😊

Thanks,

Benoit

    8 replies

    Benoit
    Community Manager
    Forum|alt.badge.img+15
    • BenoitCommunity Manager
    • Community Manager
    • 232 replies
    • Answer
    • August 23, 2022

    Hi Jose, 

    This is a good workaround that should work given you have the month dimension in your metric’s structure.

    [filter:Month='Current month'] or even [Month='Current month'] should filter the data on your current month.

    When you say ‘it did not work” what error message do you have?

     

    Furthermore, please note we are working on a solution for this TODAY() function 😊

    Thanks,

    Benoit

    Benoit - Pigment wizard
    J
    Master Trendsetter
    Forum|alt.badge.img+2
    • JoseMaster Trendsetter
    • Author
    • Master Trendsetter
    • 22 replies
    • August 24, 2022

    Hello Benoit,

     

    Thank you very much for your reply!

    It seems to not be filtering anything, do you have any idea of what can I do?

     

     

    BR,

    Jose

     

    Benoit
    Community Manager
    Forum|alt.badge.img+15
    • BenoitCommunity Manager
    • Community Manager
    • 232 replies
    • August 25, 2022

    Hi Jose,

    The formula looks good to me. The filter will not automatically hide the column where there’s no data, it will just display data in the filter column, so in this case in the Month corresponding to your ‘Current Date’ metric.

    To try you can use the view dynamic filtering panel and hide empty rows and columns.

    If you don’t have any results for the given month, please ensure your data ‘MRR be churn analysis’ should return results. Otherwise, I suggest you to create a Support ticket to we can have a look within your model.

     

    Please let me know.

     

    Best,

    Benoit

    Benoit - Pigment wizard
    O
    Wallflower
    Forum|alt.badge.img
    • ostaigerWallflower
    • Wallflower
    • 3 replies
    • January 11, 2023

    Workaround for those interested: create a report in salesforce where the only column is a formula for TODAY(). Connect this to Pigment and set the schedule to import daily.

    It would be very helpful to have this simple feature available in Pigment natively!

    Chris
    Wallflower
    Forum|alt.badge.img+14
    • ChrisWallflower
    • Wallflower
    • 385 replies
    • January 12, 2023

    @ostaiger    We recently added the add load date functionality.  If you already have an import scheduled, you could easily turn this on. 

    Chris
    Dmitrii
    Master Trendsetter
    Forum|alt.badge.img+5
    • DmitriiMaster Trendsetter
    • Master Trendsetter
    • 19 replies
    • July 14, 2023

    Furthermore, please note we are working on a solution for this TODAY() function 😊

    @Benoit are there any updates on the TODAY() function?

    Benoit
    Community Manager
    Forum|alt.badge.img+15
    • BenoitCommunity Manager
    • Community Manager
    • 232 replies
    • July 17, 2023

    Hi Dmitrii,

    Unfortunately not, no update on this function so far, but there are workarounds, just like Ostaiger described above.

    Many thanks for your patience and understanding.

    Benoit - Pigment wizard
    E
    Apprentice Trendsetter
    Forum|alt.badge.img

    Hi Dmitrii,

     

    There is a simple workaround in Pigment available with the metric to metric function.
    You can have two metrics. 
    Metric 1: Formatted as date.
    Metric 2: Formatted as date, but with formula metric +1

    Then have a metric to metric copy of Metric 2 copy to Metric 1 and schedule that daily at the moment that you want to update the current day. It's not the same as today(), but at least it is all solved within Pigment.


    Ask your question here!

    Terms & ConditionsCookie settingsAccessibility statement