BookmarkSubscribeRSS Feed
Lorena1w
Calcite | Level 5

Olá 

Gostaria de saber se seria possível colocar o nome das colunas dinâmico. Considere a seguinte situação:

Suponhamos que fizemos as duas colunas calculadas – medidas - (Venda Atual e Venda Anterior). Teremos um filtro de ano, ou seja, se o usuário escolher um ano = 2016, teríamos o seguinte cenário:

Venda Atual = Venda do ano selecionado. No caso, uma venda referente a 2016.

Venda Anterior = venda ao ano selecionado -1. Ou seja, a venda referente a 2015.

 

Considere que o gráfico selecionado foi uma tabela de referência cruzada.

Teria como o nome das colunas (venda Atual e Venda Anterior) serem dinâmicos. Ou seja, aparecer (Venda 2016, Venda 2015), considerando que o usuário selecionou 2016 no filtro.

 

----------------------------------------------------------------------------------------------------------------------------------------------------

 

Hello

I wonder if it would be possible to put the name of the dynamic columns. Consider the following situation:

Suppose we have made the two calculated columns - measures - (Current Sale and Previous Sale). We will have a year filter, that is, if the user chooses a year = 2016, we would have the following scenario:

Current Sale = Sale of the selected year. In this case, a sale related to 2016.

Sale Previous = sale to selected year -1. That is, the sale related to 2015.

 

Assume that the selected chart was a crosstab.

It would have like the name of the columns (Current sale and Previous sale) to be dynamic. That is, to appear (Sale 2016, Sale 2015), considering that the user selected 2016 in the filter.

 

 

ex.pdf.PNG

3 REPLIES 3
Lorena1w
Calcite | Level 5
SASKiwi
Opal | Level 21

The only suggestion I can think of right now would be to add a dynamic text object above your cross-tab that is linked to your filter so it would display the filter value like "Sales 2017 versus 2016".

Creeback
Fluorite | Level 6

Crosstab:

 

Crosstab.png

 

Vars:

Var.png

 

Crosstab Filter (with parameter):

 

Object Filter.png

 

*The Drop Down contains datetime parameter.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 698 views
  • 2 likes
  • 3 in conversation