Create Curved line chart in Tableau
Автор: ArtOfData
Загружено: 2024-11-10
Просмотров: 1618
Creating the curve line chart in Tableau :
Period Value :
Date(Datetrunc('month',[Order Date]))
TC_Sales_Value
WINDOW_MAX(SUM({ FIXED MONTH([Order Date]), YEAR([Order Date]),[Segment]:SUM([Sales])}))
TC_Next_Sales_Value
LOOKUP([TC_Sales_Value],1)
TC_Sales_Value
WINDOW_MAX(SUM({ FIXED MONTH([Order Date]), YEAR([Order Date]),[Segment]:SUM([Sales])}))
Parameter : Points : 2 to 100 step size 1
T (copy)
IF [Index_Cycle] = 1 THEN ([Index]-1)/([Points]-1) END
T
([Index]-1)/([Points]-1)
Index
INDEX()
Index_Cycle
INDEX()
Densificator:
DATEPART('day',[Order Date]) % 2
Path:
[Densificator] * ([Points]-1)
N = 3
Incrementor
[N]*([N]+1)/2 * [T]^([N]+2) -[N]*([N]+2)* [T]^([N]+1) + ([N]+1)*([N]+2)/2*[T]^[N]
CURVE LINE:
IFNULL([TC_Sales_Value]+([TC_Next_Sales_Value]-[TC_Sales_Value])*[Incrementor],
[TC_Sales_Value])
Sales Label
IF [Index]=1 THEN [TC_Sales_Value]
// Or Use the below Mentioned Calculation
ELSEIF [Index]=1 AND [Index_Cycle]=1
THEN [TC_Sales_Value]
END
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: