1.

I have one scenario like Year in integer and week in String and wanted to calculate the YTD.. how to do this.?

Answer»

A perspective that displays key progress indicators (KPIs) can readily be created. To do so, you can finish the following assignments: With the areas to be measured, create the base perspective. Construct a calculated field that sets out the figure you are measuring for the information that you evaluate. The Tableau uses forms specifically intended for KPIs. Two steps are taken to create a calculated field:

The first STEP includes-

  • Click the drop-down to the right of Dimensions on the Data pane and SELECT “Create > Calculated Field” to OPEN the calculation editor
  • Name the NEW field and create a formula. Take a look at the example.

The below example shows how to build a KPI view that shows a green checkmark for any sales figure over $125,000, and a red X for any sales figure under $125,000.


Discussion

No Comment Found

Related InterviewSolutions