Solved

Using something similar to the formula Today() in Excel

  • 23 August 2022
  • 3 replies
  • 54 views

Userlevel 1
Badge +1
  • Enthusiastic Pigmenteer
  • 21 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

icon

Best answer by Benoit 23 August 2022, 17:34

View original

3 replies

Userlevel 3
Badge +4

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

Userlevel 1
Badge +1

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

 

Userlevel 3
Badge +4

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

Reply