Alphcast

Lucia Zalba

@luciazalba

Customer Success Analyst

Joined
November 2023

luciazalba's insights

  • byluciazalba

     - 1 minute to read

    Tables in Alphacast

    chart

    From a Dataset: In the toolbar, click on the Transform Data button to enter the data transformation interface: Pick the Select Columns step to choose the columns you want to display in the table. From a Pipeline Search for or select the variable you want and click on Save In the Select Column step, click on Add Step to add another step to the pipeline. Add a Filter Dates step to select the period you want to display in the table. Select Relative Dates to determine the term and period and you want to view and then Save Finally, add a Create Table step and configure the table to your liking. Here’s the link for you to explore different types of tables and clone them to follow the step-by-step process. Congrats! You have successfully created a table. We invite you to see how to configure your table in the following...

  • byluciazalba

     - 1 minute to read

    Importing data into Excel

    chart

    Excel allows to add data from different sources. We offer our Alphacast Excel Add-In to simplify the process of downloading data. However, some customers may not have the chance to install an Add-In. Here you can find an alternative way to embed data into Excel, by using our TSV data source: Getting TSV download links When you navigate through Datasets in Alphacast, you will find a Download link. If you filter variables, download links will consider variables selection, and only filtered variables will be downloaded. You will now find an option to download Tab Separated Values (TSV), which can make it easier to embed data into Excel: Right click on the TSV Download link, and choose "Copy Link Address". You will notice the URL already has your personal api_key, and should not be shared publicly with other users, outside your team. Now go to Excel, and select Get Data -> From Other Sources -> From Web, and enter the URL you copied from Alphacast website. The Excel team published a super easy video, describing how to do...