Suchergebnisse
Suchergebnisse:
Example: Showing prompt input with the UserResponse function. You have a report showing Year, Quarter and Sales revenue. The State object also appears in the report data, although it is not displayed. When the user runs the report they are presented with a prompt and they must choose a state. You want to show the state that they have chosen in ...
13. Dez. 2019 · 1. You need to create a variable to determine the number that fall into each comparison category. Then create another variable to count the number of rows that fall into each category. You need the optional "All" parameter in the count function so that the duplicate values are counted. Now you can create a table with your two variables on it.
20. Okt. 2017 · You can use @PROMPT function to show the relative dates to user and in WEBI you can write the code that will prepare the query as per the user selection. For E.g if relative date is YESTERDAY then you should write the code in WEBI where if YESTERDAY is selected then query need to be appended for previous date in query
25. Mai 2023 · I can get the max value to appear with: =Max([Sales revenue]) IN ([Store name]) This successfully shows me the highest sales revenue but what I want is the actual store name that corresponds to that value?
1. Okt. 2022 · A custom calculation sometimes contains only report objects, for example [Sales Revenue]/[Number of Sales]. Calculations can also include functions in addition to report objects. A function receives zero or more values as input and returns output based on those values. For example, the Sum function totals all the values in a measure ...
15. Dez. 2020 · You can use text alone in a cell, or mix formulas and text by using the plus (+) operator. If you want a cell to display the average revenue preceded by the text "Average Revenue:", the cell text is as follows: ="Average Revenue: " + Average ( [Revenue]). Note the space at the end of the text string so that the text and the value are not placed ...
What Are Queries in Intelligence Reports Advanced? Query is another word for question. In Marketing Cloud Intelligence, a query is a way to request information from a database. And with Intelligence Reports Advanced you can use the Queries tab to pull subscriber-level data and gain insights on data that is not available directly in your ...
