Skip to main content
Solved

How to extract the any columns data based on date value of the Nth occurence

  • July 29, 2022
  • 4 replies
  • 135 views
M
Data Voyager
Forum|alt.badge.img+1

I am doing POC to adopt ataccama, please help me out on this requirement

Requirement:

Previous and current run data validation.

For example:

what is the threshold of yesterday sales or one week back sales and todays sales

 

Best answer by Anonymous

Hi @mukesh ,
Thank you for your question!


My colleague @DannyRyan ‘ve created a plan with comments for you - please see attachment. 

Hope you find it helpful.
Adél
 

Mukesh
Catherine
S
Maxim Kim

4 replies

M
Data Voyager
Forum|alt.badge.img+1
  • mukeshData Voyager
  • Author
  • Data Voyager
  • July 29, 2022

other example e.g

Previous to current data validation - sum(key measure)

Previous to current data validation for checking duplicate

Mukesh
Catherine
A
  • Anonymous
  • Answer
  • August 2, 2022

Hi @mukesh ,
Thank you for your question!


My colleague @DannyRyan ‘ve created a plan with comments for you - please see attachment. 

Hope you find it helpful.
Adél
 

1 Attachments
DannyRyan
Catherine
M
M
Data Voyager
Forum|alt.badge.img+1
  • mukeshData Voyager
  • Author
  • Data Voyager
  • August 4, 2022

Many thanks @adeka and @DannyRyan ,  looks like this plan has been build on 13.x and I have 11.x,

so this plan is not working at this version.

Will it work in 12.9 as my Client is using this version only, but I do not have the access right now.

I will get back to you soon.

 

Thanks again,

Mukesh

Mukesh
S
Data Pioneer L2
Forum|alt.badge.img+3
  • Siva_MadhavanData Pioneer L2
  • Data Pioneer L2
  • September 21, 2022

good info @Adela Sotonova 

Community Terms of Use & ConditionsCookie settingsAccessibility statement