Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
2 years ago
Solved

IF calculated column

Hi good day, can anyone help me on can i achieved the result i want. i have a table -IF the date is lessthan today and the detailed column is blank change "red" my marker -IF the date is near (30 d...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    AllanBerces , I thought you are using Table , you can create a  calulated column for line chart by going to modelling tab and select new column

    Color =
    SWITCH(
    TRUE(),
    AND([Date] < TODAY(), ISBLANK([Event])), "Red",
    AND([Date] <= TODAY() + 30, ISBLANK([Event])), "Red",
    AND([Date] > TODAY() + 30, ISBLANK([Event])), "Black",
    OR([Event] = "Actual Received", [Event] = "Done"), "Green",
    AND([Event] = "Updated date", [Date] > TODAY() + 30), "Black",
    AND([Event] = "Updated date", [Date] <= TODAY() + 30), "Red",
    "DefaultColor" -- Default color if none of the conditions match
    )

     

    Go to the Report view and select your line chart.
    In the Visualizations pane, drag the new Color column to the Legend field well.
    This will create separate lines for each color category.
    Customize the Colors:

    Click on the line chart to select it.
    In the Visualizations pane, click on the Format (paint roller) icon.
    Expand the Data colors section.
    Assign the desired colors (Red, Black, Green) to the corresponding categories.

bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

AllanBerces , I thought you are using Table , you can create a  calulated column for line chart by going to modelling tab and select new column

Color =
SWITCH(
TRUE(),
AND([Date] < TODAY(), ISBLANK([Event])), "Red",
AND([Date] <= TODAY() + 30, ISBLANK([Event])), "Red",
AND([Date] > TODAY() + 30, ISBLANK([Event])), "Black",
OR([Event] = "Actual Received", [Event] = "Done"), "Green",
AND([Event] = "Updated date", [Date] > TODAY() + 30), "Black",
AND([Event] = "Updated date", [Date] <= TODAY() + 30), "Red",
"DefaultColor" -- Default color if none of the conditions match
)

 

Go to the Report view and select your line chart.
In the Visualizations pane, drag the new Color column to the Legend field well.
This will create separate lines for each color category.
Customize the Colors:

Click on the line chart to select it.
In the Visualizations pane, click on the Format (paint roller) icon.
Expand the Data colors section.
Assign the desired colors (Red, Black, Green) to the corresponding categories.