Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost 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.

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
2 years ago

HI bhanu_gautam thank you for the reply but i try to find the solution you suggest, but no luck. Im using line chart, just renam the detailed to event and only the below list when i click the down arrow.

Thank you

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper 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.