Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Jayz1489
Contributor II
Contributor II

Store each month data but data is updated in the excel sheet daily.

Hi,

I have to record the count of the licenses acquired each month. However, every time a report is fetched from the license portal, it gives the list of current licenses in use without a date.

I have reports fetched over a year on the first week of every month.

Now I have to create a dashboard which shows The count of licenses every month and monthly comparison over time (increase and decrease every month).

 

I am unable to figure out how to go with the data source because there are too many data files. 

I don't see it as a good approach to upload a file every month.

Can someone please help me with the approach?

 

Thanks

Labels (4)
1 Reply
JordyWegman
Partner - Master
Partner - Master

Hi,

Do you have all files and are they stamped with a date? So can you differentiate between March and April?

Jordy

Climber

Work smarter, not harder