IBM Apptio

 View Only

 FIle Load Count-Iteration

Jump to  Best Answer
  • CostingStandard(CT-Foundation)
Anughya .'s profile image
Anughya . posted 02/16/23 01:51 AM

Hi All,

I need to store the count of a file, how many times its being loaded in a month? Is it possible to implement this logic?

Thanks in advance!!


#CostingStandard(CT-Foundation)
Jenny Franklin's profile image
Jenny Franklin posted 03/25/23 04:08 PM  Best Answer

Hi @Anughya ., check out the answer I posted here - lots of steps, though - hopefully, someone has a better way of doing this! 😵


#CostingStandard(CT-Foundation)
Mathieu Dupuis-Doiron's profile image
Mathieu Dupuis-Doiron posted 02/16/23 08:02 AM

Hello Anughya,

Could you help me with understanding your use case behind your question? Does it have to do with the freshness of your data? Or you are looking to have the actual number?

If it's about the freshness, you can find more information here :
https://help.apptio.com/en-us/boit/review-data-quality.html?Highlight=data%20freshness#datafresh 

Thanks!


#CostingStandard(CT-Foundation)
Anughya .'s profile image
Anughya . posted 02/17/23 01:44 AM

Hi @Mathieu Dupuis-Doiron

I'm looking for the actual numbers a file being loaded in a month.

As per business requirement, we need to automate this, so that whenever a particular file being load in Apptio, it will store the count. I tried to implement the logic, but didn't reach there exactly.

Iterations=If(Last Loaded Month>= Apptio Month,1,0)          This logic will provide the count as 1 if it's loaded, but not the exact number.
Thanks!!

#CostingStandard(CT-Foundation)
Mathieu Dupuis-Doiron's profile image
Mathieu Dupuis-Doiron posted 02/17/23 10:37 AM

Hi Anughya,

Let me dig deeper if I find something for you, but the answer is trending in a direction that it would not be possible.

I'll be back to you as soon as possible with a positive or negative answer.


#CostingStandard(CT-Foundation)

Related Content